Hi Everyone
I am after a function to include in my RESET google sheets script that deletes any rows that the user may have added after row 19. If the user needs to add a new item to the form, they can do that automatically by clicking on a button which I have assigned a script to, to make it insert a new row/item but I want it to reset to the forms original state. There are 27 possible item choices the user can choose so I can't assign a value of how many rows to delete as it will vary each time the form is used.
Can anyone help with this please?
Thank you.
I am after a function to include in my RESET google sheets script that deletes any rows that the user may have added after row 19. If the user needs to add a new item to the form, they can do that automatically by clicking on a button which I have assigned a script to, to make it insert a new row/item but I want it to reset to the forms original state. There are 27 possible item choices the user can choose so I can't assign a value of how many rows to delete as it will vary each time the form is used.
Can anyone help with this please?
Thank you.