How to - Conditions [automations]

Topic Labels: Automations
1056 4
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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}?


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

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).


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: