Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to - Conditions [automations]

Topic Labels: Automations
398 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey guys,

As per this question and problem Extracting records from one table to another based on dates - #2 by Kamille_Parks

How can I, and is it even possible to choose Condition where {date field} is is/on or after/exact date/etc. as {another date field from table}?

image

Because the only option I have is to choose specific date.
image

Long story short, I need to trigger certain automation with record that has its unique date field (lets call it {date1}), but that automation needs to be triggered only when that record’s date ({date1}) is in a certain specific range I choose (lets call it {date2} & {date3} because I actually have FROM and TO fields to make that specific range).

Thanks

4 Replies 4

Hi @Michael1 ,

See the “is” part? This is where you will find the “is on or before” condition

Screen Shot 2022-03-14 at 3.38.04 PM

However, @Michael1 is looking for dynamic input for the date ranges. That can’t be done with automations, so Michael, you’ll need to create formulas in your table to use as your conditions.

Ah, I missed that part.

Then yes you need to have it as an IF Statement

I’m just not sure how to do that :confused: