Counter in browse screen to manage waiting room.

[yvesf]

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.

[kev1n]

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.

[yvesf]

Perfect answer, thx Kev1n