Spreadsheet to form widget does not clear fields

  • Profile Image
    harishkota.general
    Asked on April 26, 2019 at 07:06 AM

    hi Jotform team

    It was mentioned that this defect was fixed and uploaded in March 2019, but i still see the issue, if wrong code is entered the contents do not get cleared

    regards

    Harish

  • Profile Image
    Richie_P
    Answered on April 26, 2019 at 10:45 AM

    We are sorry for the inconvenience this may have caused.

    Can you please share to us your Spreadsheet code to populate your field so that we can test it out?

    To clarify, fields are still populated even if the wrong code is added to the Spreadsheet to form widget?

    Or do you want to clear any fields that was added when the wrong code is added?


    Looking forward for your response.

  • Profile Image
    harishkota.general
    Answered on April 26, 2019 at 12:12 PM

    Hi Richie

    my sheet is https://www.jotform.com/build/91055272451452

    I have set Reset Fields when invalid = YES, but when an invalid value entered it should clear the field which it does not

    regards

    Harish

  • Profile Image
    Richie_P
    Answered on April 26, 2019 at 01:49 PM

    I have tested this feature and it seems to be working correctly at my end with my sample form.

    The populated fields are cleared once you input a wrong code.

    Can you please share to us the populate field code for your form?

    Do note that the widget will only clear the auto populated values in the field. If you have inputted a value manually on the field, this will not be cleared by the widget.

    Hope this information helps.

  • Profile Image
    harishkota.general
    Answered on April 26, 2019 at 10:49 PM

    Thanks i think i misunderstood the functionality, i was under the assumption that the field where you are typing Unique will also be cleared

    regards

    Harish

  • Profile Image
    Welvin
    Answered on April 27, 2019 at 02:41 AM

    No, the Spreadsheet to Form input box won't reset because that will determine the value if it's present or not to trigger this validation. Would you also like to reset the input box? We can submit a feature request ticket here. 

  • Profile Image
    harishkota.general
    Answered on April 27, 2019 at 04:45 AM

    No issues, this is fine