Collect many records in on field

  • Profile Image
    Asked on June 13, 2017 at 10:13 AM

    I explain it with an example. 

    I want to do a form to collect pupils that have done a specific course. Then i will do a document for each of them. 

    I would like the organizer to be able to enter the information of the course (place, name, duration,...) but also all the pupils that assisted. I would like to have one field where he could copy from another place all the names and simply paste, and not pasting one by one 20 or 40 pupils.


    I want to then pass this pupils to a spreadsheet with zapier. But i would need each pupil in one record so i can then work with it. 


    ¿Is this possilbe? My manin objective is that organizer does not have to copy and paste 20 - 40 times but only one for the course. 


    Thanks in advance

  • Profile Image
    Answered on June 13, 2017 at 10:37 AM

    As far as I understand the situation Google Spreadsheet integration could be of assistance to you.

    You'll have submissions saved on your Google Drive where the questions are main Columns and the submission data filled out accordingly.

    You can check the guideline to see if that'll work out for you!


  • Profile Image
    Answered on June 13, 2017 at 05:43 PM
    Yes but I will have one submission but many records in one field. I want to enter many records in one only submission. Please see my example.
    Elena Aguiar
  • Profile Image
    Answered on June 13, 2017 at 06:41 PM

    I would suggest you to try with the Configurable List widget, that will allow you to capture multiple records in one single field. 

    Link to the widget: 


    Related guide that will help you setting up the widget: How-to-Set-Up-the-Configurable-List-Widget

    You will also find other widgets that allow multiple entries here: 

    Hope this helps. 

  • Profile Image
    Answered on June 14, 2017 at 05:59 AM

    Sorry for sure my english is not that good. I will try to explain it better.

    On that way i will have all 20 pupils in the same submission, and therefore when taking information to a spreadsheet i will have one only row with all pupils. I need each pupil in one row. I need 20 rows as 20 submissions where done. 

  • Profile Image
    Answered on June 14, 2017 at 08:23 AM

    Hello eaguiar,

    If I understand your question correctly, you are collecting data of 20 pupils in the same form submission and you want to display all these 20 pupil's data in separate row of spreadsheet. Is that correct?

    Unfortunately it is currently not possible to achieve your requirement. Please note that each submission data is stored in one row irrespective of the number of columns. It is not possible to send one submission data and save it in multiple rows.

    I would suggest you to please download your submission data in excel and manually separate it in multiple rows.

    Thank you!

  • Profile Image
    Answered on June 14, 2017 at 08:54 AM

    thanks, i can not do it manually, as the porpuse is to automate some documents after entering pupils list. if any one knows a possible workaround i will be very pleased. 

    Thanks anyway for your answers!

  • Profile Image
    Answered on June 14, 2017 at 11:10 AM

    Hello eaguiar,

    I understand but unfortunately there is no option to save one submission in multiple rows. Every time submit button of form is clicked, form data will be saved as one row. 

    If you want the data to be saved in multiple rows, the only option is to allow users to submit form multiple times. I would suggest you to collect 1 pupil data in form and redirect users to same form after the form is submitted. You need to grab your form's direct URL and set it as custom thank you URL of the same form. The following guide should help you how to redirect users:

    Thank you!

  • Profile Image
    Answered on June 15, 2017 at 07:52 AM

    Thanks for your help!