Hey I had a question, is there any way to prevent double bookings if you are using Google Calendar with multiple users? I saw some things on the board, but didn't know if this issue had been addressed in any way. I know that you can't lock a row, add time to an action (was thinking about a timer), or get the program to do a refresh after the action sequence, but I don't think you can do it. I even thought about using automation in some way, but the same issue always occurs where it has to sync in order to check to see if it can do the specific action so it becomes useless. I'm just trying to think about or know a way to work around this issue, any help would be appreciated, thanks
Since AppSheet supports Offline usage and it doesn't support RealTime database, your best bet would be another table with "requests" and only one person can check and then aprove.
Another similar solution is to create a bot that checks and books just the first request for an specific timeframe or similar.
You can use UTCNOW() to add a datetime to each request and order it from oldest to newest
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |