- ccnewslettersAsked on May 06, 2015 at 07: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?
- BorisAnswered on May 06, 2015 at 09:36 PM
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.
- ccnewslettersAnswered on May 19, 2015 at 12:44 PM
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.
- JotForm SupportKiranAnswered on May 19, 2015 at 01: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.
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.
- ccnewslettersAnswered on May 19, 2015 at 10:32 PM
Thank you. That was a very helpful work around. Appreciate the quick response.
- JotForm SupportKiranAnswered 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!!
- JotForm SupportKiranAnswered on February 05, 2017 at 02:04 PM
Your question is moved to a separate thread and shall be addressed there shortly. Please follow the link below: