Forumla to send email when date + 5 days

[adiboo_adib]

Hi

can some one help to add formula when i enter a DATE , i want to receive email when this date + 5 days came.

thanks

[macastan]

Hi @adiboo_adib,

You can create a new Workflow (under Behavior tab). Under “Update event” you will have to choose ADDS_ONLY (if you only want this to happen when a new entry is added), select the Target table where the data is in and under Condition you would have the following:

[Column with date] + 5 = TODAY()

I hope this helps! You can find more about date and time expressions here and workflows here.

Maria

[adiboo_adib]

Hi thanks for your relpay
but i don’t receive email after 5 day
hope someone to help for formula please.
thanks

[Aleksi]

Instead of using Workflow, you need to use Scheduled report. Then the condition rule would be…
TODAY()-5=[DateColumn]

[adiboo_adib]

i tried but i don’t receive the notification, i use only TODAY()=[mydatecolumn]
thanks for help

[Aleksi]

Is the app deployed? Do you have Pro plan?

[adiboo_adib]

Yes and work good, only personal app

[Aleksi]

Please check from the Audit history what the details show. Editor > Manage > Monitor > Launch log analyzer and then search the correct Report and click “Details”

[adiboo_adib · Accepted solution]

I found the problem, the schedule was on monthly , i modify it to Daily now it work thanks