Skip to main content

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 uCalled: Formular1]:


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

The Second Formular lCalled: 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 iRepeatCalculation]Formula.



  • The following error message appears




I think I have missed something. I am grateful for any help.

Sorry: English is not my mother tongue

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

Reply


Terms & Conditions