Spreadsheet to Form Widget: Required fields are not pre-pupulated

  • Profile Image
    friendlyagent
    Asked on March 06, 2018 at 10:16 AM

    Hi, 

    the spreadsheet to form widget is not working in most of the forms where I have it. In one of them it worked last week when I first set it up but it's not working now. I have followed the instructions on how to get it to work many times now trying to fix it but nothing.

    I also tried the spreadsheet to form in the preview link, on the link for the form and also embedded on our website and nothing. Also, when I run it, it finds the unique code but it doesn't fill anything

    https://form.jotform.com/80566177995171

    https://form.jotform.com/80566116695161

    https://form.jotform.com/80566024395156



  • Profile Image
    BJoanna
    Answered on March 06, 2018 at 12:08 PM

    I tested the Spreadsheet to Form widget on one of my form and it is working properly. I also tested the form from the Spreadsheet to Form guide and the widget is working there as well. 

    Did you made any edits on your form when the widgets stopped working? If so, make sure that the Column Names on your sheet match the Field Labels on your form.


    Can you provide codes that we can use to test the widgets on your forms? 

  • Profile Image
    friendlyagent
    Answered on March 06, 2018 at 12:43 PM
    Yes, for the offer submmission you can use: tyler, barry, rachel, tracy,
    christina
    For the other ones any of the numbers below:
    5713
    1509
    3412
    3311
    2227
    201
    7140
    3508
    416
    1214
    623
    315
    1305
    1312
    838
    1805
    2113
    5245
    4208
    1416
    6364
    1964
    [image: photo]
    *Luisa Hsiao*
    Marketing and Listing Coordinator, Your Friends in Real Estate Team - BHG
    NAGR
    5224 Indian River Rd Suite 104 Virginia Beach, VA 23464
    | c: 757-636-4637 | f: 866-785-5755
    e: luisa@yourfriendlyagent.net | w: SeeVirginiaBeachVAHomes.com



    Better Homes and Gardens Real Estate NAGR

    ...
  • Profile Image
    BJoanna
    Answered on March 06, 2018 at 01:24 PM

    I tested the form https://form.jotform.com/80566177995171 with the code you provide and I was able to replicate the issue. The widget is showing the message 'Fields have been auto filled.' but the fields are empty. Can you provide us a file that you uploaded to the widget so that we can inspect it? You can send it to our support email at support@jotform.com. Add the ID of this thread 1406427 as the subject of the email and let us know here once you send an email. 

  • Profile Image
    BJoanna
    Answered on March 06, 2018 at 03:15 PM

     

    I cloned your form and made some additional tests and I was able to replicate the issue you reported. I found out that the required form fields are not populated. I was able to replicate the same issue on my test form when I set some form fields as required. I am not sure if this was an issue before but considering that you mentioned that the widget was previously working properly, I will escalate this issue to our developers and we will inform you via this thread once this issue is resolved.

    For now, to resolve the issue you will have to update the Column Names on your sheet and add a space and an asterisk at the end of each required field.

    1520367297name.JPG

  • Profile Image
    friendlyagent
    Answered on March 06, 2018 at 03:43 PM
    Thanks!
    [image: photo]
    *Luisa Hsiao*
    Marketing and Listing Coordinator, Your Friends in Real Estate Team - BHG
    NAGR
    5224 Indian River Rd Suite 104 Virginia Beach, VA 23464
    | c: 757-636-4637 | f: 866-785-5755
    e: luisa@yourfriendlyagent.net | w: SeeVirginiaBeachVAHomes.com



    Better Homes and Gardens Real Estate NAGR

    ...
  • Profile Image
    hayk
    Answered on June 02, 2018 at 07:57 AM

    The Issue has been fixed. Please try the widget once again and let us know. Thanks!