How do I get the submissions to populate the correct Google Sheet category?

  • Anne Hess
    Asked on October 19, 2021 at 9:33 AM

    I am doing a survey for the "Best of" in a town. How do I get the submissions to populate the correct Google Sheet category?

  • Cecile JotForm Support
    Replied on October 19, 2021 at 10:04 AM

    Hello there,

    Thank you for contacting support.

    To assist you correctly, can you please give us more details about your requirements? Do you want to group your submissions based on a category in your spreadsheet?

    We look forward to your reply.

  • anne.hess
    Replied on October 19, 2021 at 5:26 PM

    Yes, there will be categories like favorite restaurant, veterinarian, coffee shop, wine bar....everything needs to map to a Google sheet with contact information and recommendations and then I'd like to build a list of contact names/emails.

    Thank you,

    Anne

  • Cecile JotForm Support
    Replied on October 19, 2021 at 7:07 PM

    Hi Anne,

    Kindly note that the spreadsheet is automatically generated when you integrate Jotform with Google Sheets.

    Guide: How-to-integrate-forms-with-google-sheets

    If you want filter your submissions and categorize them, I suggest you to do it in a duplicate sheet.

    Let us know if you have any other concerns. 

    Thank you.