Automated Google Calendar End Date ends a day earl...

[bschultzFH]

I am setting up a calendar for my team. I would like single day events (records with a start date and no end date) to automatically copy the start date into the end date field.

Fields:

StartDate - always filled unless TBD, which I have another marker for

EndDate - often left empty if a single day

I've tried to make automations and scripts, but I keep getting errors that I don't understand how to fix. I assumed this would be pretty basic, so I don't know what I'm missing. Basically what I want is:

IF EndDate is EMPTY, THEN let EndDate = StartDate

I don't have enough experience figure out the syntax in airtable; any help would be appreciated.

[TheTimeSavingCo]

Hmm try creating a formula field that'll check how long it's been since StartDate was modified.  Then have an automation that'll trigger if EndDate is empty, StartDate is not empty, and it's been 5 minutes:

DATETIME_DIFF(
  NOW(),
  LAST_MODIFIED_TIME(Start),
  'minutes'
)

Link to base