Skip to main content

Hi All,

I’m trying to automate a trigger that emails a form the day after the date that has been entered in a specific record/field (which I guess you could think of as a “cell” in Excel).

So for example, say 1/26 is entered as a date in a specific field. The day after, I'd like to have an automated form sent out via email. How do I do that? Is there a way I can identify a specific "cell?" Can I automate a formula using if {today ()+1} or something like that?

Can anyone give me a tip? Thanks!

You could do this by creating a formula field that would check if today's date was a day after the date in the cell, something like this:

IS_SAME(

DATEADD({Date}, 1, 'day'),

TODAY()

)

 And create an automation that triggers when this formula field's value is "1"

Hey there, 

Thanks for your suggestion. So I tried the recommended formula, and for some reason, it gave the exact same answer no matter at what time/date I input. Can you provide any thoughts on what might be going wrong?

Thanks a lot!

Hey there, 

Thanks for your suggestion. So I tried the recommended formula, and for some reason, it gave the exact same answer no matter at what time/date I input. Can you provide any thoughts on what might be going wrong?

Thanks a lot!


Hm, your formula references a {Next Date} field, but the date field in the screenshot has its name set as "Date"?

I can take a look at this for you if you DM me a link to your base

Hi,

Thank you! I'm going to DM you, now. 

Reply


Terms & Conditions