Skip to main content

Hi! I’m trying to create an automation that is basically:

If publish date is yesterday and status is not ‘published’ then the publish date updates to today. 

 

I saw some people mentioning creating a TODAY() formula field and using that as a dynamic trigger. Questions with this:

  1. How will this field affect already existing records? 
  2. What needs to be added between the parentheses of the TODAY() formula?

Hey ​@rsrodrig96,

 

You will want to have a formula field (you can call it “Needs Update” for now) on your table to be:

AND(Today()>Published Day, Status!=“Published”)

 

This will return 1 if the conditions described by you are met, and 0 if they are not. Set your automation to trigger on a scheduled basis (this will be more efficient). Have a Find Record action which will find all records where field Needs Update = 1. For last have a repenting group and within it an update record action. 
 

All historic records which match the condition will get updated as well. 
 

Feel free to schedule a call if you think that could be useful!
 

Mike, Consultant @ Automatic Nation

Terms & ConditionsAccessibility statement