Skip to main content

How to - Conditions [automations]


Forum|alt.badge.img+2

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

Thanks

4 replies

Forum|alt.badge.img+17

Hi @Michael1 ,

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


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8776 replies
  • March 14, 2022

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.


Forum|alt.badge.img+17
ScottWorld wrote:

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


Forum|alt.badge.img+2
  • Author
  • Known Participant
  • 12 replies
  • March 14, 2022
ScottWorld wrote:

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.


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


Reply