Using condition to warn/suggest user

P_S — Sat, 16 Nov 2024 02:57:58 GMT

Hi all,

I am trying to create the condition to check the shift of workers. If the worker who has name on that shift shouldn't taking care more than one room on the that shift. And worker cannot work for 24 hours, they can work 2 shifts on the same day or 2 days like Noon and Midnight shift. Each condition can be separate. Is that possible?

I also attach qvf file with this post.

Thanks in advance

Re: Using condition to warn/suggest user

P_S — Mon, 23 Mar 2020 07:39:57 GMT

Any Suggestion?

I am trying to use this condition

=If(Date_1 = Date(Date(Date_1)), If(Shift = Shift, If(Count(Total ID) > 2, 'Good', 'Bad')))

But all result show as "Good". It cannot show who has the shift and got 2 rooms as "Bad". Where do I miss?

**I change Date field name into Date_1**

topic Using condition to warn/suggest user in App Development

Using condition to warn/suggest user

Re: Using condition to warn/suggest user