I have a template spreadsheet inside a workbook (google sheets) and would like to be able to have it filled out as a new spreadsheet inside the same work book. So that every time it is filled out a new form is saved as a new tab in the work book. Is this possible in app sheet?
HI Sounds like a job for GAS.
Why is it necessary to add a new tab every time?
Lynn- unfamiliar with GAS I will check out-thanks
Bellave- We send the completed form (spread sheet) to our customers as a job write up that spans multiple days, so it would be nice to keep our format but have the info enter through app sheet for a easier user interface.
You should look into the workflow features if you haven’t already.