I was wondering how to do it. I have a restaurant where I have 15 tables for 5 seats. if I make a reservation for 8 people, I have to use two tables of 5 but ten places would be occupied. so how to let people know that the seats are 10 and not eight?if you have ideas to propose Iโm here that I think about how.Iโll tell you right away that if I have a yx field I can have an image of the tables and then in the administration I can decide which tables to assign. how would you do?
You need to use the Ceiling() function.
Something like this:
Ceiling([Number of People]/5.0)
Ceiling(10/5.0)
==== 2 Ceiling(8/5.0) ==== 2 Ceiling (1.6) === 2
Good, now i test
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |