Google-sheets – How to edit a particular sheet using Google Forms

google sheetsgoogle-forms

I created a form that has list of items to be selected. I also created a spreadsheet that has a couple of sheets that correspond to the elements in the form.
I wanted users to select a category and fill data on the form for that category so that the data will be saved in the particular sheet associated to the category. Is it possible to edit a particular sheet on Google's Spreadsheet based on a selection Google Form?

Best Answer

Google Forms doesn't edit data in Google Sheets, instead they send responses. Responses sent to a Google spreadsheet could be updated but should be enabled the option "Allow users to edit responses".

By the other hand, Google Forms and Google Sheets don't have a built-in feature to send responses to specific sheets based one answer.

One alternative is to use and combine built-in Google Sheets features and functions like:

  • arrays
  • Functions like QUERY, FIlTER, etc.
  • Pivot Table reports

Another alternative is to use Google Apps Script.

In the right panel of this page there is a section of related questions that could help you to refine your question or to post another one more specific.


References

Related Topic