+7Hi 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!
+31You 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"
+7Hey 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!
+31Hey 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
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.