JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Locking fields - making them read onlyAsked by ccnewsletters 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?
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.
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.
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.
Thank you. That was a very helpful work around. Appreciate the quick response.
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!!