I need to add data from multiple rows to a single document.

  • Profile Image
    form_factory
    Asked on April 08, 2018 at 09:52 AM

    Hi,

    I need to add data from multiple rows to a single document. How can I achieve that?



    This is a re-post of a comment on How to Create a Customized PDF or Google Doc for Your Submissions

  • Profile Image
    Adrian
    Answered on April 08, 2018 at 10:27 AM

    Did you try setting the "Output as" option to Single document?

    15231974992.png

    If you want to combine multiple row data into one cell, I suggest you try the Merge Values Add-on.

    https://chrome.google.com/webstore/detail/merge-values/lhikboagplgbemjnkgoahbphfgieaiek?hl=en

    15231976011.png

    Let us know if you need further assistance with more details on what you are trying to achieve.

  • Profile Image
    form_factory
    Answered on April 08, 2018 at 11:21 AM

    Thanks a lot.

    Please check this form: https://form.jotform.me/80973744644467

    I want to create a list of email addresses of all the persons who select "A" (similarly for "B", "C" and "D"). Also, if a person selects both "A" and "B", their email addresses should appear on both A's list and B's list.

  • Profile Image
    Adrian
    Answered on April 08, 2018 at 01:09 PM

    I have cloned your form and added some extra fields so it is easier to extract the data.
    Cloned Form URL: https://form.jotform.com/80975018360963

    I have added 4 additional Short Text Entry fields (columns) that will hold the data for each list (A, B, C, D).

    152320704301.png

    Those fields can be hidden as the user does not need to see them.
    (How to Hide Form Fields)

    Then, you add conditions that if the user has checked a list item, the Email field should be copied to the corresponding field for that list.

    152320720002.png

    Do the same for each list item.

    152320722503.png

    This way, you will have all the emails in the lists that the user has chosen. You can download the submission data as an Excel file after.
    How to Export Form Data to Excel


  • Profile Image
    form_factory
    Answered on April 09, 2018 at 07:28 AM

    Loved your solution. 

    Now the problem is every time autoCrat runs a job, it creates a new PDF with only the newly added values. It is not creating a continuous list of email addresses.

    What I want is to append the newly submitted email addresses to the previously created PDF.

     

  • Profile Image
    Richie_P
    Answered on April 09, 2018 at 10:46 AM

    Have your tried my colleagues suggestion by using the merge value-add on?

    https://chrome.google.com/webstore/detail/merge-values/lhikboagplgbemjnkgoahbphfgieaiek?hl=en

    Please give it a try and let us know how it goes.

    Thank you.

  • Profile Image
    form_factory
    Answered on April 09, 2018 at 12:29 PM

    Hi,

    I've tried the "Merge-value" add-on. Sadly, it doesn't do what I am trying to do. The merging has to be done manually.

    Here is what I am trying to do - https://form.jotform.com/80975018360963 (Adrian version, loved it!)

    Users will have the option to select one or more programs from a list (multiple choice field). Then users will submit their email addresses.

    I want to be able to see email addresses of all the users who selected a specific program. I want this list to be in an auto-generated PDF. I want one PDF per program.

    Hope the image helps to understand -


    https://prnt.sc/j2xqxm

    1523291629index.jpg
    I appreciate your help.

    Thank you.

  • Profile Image
    Richie_P
    Answered on April 09, 2018 at 01:25 PM

    Thank you for the added information, May be you can combine the submissions using the importrange() function in the google sheet.  https://productforums.google.com/forum/#!topic/docs/aqJAApdcr88

    I can't seem to find a way in our side, to create a continues PDF with the sorting  given.

    Please let us know if we can be of further assistance.