Spreadsheet to Form widget will not recognize the access code if it contains '&' character

  • Profile Image
    harishkota.general
    Asked on July 29, 2019 at 02:50 AM

    hi Support team


    We have dropdown box where the college names have been entered, few names are very long and spill over to the next line in the "Properties->General->Items" 

    We have another field using this selected value for searching through a spreadsheet to form widget

    The issue happens only for the names that spill over, it cannot find the college name in the widget and cannot fetch the details

    please help

    regards

    Harish

  • Profile Image
    harishkota.general
    Answered on July 29, 2019 at 04:26 AM

    The issue seems to be with the Spreadsheet to form field, it is not taking "&"

    regards

    Harish

  • Profile Image
    ashwin_d
    Answered on July 29, 2019 at 06:23 AM

    I am not sure if I have understood your question correctly. I did check your form but could not locate any dropdown filed for the college name. You do have spreadsheet to form widget in your form but what is the issue you are having in populating the field?

    I would suggest you to please share a screenshot of the issue and we will take a look. The following guide should help you how to upload image in forum post: https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum

    We will wait for your response.

  • Profile Image
    harishkota.general
    Answered on July 30, 2019 at 03:03 AM

    Hi 

    I will explain again with a another clone form @ https://form.jotform.me/91972897723475 . In the filed "Enter College Name" select "Avinashilingam Institute For Home Science & Hr. Edn For Women University,Coimbatore, Tamil Nadu"

    This college name spills over into the second line

    Now click "Auto Complete Fields" in "Fetch College Details", it will not get the details. I think this is bug.

    Replace the "&" in the college name to "and" and try it, it works


    let me know if this is clear

    regards

    Harish

  • Profile Image
    roneet
    Answered on July 30, 2019 at 03:46 AM

    I am unable to replicate the issue with your cloned Form.

    1564472652form.gif

    Could you please share the document that you are attaching with the Spreadsheet so that we can investigate further.

    Please email us the document with the subject as Thread#1906970 to our email id support@jotform.com.

    Looking forward to your response.

    Thanks.

  • Profile Image
    harishkota.general
    Answered on July 30, 2019 at 04:04 AM

    hi

    No that is not what i meant

     

    1) In the filed "Enter College Name" select "Avinashilingam Institute For Home Science & Hr. Edn For Women University,Coimbatore, Tamil Nadu". This college name spills over into the second line

    2) Now click "Auto Complete Fields" in "Fetch College Details", it will not get the details. I think this is bug.

     

    When I mentioned replacing "&" with "and", it is not in the text box. If we do any change in the text box of Spreadsheet to form, if it does not match with the spreadsheet, it won't work

    1) in field "Enter College Name" properties edit this particular college name and replace "& "with "and"

    2) in the spreadsheet to form replace the file with excel which has the edited college name - "&" replaced by "and", I dont see an option to attach so pasting it here

    ================College names to be put in the Spreadheet to form widget==============

     

    A. P. S. College of Arts and Science,Bengaluru,Karnataka

    A. R. M. First Grade College, Davangere, Karnataka

    Acharya Nagarjuna University, Guntur, Andhra Pradesh

    Ahmednagar College, Ahmednagar, Maharashtra

    Anand Arts College, Anand, Gujarat

    Andhra Christian College, Guntur, Andhra Pradesh

    Andhra Loyola College,Vijayawada, Andhra Pradesh

    Andhra University College of Arts and Commerce, Visakhapatnam, Andhra Pradesh

    Arts Commerce College, Ravalgaon, Maharashtra

    Ashritha Womens Degree College, Ibrahimpatnam,Telangana

    Atma Ram Sanatan Dharma College, New Delhi,Delhi

    Aurangabad Public Junior College, Aurangabad, Maharashtra

    Avinashilingam Institute For Home Science & Hr. Edn For Women University,Coimbatore, Tamil Nadu

    Badruka College Of Commerce And Arts, Kachiguda, Hyderabad,Telangana

    =========================================================================

     

    3) Try the same scenario - it will fetch the details

     

    The field "Enter College Name" may not have anything to do with this, but this is how i use it in the form

    Hope this is clear

    regards

    Harish



  • Profile Image
    ashwin_d
    Answered on July 30, 2019 at 05:06 AM

    So does that mean when you have "&" added in the autocomplete field items, the data is not populated in through the spreadsheet to form widget? Or in other words, if text with "&" is searched in the spreadsheet to form widget, it is not able to search and populate form field?

    I did test your form and it seems to work as expected if the value contains "and" instead of "&". Please check the screenshot below:

    1564477336spreadsheet.gif

    Please confirm if this is the issue you are having, we will test this issue and escalate it if we are able to replicate the issue.

    We will wait for your response.


  • Profile Image
    harishkota.general
    Answered on July 30, 2019 at 05:14 AM

    Yes your understanding is correct, with "&" and spillover to next line does not work. If "&" and it does not spill over to next line it works. I am not sure it is an issue in autocomplete field to Spreadsheet to Form widget or only in Spreadsheet to Form widget

    thanks for your patience and understanding

    regards

    Harish

  • Profile Image
    Victoria_K
    Answered on July 30, 2019 at 06:52 AM

    Hello Harish,

    You are right, if an option contains '&' character, widget will not recognize the input correctly. That's because '&' strips everything that goes after it. I will create a ticket for this and our developers will check if this can be improved. 

    For now, I can only suggest not to use '&' for access codes. Please replace those characters with 'and' on the sheets. 

    If there would be news for the ticket, we will inform you right away.

    Thank you.

  • Profile Image
    NeilVicente
    Answered on August 01, 2019 at 09:46 PM

    Hi Harish,

    This bug is now fixed.

    Kind regards,