Hi @dustinkay
You can get this done using Google Sheet by adding the following actions after form submission trigger:
Sheet: Create Spreadsheet (copy any other sheet if you’d like) > Create spreadsheet rows to populate the data into new sheet > Drive: rename file action to change the file name if you want.
I’m not sure whether you can do this via Excel’s integration as I don't see a way to copy a template sheet there. But you can play around and see if it works.
Hi @dustinkay
You can get this done using Google Sheet by adding the following actions after form submission trigger:
Sheet: Create Spreadsheet (copy any other sheet if you’d like) > Create spreadsheet rows to populate the data into new sheet > Drive: rename file action to change the file name if you want.
I’m not sure whether you can do this via Excel’s integration as I don't see a way to copy a template sheet there. But you can play around and see if it works.
Thanks for your response, what Im seeing this doing is every time I have a new response to the form it will create a sheet with only that value. I want to have a one sheet with all clients name for that day. Then the next day have a new sheet where the same form will populate the new sheet
Hi @dustinkay
Some thoughts…
GForms automatically can save data to a GSheet: https://support.google.com/docs/answer/2917686?hl=en
Is a timestamp of the GForm submission not sufficient?
What is the reason for having separate spreadsheet per day?
Hi @dustinkay
Some thoughts…
GForms automatically can save data to a GSheet: https://support.google.com/docs/answer/2917686?hl=en
Is a timestamp of the GForm submission not sufficient?
What is the reason for having separate spreadsheet per day?
I work in a medical facility it ihas to do with medical insurance regulations. If i was ever audited by an insurance company they would require i present daily sign in sheets to prove attendance, digital signatures do count. thus having an organized daily sheet would be wonderful for my compliance
@dustinkay
Wouldn’t 1 GSheet with timestamps serve the same purpose for compliance?