Hello,
I want to create a HR application for applications and open positions.
I create 3 lists:
1 / Posistions
2 / Candidates
3 / Application on positions
I was inspired by the model "My expense", so list 3 contains the following columns:
'ID_Positions': search for item in the list (1)
'ID_Candidates': search for item in the list (1)
'Status': Text
I want to create two forms that take the IDs of the selected elements.
That is to say when I am on a candidate, I wish to position it on a post that column 'ID_Candidates' takes again the ID of the candidate selected in the gallery_candidates.
And conversely when I'm in a Positions and I wish to add a candidate, I want the ID of the selected Postions to be the one of the form 'ID_Postions'.
I went on the following formula for my formulars:
Patch (Application on postions; {'ID_Positions': Text (cardvaluePOSITIONS.value); 'ID_Candidates': GalleryCANDIDATES.selected.ID;
'Status': "New"})
I think it's a syntax problem.
Can you help me ?
Solved! Go to Solution.
Hello,
Thanks for your feedback! @yashag2255 @Jeff_Thorpe
Thanks for the correction of the formula PATCH> Default
Unfortunately, the formula does not work, because you need a record type result for ID-Candidate or ID_Postition and I enter a result of type number ...
In short, I found a solution!
I changed my type of column in the SP, I have no more column type "search in the site", I always replace by type TEXT colones.
So my formula is now:
Patch ('Application on postions'; Defaults ('Application on postions'); {'ID_Positions': Text (cardvaluePOSITIONS.value); 'ID_Candidates': GalleryCANDIDATES.selected.ID;
"Status": "New"})
Thank U!
If you are trying to create a new record using Patch() then you are missing the second parameter.
Example of creating a new record: Patch('Application on postions'; Defaults('Application on postions'); {'ID_Positions': Text (cardvaluePOSITIONS.value); 'ID_Candidates': GalleryCANDIDATES.selected.ID; 'Status': "New"})
Hi @Glaga
Hello,
Thanks for your feedback! @yashag2255 @Jeff_Thorpe
Thanks for the correction of the formula PATCH> Default
Unfortunately, the formula does not work, because you need a record type result for ID-Candidate or ID_Postition and I enter a result of type number ...
In short, I found a solution!
I changed my type of column in the SP, I have no more column type "search in the site", I always replace by type TEXT colones.
So my formula is now:
Patch ('Application on postions'; Defaults ('Application on postions'); {'ID_Positions': Text (cardvaluePOSITIONS.value); 'ID_Candidates': GalleryCANDIDATES.selected.ID;
"Status": "New"})
Thank U!
Hey @Glaga
Glad that you were able to resolve. If this issue is solved, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
User | Count |
---|---|
179 | |
120 | |
87 | |
44 | |
41 |
User | Count |
---|---|
245 | |
156 | |
128 | |
77 | |
73 |