Google Spreadsheet- data missing from Visual Multi Select widget

  • nivha
    Asked on October 29, 2014 at 5:45 PM

    Some content from form is not displaying in the Google Spreadsheet. 

    Here is the link to the form and here is the spreadsheet link: 

    http://form.jotformeu.com/form/40976805371360

    https://docs.google.com/spreadsheets/d/183ddrOFl0omoKQ4soEgTtN6_kSrD-JVmtoBk4nQZIGg/edit?usp=sharing

     

    A, B & C selections are not populating in the Google spreadsheet

  • jonathan
    Replied on October 29, 2014 at 7:11 PM

    Hi, 

    I was able to reproduce the problem when I test submitted your jotform http://www.jotformeu.com/form/40976805371360

    Although I have filled in the selections in Visual Multi-Select Widget the data were not included in the Google spreadsheet submissions

    Google Spreadsheet  data missing from Visual Multi Select widget Image 1 Screenshot 30

     

     

    Google Spreadsheet  data missing from Visual Multi Select widget Image 2 Screenshot 41

     

    I will submit a bug ticket report to our higher support team so they can take a look on this.

    We will notify you for any updates when available.

    For the meantime, the only workaround I can suggest is to not use the Visual Multi Select if you need the data to be in Google spreadsheet submission.. you may want to use the Dropdown List field in Form Tools instead for selections.

    Inform us you need further assistance.

    Thanks.

     

     

  • nivha
    Replied on October 30, 2014 at 5:05 AM

    Thanks Jonathan, 
    OK I can try the Dropdown list for now. 

    Hopefully here back from you soon. 

    Regards, 
    Andy 

  • jonathan
    Replied on October 30, 2014 at 7:13 AM

    Hi Andy,

    We will make sure to notify you here when status update is available.

    The bug ticket I have submitted is now assigned to one of our developer. So, this is being look upon now.

    Thanks.

  • nivha
    Replied on October 30, 2014 at 8:33 AM

    Thanks Jonathan

  • nivha
    Replied on November 4, 2014 at 4:00 AM

    Jonathan, 

    I still have heard nothing back. 

    Regards, 

    Andy 

  • jonathan
    Replied on November 4, 2014 at 6:25 AM

    Hi Andy,

    Sorry for the delays. Unfortunately, we do not have updated response yet from our developer assigned.

    I will make a follow up also on your behalf.

    Thanks.

     

  • nivha
    Replied on November 11, 2014 at 5:58 AM

    Thanks Jonathan. 
    It is getting critical at this stage and we may need to research another solution. 

    Can someone get back to me ASAP. 
    I appreciate your hep. 

    Thanks

    Andy 

     

  • Elton Support Team Lead
    Replied on November 11, 2014 at 9:04 AM

    Hi Andy,

    Would you mind re-integrating your form with Google Spreadsheet? I think this would help.

    I have tried it with a new form using the same widget (Visual Multi-Select) and the same values from your form but they are submitted properly on the spreadsheet.

    Test Form: http://form.jotformpro.com/form/43143361753956?

    You can view the result here: https://docs.google.com/spreadsheets/d/1FYW4OTLdDmRyrL9A0N7pTKm2mJVpXKJQVQXLDqUx7yc/edit#gid=865288553

    Google Spreadsheet  data missing from Visual Multi Select widget Image 1 Screenshot 20

    Perhaps refreshing your current integration with Google might resolve the problem. Try to remove the integration and then integrate your form again with Google Spreadsheet. See if this helps.

    We'll wait your updates.

    Regards!

  • nivha
    Replied on November 11, 2014 at 10:00 AM

    Thanks, 
    I reintegrated the form but the last 2 fee notes created from today still don't have the fields we need showing: https://docs.google.com/spreadsheets/d/1bZYatfkcPiO1_uXRSdbT0qRtbUy5n2Ky-kvNlWrKFnc/edit?usp=sharing

     

  • Elton Support Team Lead
    Replied on November 11, 2014 at 10:40 AM

    @nivha

    Thanks for your reply.

    I think it was due to the parenthesis on the widget field labels that is interfering with the process. Removing it seems fixed the problem. https://docs.google.com/spreadsheets/d/1lltrsjs8RDgrBb0OWgR-Y7YedhJn5FRXQz6RXkAfgOI/edit#gid=1888913311

    Try to remove the first open and close parentheses on the affected widget labels (see screenshot below) and then re-integrate your form. That might fixed the problem.

    Google Spreadsheet  data missing from Visual Multi Select widget Image 1 Screenshot 20

    If that still doesn't make any difference then I'm afraid we have to wait our developers official update about this issue. This is the best thing I can do to help you for now.

    Thanks for your cooperation, we greatly appreciate it.

    Please update us with the result.

    Regards!

  • nivha
    Replied on November 11, 2014 at 11:32 AM

    Many Thanks, 
    I'll run a few tests. Hopefully that will do the trick. 

    Andy 

  • Elton Support Team Lead
    Replied on November 11, 2014 at 11:35 AM

    Sure. Let us know how it goes. Hopefully it will also work for you. :)

  • alp_deniz
    Replied on May 6, 2015 at 11:26 PM

    Hello,

    All related issues should have been solved by now. Apologies for late update.

    Thank you!