I am trying to create a simple trigger that when I change a cell “Teacher Name” , it clears the form so I can enter new Information for another teacher. Then when I have completed the form, I want to enter a new teacher’s name, which triggers cells to clear, and so on.
I try this, but it keeps showing an error ('source" not defined)
Any Thoughts?
Shouldn’t you do it with a form inside Glide instead of relying on a Sheets trigger? You can submit teachers’ info as separate form submissions.
The issue is that I need to clear the form on my iPad. I have the code to clear it on my PC. The Ipad does not recognize the script and will not clear the form.
I agree with @ThinhDinh, you shouldn’t be using scripts for this. Glide gives you all the tools you need to manage data collection via forms.
Perhaps if you can share some more details about how you currently have this setup in Glide (ignoring the Google Sheets), we might be able to guide you to a better way to get what you need.