I have a template spreadsheet inside a workbo...

(Sean Smith) #1

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?

#2

HI Sounds like a job for GAS.

(Bellave Jayaram) #3

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

(Sean Smith) #4

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) #5

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