- SanketAsked on May 31, 2016 at 02:17 PM
Is there any way in which we can have multiple filed updated in google form instead of writing / pasting fields individually ..
The idea ..
I have few friends who give me feedback on monthly basis – this feedback will be in 20 rows & 20 columns , I want to consolidate it in single spreadsheet , in google spreadsheet we can give access to copy-paste their reports but in that case some time people overwrite earlier data , some time they can change (own) earlier data .
I am looking for tool in which they can upload ( copy-paste ) details in one sheet with their credentials which will get auto updated in backend sheet , by doing this I can protect my backend spreadsheet by not giving edit options to others.
This is a re-post of a comment on How to Integrate a Form with Google Drive
- HubersonAnswered on May 31, 2016 at 03:26 PM
If you have a form that you would like the data submitted through it automatically added to a spreadsheet, you simply need to Integrate Google Spreadsheet.
You will not have to edit the sheet manually because the data will be passed to it automatically.