Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Change the date - For a resubmission

Topic Labels: Automations
Solved
Jump to Solution
930 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Boris_Ling
4 - Data Explorer
4 - Data Explorer

I would like to replace the date in the field “date” by date +5 days as soon as it is today.

what I have tried so far:
My first formula [Called: Formular1]:

IF(IS_SAME(date,NOW(),'MINUTE'), "Now")

The Second Formular [Called: RepeatCalculation]

DATEADD(date, 5, 'week')

Next, I attempted to set up an automation:
Trigger: “When a record matches conditions” when Formula1 is “Now”
Action: “Update record” Record ID “date”
When chosing Field i can not select my [RepeatCalculation]Formula.

  • The following error message appears
    chrome_WxpCXFF1cO

I think I have missed something. I am grateful for any help.
Sorry: English is not my mother tongue

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hi Boris, I’m not too sure why that’s happening. I’ve set up a base here with the automation you’re trying to do and it seems to work fine. Perhaps you can compare the two to see what the differences are

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hi Boris, I’m not too sure why that’s happening. I’ve set up a base here with the automation you’re trying to do and it seems to work fine. Perhaps you can compare the two to see what the differences are

Hi Adam, Thank you very much for taking the time to look into my question. The example you created helped me a lot. I have made a mistake with the RecordID. Thanks much for sharing your insight.