Conditions causing data to be removed upon editing

Hello,

I have a condition set to insert the text "See Attached" into the first row of the "Make" column in my "Truck Information" input table if the "power unit" field is greater than 5.

My problem is that whenever edit a submission, anything I had typed into the first row of the "Make" column gets deleted upon editing the submission via edit link or the submissions page on jotform's website.

This issue also happens with other input tables under the same conditions. Is there a way to retain the conditions I have set without having to have users data deleted upon editing?

The issue is most likely related to the Clear Hidden Field Values option inside of the Form Settings. It is currently set to Clear on Submit. Please change it to Don't Clear and test the form again. 

That did not work

You can revise your condition that will work only if it's NOT on edit mode. If it's on edit mode, this condition won't work.

To do that,

1. Add the Get Form Page URL Widget to your form.

2. Then in your condition, modify it like the following.

That also didn't work. above is a screenshot of the condition.

Values were still being automatically removed from the input table upon editing.

The conditional logic cannot append a value to an existing entry. It will erase the value when the logic is meet. In this case, I don't think this will work. You may consider doing this on another field, maybe a static Text field to show up for the desired logic. 

The condition is not being met, yet it still clears the values in the output field for the condition. I need it to be on the input table for my PDF to look right.

I don't see why the output table needs to be accessed at all before the condition is met, was thinking that there might be a way to change the coding so that this doesn't happen.

I do not understand exactly which data are you editing. 

Can you please tell us exactly which values are being removed from which table after you edit a submission? 

Also please tell us which data are you editing. If possible also provide us a link of the edit link that we can use to test the issue.

https://www.jotform.com/edit/4495469542224169026

On this submission, in the first row of the Truck Information table, "Ford" is in the Make column. In the first row of the Trailer Information table, "Great Dane" is in the Make column.

When you click the edit link and go back into the submission, "Ford" and "Great Dane" are gone.

I have a condition set to insert text into the 1st row of the Truck Information table in the Make column is IF Power Units > 5. I have a similar condition set to insert text into the 1st row of the Trailer Information in the Make column IF Trailers > 5.

On this submission, Power Units = 1 and Trailers = 1, so neither condition is satisfied.

The values are present in these fields. I do not know if you have figured that out already or there is a glitch. Did you do something after posting your reply? See the following screenshot:

Both fields are filled as you could see. 

I see no problem with these fields considering that you have two conditions on each field only, one to fill it and another to hide, and I don't think hide will break it. 

No, I didn't change anything. Below is a screenshot from when I click the link from this thread:

I am on Google Chrome, not sure if that is why it is doing this for me and not you.

Would you mind checking with your other browsers? Try with private/incognito as well.

Are you entire form submissions like this or just a few?  

I tried Microsoft Edge, regular and private browser, and Google Chrome incognito and none of them worked.

I tested this submission (4495469542224169026) on my end and it works as expected. Please see my screencast below:

I tested it on the edge, firefox, opera, and chrome browser, and it shows the data or "make" values.

Please try clearing your browser cache and cookies and see if that will fix the issue on your end. Make sure the autofill is cleared as well.

I cleared my cache and cookies and disabled autofill and it is still the same. A coworker tried editing as well and had the same problem.

I just tried it on another pc and it's really working as expected. Can you please let us know if we can submit a test submission on the form so that we can test the new submission to our end and then you can also try it at your end.

By the way, can you please try to access the edit link using your mobile device?

Looking forward to your response.

Yes you can make a test submission, please put "David Cook" in the "Producer" drop down. I tried on an iPhone XS safari browser and it still was clearing out the values.

Hello @davidcookmig - I just tested your form and the edit submission seems to be working fine in my end.

Please try to access this link and let us know how it goes on your end: https://www.jotform.com/edit/4500729796023060904

Thank you.

No it is still the same, please see the GIF below:

I can now replicate this problem in the form. I don't know what clears it. It a bit odd and can't seem to troubleshoot it. Would you mind checking if other submissions are doing the same? How about re-submitting this particular submission? That may fix it. Please try that.

Tried both with no result

Sorry to hear that. We will investigate this further and get back to you with updates.

Sorry for the delayed reply. On my initial test, disabling the following condition fixes the problem so it really has something to do with this particular condition that reacts intermittently on the browser perhaps due to conflict, or the browser was unable to interpret it properly because it's vague.

To explain your condition, when the Power Units is greater than 5, it inserts *See Attached into the first Make field on the input table. The problem is that it doesn't have an alternative condition for its opposite so the browser thinks that if it's NOT greater than 5 that are entered (opposite of your condition), it inserts nothing or empty on the field. This is the reason why the existing value is sometimes overridden on edit mode.

Here's an example (I've shown the field and modified it for demo purposes).

7 - Inserts the *See Attached text

1 - Removes the value (because it does not meet the condition)

This is how the browser interprets the condition. It doesn't keep the existing value because it wasn't instructed this way.

You can try this fix,

1. First, add a form calculation widget in your form that captures the entered Make value on the truck information table.

Example:

Make sure it is on Text string format (A-Z)

2. Add a calculation condition in your form that copies the form calculation field value back to the truck information table when Power Units is LESS THAN 6 (so 5 below retains the existing value). Example:

You can apply the same for the Trailer Information field. You need to add a separate form calculation widget for it.

Here are the final conditions:

You can try my cloned form with this changes https://www.jotform.com/edit/4501819013586862471

This resolved the issue, thank you