I want users to be able to add another submission per section, skip with no enty or go to next section

  • devonlouquet
    Asked on October 30, 2019 at 12:46 PM

    For this form, I want my team to be able to add another submission from the pipeline section if they have more than one entry and or skip this section (not mandatory) if they do not have anything to enter. Is there a way to add in the following options?


    Add Another Entry (Same exact fields in this section)

    Skip (to next section if they have nothing to add)

    Next (to go onto RFP's and then New Relationships)


    If this is possible I would want it added to the top 3 elements - Pipeline, RFP's New Relationships

    Finally, can this all be merged and compiled into one google sheet ongoing as submissions are added?

    Jotform Thread 2021006 Screenshot
  • Ashwin JotForm Support
    Replied on October 30, 2019 at 3:33 PM

    Based on the screenshot you have shared, you seems to have added cards form layout. Please note that it is not possible to duplicate the same fields in one single card. 

    I would suggest you to please take a look at our "Configurable List" widget and see if it fits into your requirements. This will allow you to duplicate question dynamically in form. 

    Hope this helps.

    Do try it out and get back to us if you have any questions. 

  • devonlouquet
    Replied on October 30, 2019 at 7:03 PM

    Very helpful, thank you!!

    Now, I need assistance with how the data fills into Google Sheets. Can you help me with that? The formatting is the issue. I need each form to go into a separate cell versus merged together as it is currently. See sheet example (link below) and cell D2 as an example. Can the data be separated into individual cells versus all in one?


    Or at the very least one entry per row?


    I need to be able to take all this compiled data each month and be able to forward it on to the executive team in one clean, easy to read format if that makes sense. 


    https://docs.google.com/spreadsheets/d/1lX5erjY0Xgxj_AeB_xoO55TYGeSUBAGXSnKaWpIw3IA/edit?usp=sharing


    Example of what we are doing manually now:

    Big Wins | New Mandates

    Account

    # of Units

    Placements

    Timing

    Notes

    Oceanaire

    12

    Chalone Estate Chardonnay BTB - Existing

    November 7th, 2019 – November 6th, 2020

     

    Chalk Hill Estate Chardonnay - BTB - Existing

    Texas De Brazil

    57

    Nieto Malbec BTG - New

    October 1st, 2019 to October 31st, 2020

    285 new POD's

    Armador Cabernet - BTG - New

    Nieto Blend Collection - BTG - New

    Sebastiani Merlot - BTB - Existing

    Chalk Hill SC Chardonnay - BTB - Existing

    Sebastiani Cab - BTB- Existing

    Chalk Hill Estate Red - BTB- Existing

    Roth Estate Heritage Red - BTB - New

    Four Graces Pinot Noir - BTB - New

    Roth Estate Cabernet - BTB - New

    Kessler Hotel Group

    14

    Acrobat PG-PN-Rose /& Cans Select Serve

    January-October 2020

    Engage and implement locally starting now.  Must be in place by Jan 1, 2020. Each property to mandate 1 BTG and 2 BTB/location in OND. 50+ possible new Pod's  Catering and Outlets are ++

  • Elton Support Team Lead
    Replied on October 30, 2019 at 11:01 PM

    That's, unfortunately, the downside when using a configurable list widget. You can't separate its data into different columns when sent to Google Spreadsheet. They are treated as a single field so they are added into a single column.

    What you can do for now is to create a formula into a new tab sheet that separates these values into different columns.

    I want users to be able to add another submission per section, skip with no enty or go to next section Image 1 Screenshot 30

    Then use SPLIT formula. Here's a reference https://support.google.com/docs/answer/6325535?hl=en

    Result:

    I want users to be able to add another submission per section, skip with no enty or go to next section Image 2 Screenshot 41

  • devonlouquet
    Replied on October 31, 2019 at 3:58 PM

    Thank you! Two more questions.

     

    1) Can I increase the size of the notes/comments box in the configurable list or put it on a new line to increase the size, so the user can see everything they are typing? See the RFP section for an example.

    2) After someone has entered the data in the form can this also be emailed to them as well as me?

     

    https://www.jotform.com/build/92881607331964

  • Elton Support Team Lead
    Replied on October 31, 2019 at 6:31 PM

    We will answer your other questions in the following threads.

    https://www.jotform.com/answers/2023281

    https://www.jotform.com/answers/2023284