Copy link to clipboard
Copied
Looking for help to create a formula for a text field under these conditions:
- if neither of the checkboxes is selected, the calculation is 0
- if only 1 of the 2 checkboxes is selected, the calculation is 0
- if both checkboxes are selected, the calculation is 2
thanks!
Copy link to clipboard
Copied
Enter the following custom calculation script in the text field:
if(this.getField("Check Box1").value!="Off" && this.getField("Check Box2").value!="Off")
{event.value=2}
else
{event.value=0}
Change the check box field names to match yours, of course.
Copy link to clipboard
Copied
Enter the following custom calculation script in the text field:
if(this.getField("Check Box1").value!="Off" && this.getField("Check Box2").value!="Off")
{event.value=2}
else
{event.value=0}
Change the check box field names to match yours, of course.
Copy link to clipboard
Copied
thank you! That worked perfectly
Find more inspiration, events, and resources on the new Adobe Community
Explore Now