Skip to main content

Automate Filling of Empty End Dates

  • September 10, 2024
  • 1 reply
  • 18 views
B
Forum|alt.badge.img+1

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.

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6457 replies
  • September 10, 2024

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

 
Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement