Spreadsheet to Form widget: scrolls/highlights fields that are being populated

  • Profile Image
    mjlasswell
    Asked on July 31, 2019 at 12:10 PM

    Hello,

    I've created a form using the "Spreadsheet to Form" widget and uploaded a corresponding spreadsheet. It's working fine, except for one issue: when the unique code is entered in the widget field and the answers are auto-filled, the form automatically scrolls down to "Does your company have any additional locations/branches?", skipping a whole series of questions. The problem occurs in both Chrome and Safari, but not in Firefox, whenever a multiple choice or single choice question is utilized.

    Do you know how I can configure the form or widget to avoid this problem? You can use the unique codes "testing1" and "testing4" to auto-fill the form and troubleshoot. Thank you for your help!

  • Profile Image
    Richie_P
    Answered on July 31, 2019 at 01:53 PM

    I have tested a cloned version of your form and replicated the issue using Chrome but the form works correctly in FireFox.

    I have tested  our sample form with the Spreadsheet to form widget and it seems to be working correctly.

    https://form.jotform.com/81225198727968

    Can you please try to disable the condition you have added in your single choice field?

    Let us know how it goes.

  • Profile Image
    mjlasswell
    Answered on July 31, 2019 at 03:23 PM

    Hello,

    I disabled the condition as you suggested, but the form is still scrolling down upon auto-fill. In fact, I tested the demo form you included in your answer, and it appears to have the same problem - when I enter the unique code, the form skips down to the "Multiple Choice" question and highlights the selected checkbox. So it appears there is a defect with the widget in general?

    I appreciate any other help you can offer! 

  • Profile Image
    Richie_P
    Answered on July 31, 2019 at 03:57 PM

    It seems you're right. The multiple choice/single choice fields are highlighted/scrolled when populated using the Spreadsheet to form widget in Chrome and edge.

    I'm not sure if this is a bug however I have forwarded this to our developers for further information.

    You will be notified via this thread once updates are available.



  • Profile Image
    NeilVicente
    Answered on August 12, 2019 at 11:05 PM

    This is fixed now.

    Cheers!