Dynamic Widget to Separate Multiple Values with Commas

  • Profile Image
    kelsie
    Asked on January 17, 2018 at 04:56 PM

    Hello!

    We're setting up a form with multiple inputs (multiple selection widget & dynamic text box). When the form submission is received, these inputs are stored on new lines in an excel spreadsheet. Is there a way to make them separate with a comma instead of a line break? Or is there a way to do this with the form calculation?

     

  • Profile Image
    Marvih
    Answered on January 17, 2018 at 05:47 PM

    Yes you can do this using Form Calculation widget.

    You just add the field on your Form Calculation widget, be sure to change it to String if your inputs are Texts.

    1516229241546.png

    1516229252544.png

    See sample form here https://form.jotform.com/80167022444954

  • Profile Image
    kelsie
    Answered on January 17, 2018 at 06:22 PM

    Hi, I tried this based on another forum thread I read, but it's not imputting commas. 

  • Profile Image
    Marvih
    Answered on January 17, 2018 at 06:34 PM

    Try adding comma on your form calculation.

    1516232020548.png

    1516232032549.png

    It worked for me.

    1516232072550.png

  • Profile Image
    kelsie
    Answered on January 18, 2018 at 10:36 AM

    It's still not working. It might be because we're using the multiple selection widget & dynamic text box. 1516289784Capture.PNG

  • Profile Image
    BJoanna
    Answered on January 18, 2018 at 11:51 AM

    You are correct. It is not working because you are using dynamic widgets. Unfortunately, there is not any way to separate the values that are entered inside of the dynamic widgets. If you want to separate them with a comma inside of an Excel file, you will have to do it manually. 

    The example my colleague provided you will work only with the basic fields. 

  • Profile Image
    kelsie
    Answered on January 18, 2018 at 12:13 PM

    Thanks, this is very frustrating. Would be nice to be able to choose how to separate your values within these widgets.

  • Profile Image
    Marvih
    Answered on January 18, 2018 at 12:30 PM

    I understand how you feel, I will add this as a feature request and hopefully will get implemented soon.

    Although we do not have definite timeframe or assurance it will be approved, we will give you an update once it will be on this thread.

    Thank you for your understanding.