Appsheet or google sheet - timed action

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?

Which one is “better” would be quite subjective.

1 Like

I vote for reports