Appsheet or google sheet - timed action

[Mike_T]

I have a calendar of appointments and I want to “cancel” the appointment if it hasn’t been confirmed 36 hours before it occurs. There are only 2 appts per day…10:30am and 6pm. The action needs to do the following…

1. if(useremail appears in [confirmed by],true = do nothing, blank = step 2
2. remove info in 3 columns (timestamp, booked by, booking type)
3. move [waiting list] into booked by, add timestamp and booking type
4. delete [waiting list] value

My question…would this be better to write a script in google sheets to accomplish this or does appsheet have this ability to execute time based actions?

[Marc_Dillon]

Mike_T:

or does appsheet have this ability to execute time based actions?

help.appsheet.com

Reports

Generate reports and take actions on a schedule that you specify.

Which one is “better” would be quite subjective.

[OptimiX_XcrY]

I vote for reports