Hi,
I would like to send automatic emails once If/else coloumn in database changes to certain values.
Example:
If / else coloumn = Reward fully paid > nothing happen
If / else coloumn = Not paid in time > send a notification email
Any ideas how can I do this?
Is there an action in the app that would lead to the values being changed?
Do you store your data in Glide Tables, Google Sheets or somewhere else?
No, it should be triggered based on date. I am currently working on a workaround with make since the database is in google sheets.
Yes, that should be the way for now. You can trigger it every day at a certain time to see if the value matches, and then send emails where needed.
We might get time-based trigger in Glide some time later this year.