Hi ,Is there any way in which we can have multiple filed updated in goo

  • Profile Image
    Sanket
    Asked on May 31, 2016 at 02:17 PM

    Hi ,

    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.

    Pls help.



    This is a re-post of a comment on How to Integrate a Form with Google Drive

  • Profile Image
    Huberson
    Answered on May 31, 2016 at 03:26 PM

    Hello,

    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.