Hey guys! I have been searching the forums and could not find a solution to the problem below. Any help would be greatly appreciated.
App: Calendar View with “events” every half hour
Data: Jobs with [Schedule Date], [Schedule Start Time], and [Schedule End Time]
Issue/Request: When adding a new event, I’m trying to figure out how to auto fill the start time to the next available half hour time slot for the specified [Schedule Date] column. The [Schedule End Time] is simple enough with a formula to subtract 30 minutes. I have checked Calendar slot checking which checks for previous scheduled dates, not times.
So if I add a new event, I select the date required, it checks all events on the specified date, and chooses the next available time slot.