How to add multiple lines in Google spreadsheet for the same order?

  • Nutraceutical
    Asked on March 30, 2018 at 2:31 AM

    I run a staffing company and I have a jotform, which I am using for a customer to place orders for employees, which I have integrated a Google Doc to automatically populate and track the orders.

    The client will enter the order data, which is then automatically uploaded in google docs, but I'm trying to figure out how to add multiple lines in Google Docs for the same order if the client orders more than one person in the form.

    Example:

    Single order data = single data entry in google docs

    Multiple order data = data is automatically populated in google docs, but allows for each line to be automatically uploaded per individual order.


  • Kiran Support Team Lead
    Replied on March 30, 2018 at 5:57 AM

    I am not sure if I understand your query correctly. As I check your account, I see that the form http://www.jotform.us/form/80864956484170 is integrated with Google spreadsheet. As I check the form there are multiple line fields on it. Please be noted that each field is updated in a column of the spreadsheet. Could you try submitting the form once and see how the data is being updated in the spreadsheet? Let us know if you need any further assistance or referring to something different. We will be happy to assist.