Thanks to everyone above for their input. However, I think I have found a good solution - at least better for me, since it requires no script editing!
-
Insert a graphic for a button into the Google Sheet, e.g. [RESET]
-
In the menu, select Tools, Macros, Record Macro…
-
Perform the required set of actions, e.g. clearing cells by selecting and deleting values and save the macro
-
Select the button icon, click on the 3 dots to open the graphic menu & select ‘Assign Script’
Now every time the button is selected the macro runs and it performs the reset. It even works on multiple sheet tabs at the same time.
I recommend beginners practice on a duplicate Sheet before working on the actual sheet. I love this since it requires no scripting. I understand the script might also be triggered via an event in a Glide App, but for now this is my simple workaround solution.
My next step is to check that when my Glide App is copied the sheet can be copied with the reset button and script included. I’m assuming yes… let’s see.