Dear Community,
I have an app to track the Recruitment Process.
A Table called โRecruitmentโ.
Once the CV is accepted, then the candidateโs name is included in the Recruitment Form.
After each round, the next immediate roundโs Action items (Selected / Rejected) are shown & just the corresponding interview date.
If the candidate is rejected, the other action items should not be shown.
I have tried this using Actions but, I couldnโt achieve the exact outcome. I have tried using Slices to split the Recruitment view as per the Interview round. But, I am not sure whether itโs necessary.
Attaching the screenshots for your perusal.
HR Screening Round (1st Round)
Next roundโs Status should be shown as just Actions (Selected / Rejected)
I could get the actions shown but, I would like only the Next Roundโs Actions & not all (in a consecutive way).
Now, I need help in achieving this.
This is how the Dashboard looks.
Thank you.
Solved! Go to Solution.
HR Screening Selected
ISBLANK([HR Screening Status])
HR Screening Rejected
ISBLANK([HR Screening Status])
Technical Round Selection
AND([HR Screening Status]=โSelectedโ,ISBLANK([Technical/Skill Status]))
Technical Round Rejection
AND([HR Screening Status]=โSelectedโ,ISBLANK([Technical/Skill Status]))
Final Round Selection
AND([Technical/Skill Status]=โSelectedโ,ISBLANK([Final HR Round Status]))
Final Round Rejection
AND([Technical/Skill Status]=โSelectedโ,ISBLANK([Final HR Round Status]))
I hope I havenโt missed anything
I think I understand. So for maximum flexibility in the form, use Show_IF functions for each column. But note that you canโt change on the fly the columns in a view. If a Show_IF function is hidden in a form, it will show on a view if youโve got it to show that column at all
Thank you Simon for your reply.
Exactly,that is where iโm ending! I couldnโt achieve this as for the next round,previous round details are also shown as that condition is matched.
Hi,
Actions:
CV Details:
Recruitment:
Dashboard:
Thank you.
These ones are your views.
I need to see your actions.
You can find them under the behaviour section
First round
Technical Round
Final Round
In all these, I need,
That particular interview date to be manually selected via a date field in the form which should be available only AFTER the selection of previous round.
The option of Selection / Rejection of the current round ONLY be visible the after previous round selection.(I am having all the actions visible)
Then, the list selected candidates shall be available for the Document Submission & next On-Boarding process which I have completed.
Thank you Alex for your support & time.
HR Screening Selected
ISBLANK([HR Screening Status])
HR Screening Rejected
ISBLANK([HR Screening Status])
Technical Round Selection
AND([HR Screening Status]=โSelectedโ,ISBLANK([Technical/Skill Status]))
Technical Round Rejection
AND([HR Screening Status]=โSelectedโ,ISBLANK([Technical/Skill Status]))
Final Round Selection
AND([Technical/Skill Status]=โSelectedโ,ISBLANK([Final HR Round Status]))
Final Round Rejection
AND([Technical/Skill Status]=โSelectedโ,ISBLANK([Final HR Round Status]))
I hope I havenโt missed anything
@AlexM, I tried but itโs not showing anything.
I just wonder what I am supposed to do?
I would like the Actions to be shown based on the rounds. And, once that round is over & date is selected. Next time, whenever the CV # is selected, the previous round need not be shown again or shall be showing what is already selected.
Thank you.
Is it here that you have wrote the formulas?
Yes! Exactly.
I think it has to do with the UX & Slices donโt you think?
I have tried Show_if but, not helping.
Probably, ur help in Slices might help.
Thank you.
Do you have an initial value on that column?
No!
Wait wait wait!
What is it that itโs not happening?
The show/not show of the actions or the show/not show of the fields?
The formulas are only for the actions to be visible according to the round.
Field visibility, thatโs โour round twoโ .
For that I have linked those two topics above.
So:
Are the actions visible as desired?
Actions!, which automatically fill the fields viz, status of the current round!
But, my requirement is that, the field of the previous round need not be shown.
Both are not working!
To be precise, the logic should be, I would just select either of the action, the date & status are automatically updated & the next round view should be visible for the particular cv selected next time.
I understand what you mean but:
1.Those formulas were for the โbuttonsโ visibility only.
2.For the fields to act as you want, you can find the answer in those two topics.
You need to use Show type columns.
Canโt understand why the actions are not behaving as expected but I will make an example app later today.
Great Thanks.
However, share your email id, I shall include you as a collaborator so that u shall be able to work on this app.
Thank u @AlexM.
This topic might be useful too: (using show columns)
and this one: (using valid if to eliminate the ones that have not passed)
Sure @AlexM Thanks
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |