Spreadsheet to Form not auto-filling all fields

  • Profile Image
    chadallisonat
    Asked on November 05, 2021 at 12:45 AM

    Help pls.

    As I understand the Spreadsheet to Form column should auto-fill all the fields after it as long as the field labels and column header names match. I've tried different ways but the widget won't fill 2 of fields I have. Can you help please. I can't see what's wrong anymore. I need fresh eyes to look at my form. Also note, that I have the same set-up with other forms and they work perfectly fine.


    1636087399_6184b667e73e9_

  • Profile Image
    Ashwin
    Answered on November 05, 2021 at 02:42 AM

    Yes your understanding is correct. The question label of your form and the column label of your Excel spreadsheet should match. Once the user input the unique code in the widget, it will fetch the existing row data from the Excel file and populate in the form field.

    I would suggest you to please share a screenshot of the uploaded Excel file columns and we will take a look.

    We will wait for your response.

  • Profile Image
    chadallisonat
    Answered on November 05, 2021 at 04:24 AM

    Thank you for your response. Here's a snippet of the excel sheet. I hope this helps.

    1636100621_6184ea0d4f100_


  • Profile Image
    chadallisonat
    Answered on November 05, 2021 at 06:29 AM
  • Profile Image
    Niko
    Answered on November 05, 2021 at 07:03 AM

    Greetings,

    Thanks for providing additional details.

    Please allow me some time to check and test your form.

    I'll get back to you as soon as possible.

    Thank you!

  • Profile Image
    Niko
    Answered on November 05, 2021 at 07:23 AM

    Thanks for your patience.

    I've checked your form and found that there were two issues causing the widget not to populate fields as expected:

    1) Your form fields names missed the # sign at the end, so I've added it:

    1636111076_618512e4d2d4e_Screenshot 2021


    2) On the spreadsheet file there were additional space characters after the column names, so I also removed them and saved them:

    1636111346_618513f2d5e7d_demo123456.gif

    I've updated the spreadsheet file on your form and it should populate fields as expected now.

    Could you please check?

    Thank you!

  • Profile Image
    Michael
    Answered on November 05, 2021 at 07:25 AM

    We would like to apologize for any inconvenience. I have checked the issue you are having and it seems that the issue is with the label of the TRW# and GVW# fields on your form.

    1636107302_618504263b85c_zt211105_061139

    Updating the label of the fields to remove the extra space at the end should still be fine since your form does not have any submissions yet.

    You would also need to update the column headers on the uploaded spreadsheet for TRW# and GVW#.

    1636107978_618506ca8f3fb_zt211105_061919

    Please upload the updated version of the spreadsheet and test your form again after.

    Here's a cloned version of your form where I tested the solution above: https://form.jotform.com/213082161617954

    Feel free to let us know if you need any further assistance.

  • Profile Image
    chadallisonat
    Answered on November 05, 2021 at 08:59 AM

    I just checked it and it works perfectly!! Thank you, thank you! I knew it was an error in my end. Thanks for the help!