I have a quizzing app. I use one sheet where the question number and the answers are stored. I need to be able to blank (delete values in Google Sheet speak) rows 2-200 to get ready for the next quiz. I’ve created a macro that can do this but how can I trigger that from the app or is there a way to do this with a button directly from the app?
You should use user-specific columns to store your users’ answers instead. This won’t require you to clear things from the Sheet.
1 Like