nuBuilder Forum

Posted: **Sat Dec 25, 2021 5:24 pm**

I would like to have a counter in a browse screen that calculates the waiting time for a client.
A client comes to an appointment. When the client arrives in the waiting room, the assistant mentionned that the client is arrived and a counter starts.
We would lilke to sort client list by waiting time to limit confusion in the waiting room. Having that information directly accessible and be able to sort this column would be an elegant solution. Any idea about how to perform that ? thx for your help.

Posted: **Sat Dec 25, 2021 6:04 pm**

By counter you mean the difference (in minutes) between the time now and the time the customer arrived?

Add a calculation in a Display column like

Code: Select all

TIMESTAMPDIFF(MINUTE, `cus_arrived_at`, NOW())

To refresh a Browse form in a certain interval, look here.

Posted: **Sat Dec 25, 2021 6:56 pm**

Perfect answer, thx Kev1n

nuBuilder Forum

Counter in browse screen to manage waiting room.

Counter in browse screen to manage waiting room.

Re: Counter in browse screen to manage waiting room.

Re: Counter in browse screen to manage waiting room.