Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 08, 2022 05:13 PM
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.
I think I have missed something. I am grateful for any help.
Sorry: English is not my mother tongue
Solved! Go to Solution.
Oct 08, 2022 07:13 PM
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
Oct 08, 2022 07:13 PM
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
Oct 09, 2022 12:55 PM
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.