Can I link a form text to a cell in a Google sheet spreadsheet to show a result based on what is completed in the form?

  • Profile Image
    TalkNet
    Asked on June 10, 2017 at 06:05 AM
    Similarly: can I link a form text to a cell in a Google sheet spreadsheet to show a result based on what is completed in the form?
  • Profile Image
    aubreybourke
    Answered on June 10, 2017 at 06:18 AM

    Yes, it is possible to integrate your form with Google spreadsheet. So that when you submit your form the information will be added to a spreadsheet. And it is easy to accomplish too. Simply follow this guide:

    How to Integrate Form with Google Spreadsheet

     

    However, all fields on your form will be inserted into your spreadsheet

    So if you want to capture only one field, this is not possible. Instead, you should hide the columns you dont want to see within your Google spreadsheet.