I am making a calendar form to set a visit schedule. but if a reschedule is needed, I do not know whether to use LINKTOFORM(), Edit this row, or Copy this row and edit the copy. New and updated schedules are on one table.
I plan to set the old schedule's [Status] column to "CANCELLED" if there are changes in [Code], [Date], and/or [Time] and the copy to "RESCHEDULED". I also made an automation where the condition is when there are changes because reschedules need approval. What should I do to make this work?
I have 6 values under [Status]: UPCOMING (for new schedule before the date), HAPPENING (date and time = today), DONE (when today() +1 and time is midnight/reset), CANCELLED (if new date and time set), RESCHEDULED (for approval), and REJECTED (if button/action rejected is selected)
LinkedIn
Twitter
