Multiple choice results presented one line

  • Kay_contact
    Asked on January 4, 2022 at 5:41 PM

    Thanks for your help!

    Is there a way to have the multiple choice results transmitted to a googel sheet in line separated by a comma, or just a space instead of having each result in a new line in the same cell?

    What I get now

    1641336016 61d4ccd0ebf36 Screenshot 2022 Screenshot 10


    What I am looking for

    1641336040 61d4cce8f1213 Screenshot 2022 Screenshot 21


    Kind regards,
    Kay

  • Girish JotForm Support
    Replied on January 5, 2022 at 12:27 AM

    Hello Kay,

    That is directly not possible.

    But you can pass on the options in the multiple-choice field into a Long text field using conditions: https://www.jotform.com/help/286-how-to-pass-field-value-to-another-field/.

    So when data is passed onto the Google sheet, the data from the Long text field will show data in one line.

    Do give it a try and let us know if that will help.

  • Kay_contact
    Replied on January 5, 2022 at 9:22 AM
    That works - Thank you!
    Kind regards,
    Kay
    *CALL US, OR LET US CALL YOU!*
    *Outside MEX:* +5219841432347
    *Call Inside MEX:* 9841432347
    *Whatsapp:* +5219841432347
    *Email:* contact@kay.tours
    *Web:* www.kay.tours
    *Let's connect! *
    *Linkedin Newsletter
    *
    ...
  • Kay_contact
    Replied on January 17, 2022 at 3:39 PM

    The multiple choice field does not accept any entries. Either on desktop nor on mobile form. What could be the reason?

    I am referring to our form "NUEVA RESERVA 2022" at tour details.

    Thank you fro your help.

    Kay



  • Laura JotForm Support
    Replied on January 17, 2022 at 7:46 PM

    Hi Kay,

    I tested the form and I am able to make selections on the multiple-choice fields:
    1642466760 61e60dc884a18 multiplecfields Screenshot 10

    I have cleared your form cache. Could you kindly confirm if the issue is still persisting?

  • Kay_contact
    Replied on January 18, 2022 at 8:10 AM

    Thank you - It has been fixed.


    Kind regards,
    Kay Honig