Spreadsheet to form widget does not clear fields

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

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.

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

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.

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

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. 

No issues, this is fine