Building a Conference Room Scheduling Solution with good UX?

[PhilTheThrill]

Hey there!

My boss hit me up and asked if AppSheet was an appropriate solution for booking conference rooms at our company HQ.

The basic idea is that there will be a tablet in front of each conference room displaying today’s bookings. You can then add your own booking for the day (or log into the app and schedule a booking for next week or whatever).

I found a sample app for this application but they had hard-coded every half hour block into their data table and had users sign up to “own” those blocks. It does solve the problem… but we have two conference rooms and 10 “guest offices”, so that would be twelve spaces times sixteen blocks for, what, like 330 days every year? 192 rows per day, 63,000ish per year?

Is that actually the optimal way to handle something like this? Not only does that seem cumbersome to set up, if someone needs a 3 hour meeting, they have to have six “interactions” to book out that amount of time. (Also, the sample app is a couple years old I think, so are there new AppSheet features that might go well with this project?)

Obviously I don’t want you to do my work for me, but if you have any insights on whether is this is truly the right way to approach this problem, I’m all ears!