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…
- if(useremail appears in [confirmed by],true = do nothing, blank = step 2
- remove info in 3 columns (timestamp, booked by, booking type)
- move [waiting list] into booked by, add timestamp and booking type
- 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?