I have a template spreadsheet inside a workbo...

[Sean_Smith]

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?

[Lynn]

HI Sounds like a job for GAS.

[Bellave_Jayaram]

Why is it necessary to add a new tab every time?

[Sean_Smith]

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.

[Bellave_Jayaram]

You should look into the workflow features if you haven’t already.