Spreadsheet to Form Widget is not working correctly

  • Profile Image
    PensacolaMESSHall
    Asked on September 16, 2025 at 6:09 PM
    I am wondering if the "condition" I chose
    (copy date field value to the Spreadsheet to Form when the name field is
    filled) is not the right "autofill"?
    https://form.jotform.com/252586709498072
  • Profile Image
    Mary JotForm Support
    Replied on September 16, 2025 at 6:36 PM

    Hi Megan,

    Thanks for reaching out to Jotform Support. I checked and see that your condition is working correctly. But, the code is not working:

    Spreadsheet to Form Widget is not working correctly Image 1 Screenshot 20Can you check if the access code you have set up in the spreadsheet matches the date format in the form?

    Let us know how it goes.

  • Profile Image
    PensacolaMESSHall
    Replied on September 16, 2025 at 6:40 PM
    Part of the challenge is that it defaults to today. When I enter a date
    that is actually in the spreadsheet (10/01/2025) it works okay.
    Spreadsheet to Form Widget is not working correctly Image 1 Screenshot 20
    ...
  • Profile Image
    Jonathan JotForm Support
    Replied on September 16, 2025 at 6:52 PM

    Hi Megan,

    It appears that you've included a screenshot in your latest response, but it was not successfully uploaded. Could you retry send the screenshot of what’s happening? That'll help us understand better what’s going on. Let me show you how to post a screenshot to our Help Center:

    1. On the Help Center page, scroll down to the Your Answer section and click on the Image icon.

    2. Drag and drop your image into the Upload box, or click on it and select your file.

    3. Then, click on the Add button in the bottom-right corner of the window.

    Spreadsheet to Form Widget is not working correctly Image 1 Screenshot 30

    4. To resize it, click on your screenshot and then click on one of the boxes in the corners, and drag it inward.

    5. Once you're finished, click on the Post Answer button at the bottom right of the Your Answer section.

    Spreadsheet to Form Widget is not working correctly Image 2 Screenshot 41 Once we hear back from you, we'll be able to help you with this.

Your Reply