Help

Re: Attempting to Automate an Email Form After A Date Is Entered

804 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tahir_Jetter
6 - Interface Innovator
6 - Interface Innovator

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!

4 Replies 4

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"

Tahir_Jetter
6 - Interface Innovator
6 - Interface Innovator

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

Tahir_Jetter
6 - Interface Innovator
6 - Interface Innovator

Hi,

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