Skip to main content

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.

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