Copy link to clipboard
Copied
I have created an auto calculation form with all fields are auto-populated but there are four sections of percentage and my task is to last three fields of percentage will be locked out and read-only and just first one of "PRODUCTION REVENUE PROJECTIONS" will be open for the user to enter the percentage.
Here is the actual FORM can anyone help how to other three percentage field read-only I know I can make all fields same name to populate data to all fields but this way I cannot lock other three fields and that is the real problem.
You need to change their names and use a script to copy the value of the editable fields to them.
For example, rename the last three copies of "SR1" to "SR1Copy" and apply the following custom calculation script to them:
event.value = this.getField("SR1").valueAsString;
Copy link to clipboard
Copied
You need to change their names and use a script to copy the value of the editable fields to them.
For example, rename the last three copies of "SR1" to "SR1Copy" and apply the following custom calculation script to them:
event.value = this.getField("SR1").valueAsString;
Copy link to clipboard
Copied
Exactly what I thank you so much for your great help I really appreciate this.