I want to create a dynamic picklist, where I will check boolean from a line item, only true values will allow me to select list items else on default it wont show anything.
For example:
Assume a scenario where I want to assign at least 1 employee who is present in my office to become the pantry inspector & review the pantry snacks for the day. I am free to choose any employee from any department.
(all employees email-ID are mapped to their departments under a hierarchical list like: All company → department names → email-IDs).
My rows will have department names and columns will have line items for reporting and calculation of logic required.
So, today if I select department "Engineering" from the Boolean line item; at the picklist line item, I should only see the employees from Engineering who are present that day.
Tomorrow if I select both Finance & HR department from the Boolean, I should only be able to see employees from Finance & HR respectively present that day.
(I'd like the solution to be dynamic & formula driven so that I don't need to manually run any import actions as such)
Note: Every morning at 11am a scheduled "Cloudworks" job runs which marks their attendance and updates the email-ID list's subset called "Present Today", so employees need to check a Boolean before 10:30am everyday from a dashboard which maps to the subset. This information shows which all employees are present today so that at 4pm in the evening I can assign at least 1 pantry inspector to review snacks for the next day.
Let me know how can I build this scenario if it is achievable. I have tried to visualize the scenario. ☺️Please don't judge my paint skills lol.