How can I edit how order data goes into Google Sheets?

  • Profile Image
    Asked on June 24, 2020 at 06:50 PM


    I have a spirit wear order form created in Jotform. I would like the orders to go into google sheets such as it shows how many small design 1 tee shirts were ordered, how many large design 2 shirts were ordered, etc. Is there a way to do this? Thank you.

  • Profile Image
    Answered on June 24, 2020 at 09:12 PM

    Kindly note that the way orders are received and stored as submissions makes what you're after not possible. All respondent's orders are received as a one field submission, as it's only one order/payment field on form.

    That said, unfortunately, there's no way to aggregate how many times product X is ordered.

    However, we can escalate this as a feature request to our developers, but first, we need you to provide us with more information about what you have in mind so we can deliver it along.

    We're patiently waiting for your response.