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