My use case:
A booking app where 100 people can do reservations of a table in two different buildings. The user is actually reserving a space for his team - not a specific table. It is restricted in the app that there cannot be done more than 68 reservations - equaling the number of tables in two buildings.
2 buildings - one with 30 table and one with 38 tables
Some people are working from home - as example team1 consists of 12 people but only 5 people will work on-site. So it is dynamic on each day how many people from each team that is onsite.
Distribute the teams in the two buildings so no team is divided into two different buildings.
Do you think this can be done by Glide logic - or would you need to do some scripting in Google sheets to optimize the table allocations between teams.
Do you have suggestions how to go about getting the teams distributed. Thanks a lot