55
Hi All,
Requirement: I have 2 values in dropdown value naming "A-Shift" and "B-Shift". Now i want to autopopulate Shift names based on time criteria. If a user has logged in the app between 7:00 A.M to 7:00 P.M the dropdown value will automatically say Shift A and if the user logs in between 7 P.M to 7 A.M the dropdown value should capture Shift B.
How can i achieve this?
Thanks in advance!!
Hi, this should do the trick, you now longer need a dropdown, you could just have a label or even hide it from the user completely.
If(Value(Text(Now(),"HH")) > 07 && Value(Text(Now(),"HH")) < 19,"Shift A ","Shift B")
Share
Report
All responses (
Answers (
