Notification Send Automation

[Joao_Rocha]

Hello! Hope everyone's doing ok! I'm having an issue with an automation that I hope you might be able to help me with. 

My table that has a column named [Data]), with the data in this format dd/mm/yyyy 00:00:00  (Date Format , a column named "Notes" that can be "YES" OR "NO", a column named "Notes Message" and other column named "In how many days". i want my automation to do this. whenever there's an entry where "Notes" is "Yes", send a notification to the one that made the entry (column is [USER EMAIL]) with the content of the notification being "Notes Message" and i want it to be sent after the number of days of the number the field "In how many days:" was set to.

What I'm trying to do is: 

Condition is : AND(
[Notes] = 'Yes',
NOW() = ([Data] + ([In how many days:] ))
)

Anyone has any clues?? Thank you!

[Arni_Kli]

@Joao_Rocha , 
What exactly is not working? What error does the automation monitor report? At first glance, the condition is correct. Please check the automation monitor (Manage / Monitor / Automation monitor). May be [In how many days:] contains a colon in the formula editor?

[Joao_Rocha]

Hello @Arni_Kli , thanks for the reply! 

What's not working is I'm not receiving the notification! He accepts every condition I insert, but I fail to receive it. I can't really take anything from the monitor report, since every process associated with it says "Completed"..

[jballester]

Hi Joao, 

to analyze whether the processes have been developed successfully, I think you should check the audit history log. Manage / Monitor / Audit History / Launch log analyzer
(Fast filter table, user and date)

What I'm learning is that Monitor Automation tells us whether the process has been completed or not. However, Monitor / Audit history tells us whether each of the steps within the process (task) have been completed successfully. (if there is any error you should find it there).

Troubleshoot notifications Audit history Log
https://support.google.com/appsheet/answer/11512233 

 

[Steve]

You cannot schedule a notification for some time in the future by simply attaching a later time to the triggering event. Your approach won't work. To schedule notifications, you'll have to record the notification in a separate table and use a recurring scheduled event to scan that table and send notifications that are due.

[Joao_Rocha]

Hello @Steve thanks for your reply! So basically what you're saying is that I can't schedule it based on a row/column value or condition, and that I will have to schedule it for a set day (weekly, monthly, etc). Is that it?

[Steve]

Essentially, yes. You could have a bot scheduled hourly, or even several hourly bots that run at different points in the hour. Again, these scheduled bots could look at the pending alerts and only send out those that are due, which gives an approximation of scheduling.