Multiple choice results presented one line

  • Profile Image
    Kay_contact
    Asked on January 04, 2022 at 05: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


    What I am looking for

    1641336040_61d4cce8f1213_Screenshot 2022


    Kind regards,
    Kay

  • Profile Image
    Girish
    Answered on January 05, 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.

  • Profile Image
    Kay_contact
    Answered on January 05, 2022 at 09: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
    *
    ...
  • Profile Image
    Kay_contact
    Answered on January 17, 2022 at 03: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



  • Profile Image
    Laura
    Answered on January 17, 2022 at 07:46 PM

    Hi Kay,

    I tested the form and I am able to make selections on the multiple-choice fields:
    1642466760_61e60dc884a18_multiplecfields

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

  • Profile Image
    Kay_contact
    Answered on January 18, 2022 at 08:10 AM

    Thank you - It has been fixed.


    Kind regards,
    Kay Honig