Kia ora, I've got an automation set-up on a sheet when certain criterion is checked on the row it will send an email to a particular person (with the data on that row). I've tested it numerous times to get it right and it's worked fine, however using the sheet today, it worked once, but that's it. I tried changing the conditions which then generated a test email (i've opted for the message only with certain fields included) with everything that had been checked, then changed it back to only run the one, and it's seemingly OK again.
I'd like to know, is this a glitch, or do I need to change my conditions/triggers in the automation? And if the latter, what would they be?
The automation is:
Trigger: when rows are changed
- when generate email changes to checked
Conditions:
- when New feedback received is not checked
- and where referred to is not blank
- and where date referred on or replied to is today
- and where feedback area is not one of website issue or podcasts
- and where generate email is checked
Alert Someone - send to specific people (feedback email)
