How to clear or reset a widget field upon submission

Hi SubZeroSW,

Thanks for reaching out to Jotform Support. Can you send us the link to your form so we can take a look for you? Also, can you share a quick screen recording of what’s happening so we can try to replicate it on our end? You can upload it to Google Drive, Dropbox, or record with Loom and send us the link.

And it seems like you're referring to the Spreadsheet to form widget, so for us to test properly if you can include sending us the link of a copy of the Spreadsheet you're using on as well. I’ve gone ahead and moved your other question to a separate thread to keep things tidy, and someone from our Support Team will help you out with it here.

Once you get back to us, we can take the next step toward solving this.

https://form.jotform.com/SubZeroSW/special-price-request

It is to work with each of the model numbers and pull pricing information based on Tiered pricing structure.

https://www.awesomescreenshot.com/video/46715537?key=35359aa52bfd3bcb67bf86938872a7ae

Hi SubZeroSW,

Thank you for sharing the video and your form link.

Our team cloned your form and tested the Spreadsheet to Form widget and your conditions on our end following the same steps shown in your recording, but so far our team haven’t been able to replicate the issue - the fields are behaving as expected here. Because of that, We'd like to run a few more checks and review the conditions and widget settings in more detail to see what might be causing the behavior on your side.

We are still investigating this and will update you on this thread as soon as we have more concrete findings or a possible workaround.

This reply is confirmed by Raymond M.

Hi SubZeroSW,

Thanks for your patience.

We tested this on our end by cloning your form and also by creating a new test form with the same conditions. In both cases, the related fields were filled correctly, and the Spreadsheet to Form widget was triggered as expected during edit submissions.

Since we couldn't reproduce the issue, it's possible that the form was initially submitted in a different way. For example, through URL parameters or another method which may have caused the "Model #1" field to populate without triggering the widget.

To help us narrow this down, could you share how the form was initially submitted when the issue occurred? This will help us identify what might be causing the behavior you experienced.

This reply is confirmed by Raymond M.

To clarify, when the forms were originally filled out, the worksheet to form had an old price sheet attached. Same layout, same headings. But it was different pricing before we had a price increase. When they go to edit the submission, we have the Model Number they put in LOCKED. So they cannot change it. But I want to find a way to take and re-copy the Model #1 in the the Model Number Verificatioin #1 to create a pull again from the NEW worksheet that has been uploaded in the widget.

I tried making a condition that if Standard and Option was filled it would trigger the copy. I had the Standard and Option blank out by edit condition, so it would need to be re-established. But that did not work.

The only way I have found it to work is to actually re-type the model number. I can't have that, as once they enter it, that model is locked and we don't want them to change it.

Hi SubZeroSW,

I'll need a bit of time to look into this. I'll get back to you as soon as I can.

Hi SubZeroSW,

I tested this on a demo form and confirmed that the Spreadsheet to Form widget works differently in edit mode. Even with conditions in place, it won’t trigger automatically through the edit link because the widget only runs when the field value updates.

The good news is we found a workaround. We can add conditions that force the field to update, and that will make the widget run as expected. Set up the two Update/Calculate field conditions as you see below:

Also, to avoid any conflict with the new logic, you’ll need to disable or remove the following three conditions so everything will work as expected once the new conditions are in place:

You can test this demo form, or clone it to your account if you'd like to use it and check on the form elements and conditions.

Try that out and get back to us if you have any issues.

https://www.awesomescreenshot.com/video/46920900?key=212924afbed980a66c13a8f1c47fbafe

Wanted to share the video showing that it is still not working on my end.

I have removed the conditions you told me to and added the conditions for both Model #1 and Model #2 into the system to test. Did I do clear field correctly? You just hit space bar enter and then go back and highlight it as nothing, right?

Hi SubZeroSW,

I checked your form, and it seems that you haven't updated the second condition. Here is the other condition formulated by my colleague:

Here is the current condition in your form:

Can you check again?

Keep us posted if you run into anything else.

Still not working on my end. Is there a good way to convert the Edit Submission to NO after a quote has been edited. Therefore the next time they 'edit the quote again', it defaults to NO to reset the fields?

https://www.awesomescreenshot.com/video/46922831?key=2fbb92231243e015aadf6b6036da3f18

Hi SubZeroSW,

I’ve gone ahead and reported this to our Developers so they can figure out what’s going on. We’ll be back with an update as soon as we can.

Hi SubZeroSW,

To help us better troubleshoot the issue, can you share the Excel sheets you used for the spreadsheet to form widget? You may populate the files with dummy data.

Once we hear back from you, we can get moving on a solution.

How do I add the excel here?

https://docs.google.com/spreadsheets/d/1IRFtCs3OXvtH_WMFlVnWKc4Z-xXWyNGp/edit?usp=sharing&ouid=108918086463587204470&rtpof=true&sd=true

Please let me know if this works?

Hello SubZeroSW,

Thanks for reaching out to Jotform Support. I’ve passed this along to our relevant team and will update you as soon as we hear back from them.

Hi SubZeroSW,

Can you give us permission to view the shared file? We are unable to access it right now:

Once we hear back from you, we can get moving on a solution.

Please try now.

I have not heard from anyone in over a month.

Hi SubZeroSW,

After investigating, I found that the field labeled with PV #1 doesn't have conditions to pass the value from the Model Number #1 field to the PV #1 field. Check out the screencast below:

To fix it, we just need to add a set of conditions like you see in the screenshot below:

1. While in Conditions under the Settings tab, click on the Add Condition button.

2. Select Update/Calculate Field.

3. Set the conditions like you see in the screenshot above, and then click on Save at the bottom.

Give it a try and let us know how it goes.

I do have that already.

Hi SubZeroSW,

I can confirm that this issue is different from what's initially reported and escalated. To keep the conversation organized, I moved your other question to its own thread, and someone from our Support Team will help you with it here.

Let us know if anything else comes up.