Hello,
I have multiple checklists that should be filled by the employee's between different time duration and twice a day.
- Example: Checklist A should be filled between 6AM - 11AM and 2PM - 6PM
- Checklist B should be filled between 3PM-4PM and 5PM - 6PM
The main purpose is that when the employee open's the form where he wants to select the checklist, the one that will be displayed in the LookUp view is the one that falls under the same duration of the employee timeZone.
- Example:If the employee's current time is 6:21 AM Checklist A will be visible and checklist B should not show in the lookup view.
What do you suggest as a solution to implement the above requirements in an effective way?
I thought about two different options but I am still confused about which one I shall proceed with:
- Having a scheduled workflow on Power Automate that triggers every 1 hour -> compare current time vs checklist setup -> If it meets the criteria I can set a toggle that indicates if it should be visible Yes/No -> OnLoad of the form where the employee will fill out the checklist the only records that will be showing are the ones visible = true.
OR
- Having a JS onLoad of the form which grabs the current user timeZone -> checks the setup vs current time-> filters the lookupView according to the needed criteria.
Any help is greatly appreciated.
Thank you!
