-
ccnewslettersAsked on May 6, 2015 at 7:37 PM
Is there a way to lock the data in fields so that they can not be altered?
I have a number of formulas that populate various fields for pricing. I found that I can go back and change the final price that I will be charged. How can I lock the data in the field, once it has been entered, from being changed?
Are there certain field types that have that function?
-
BorisReplied on May 6, 2015 at 9:36 PM
Hello ccnewsletters.
Please note that only the calculation fields can be made read only / not editable / locked.
It seems that you are on the right track, by using the "Read only" in your calculation fields. However, as you are actually filling the amount by using the Conditions, and not by calculating it directly in the calculation fields, you've encountered slight issues with them still being editable.
I would kindly suggest that you add a number 0 in your calculation fields, so that there is an initial value of zero before the Conditions update the values in the way that you have set up.
As some of your fields are not calculation fields, I would advise you to change them into calculation fields in order to make them non-editable. Such are the "Shipping Subtotal (extra pieces) $", "Cost to Print", "Cost to Mail", "Cost to Ship", and "TOTAL COST".
Once you add calculation fields instead of these regular fields, please remember to redo their conditions, so that the values are updated as expected.
Please let us know if this has resolved your issues with the fields not being editable.
Kind regards,
Boris -
ccnewslettersReplied on May 19, 2015 at 12:44 PM
Hi,
Thank you for your previous help. I was able to update the majority of the fields so they could not be changed however, the printing subtotal, mailing subtotal and shipping subtotal fields have many calculations in the conditions. Changing those to calculation fields will be a big pain in the butt.
Any advice as to how I can make that switch easier?
Thanks in advance.
Laura
-
Kiran Support Team LeadReplied on May 19, 2015 at 1:56 PM
Unfortunately, there is no direct method to change the field to readonly in this case. However, we have a workaround by hiding and copying the value of calculation field to a new text field that can be made readonly.
Please follow the steps below :
1. Add a new textbox field below the calculation field
2. Add a new condition to copy the value of calculation field to the text box field when the value is calculated
3. You can hide the calculation field by clicking on Hide field option from quick menu of the calculation field.
This method can be followed to the other calculation fields on your JotForm. Please see the demo form below.
http://form.jotformpro.com/form/51385667417969?
I've updated this JotForm with the field Printing subtotal only. Please feel free to clone this JotForm to your account to see how it works.
Let us know if you need any further assistance. We will be happy to help.
Thanks.
-
ccnewslettersReplied on May 19, 2015 at 10:32 PM
Thank you. That was a very helpful work around. Appreciate the quick response.
-
Kiran Support Team LeadReplied on May 20, 2015 at 12:32 AM
We are glad to see that the provided workaround works well for you. It's our pleasure to assist you. Please do not hesitate to get back to us if you need any further assistance. We will be happy to help.
Thank you for using JotForm!!
-
eganet2Replied on February 5, 2017 at 12:56 PM
-
Kiran Support Team LeadReplied on February 5, 2017 at 2:04 PM
@eganet2,
Your question is moved to a separate thread and shall be addressed there shortly. Please follow the link below:
https://www.jotform.com/answers/1057153
Thank you!