We have a Google Form students are using to sign up for summer and fall classes. I created a Process to send students confirmation texts and emails after they complete the form. The process runs once an hour, and has many branching paths, so students get different messages based on their choices. However, no matter the path, the last step marks a [Confirmation Sent] column as TRUE. And the first step checks to see if this column is marked TRUE, so students only get the confirmation once.
One of our teachers has reported that she filled out the form as a test and has gotten the confirmation email dozens of times! I checked the Sheet, and her [Confirmation Sent] column is not marked as TRUE. I found a few other rows with the same issue.
The phone number she entered is 555-555-5555, since she was just testing. Some of the other rows that don’t have the column marked TRUE are from other teachers using dummy phone numbers. So my best guess is that for the affected rows, the phone number is invalid. And when the text step of the process fails, the entire process ends. Is there a way to bypass this so that we aren’t sending a ton of emails to anyone who doesn’t enter a valid phone number? Or maybe there could be another cause?