Add another record but keep other field values

  • Profile Image
    cclaacctg
    Asked on June 11, 2020 at 03:43 AM

    I created a donation form with a page for donor info and a page for donation info. I want to capture multiple donations in different rows. For instance, Donor X donated Clothing, Furniture, and Food. There should be three rows containing the same donor info (without retyping) with multiple donation info.

    1591861237Donation.PNG


    Is there a way to have an "Add another donation" button before clicking Submit? 

  • Profile Image
    Vick_W
    Answered on June 11, 2020 at 06:21 AM

    Hey there,

    Happy to help you today.

    If I understood you correctly, you want to let your donors more then one donation at a time. You can do this by adding/duplicating categories and item conditions field. Please check the screenshot below.

    1591870842screenshot.png

    Let us know if you need further assistance.

    Looking forward to your reply.

    Thanks.

  • Profile Image
    cclaacctg
    Answered on June 11, 2020 at 11:40 AM

    I believe this will create more columns, not rows. I don't think this will work with my requirement. Is it possible to have an ADD button that will be available to users of the form, so that same donor can add multiple donations without having to retype all other details again?

  • Profile Image
    Richie_P
    Answered on June 11, 2020 at 12:25 PM

    You may use the configurable list widget to add a dynamic field in your form however, the widget cannot take calculation values or to be used for calculation.

    You can use this field to get the basic info of your user.

    https://www.jotform.com/help/282-How-to-Set-Up-the-Configurable-List-Widget

    Please check it out and let us know if this fits your requirements.

  • Profile Image
    cclaacctg
    Answered on June 15, 2020 at 01:35 PM

    I tried the widget, it could almost work but the issue is it keeps all data in one single field, which is not going to work for me. 

  • Profile Image
    Kevin_G
    Answered on June 15, 2020 at 04:22 PM

    Unfortunately, the data will always be generated in a single row even using a widget that supports multiple entries, I'm afraid it's not possible to change this. 

    However, using a Configurable List widget, for example, will generate the data in a single cell when you download the report as Excel, you can then split this data and add more columns, I'm not sure if Excel supports to split this to different rows; however, these features are not from Jotform and you will need to check on Excel if this is available.