Custom validation script with checkbox rules

Question

Hey guys, I have been learning quite a bit by asking my javascript questions here and listening to your responses. I really appreciate all the help I have gotten so far! I am at it yet again though, and now I would like to expand my current validation script to add a condition.

I have a text box that is a calculated % derived from some other boxes, and I have it changing colors based off the value. The twist is that I would like it to use one value if a certain checkbox is checked, and a different value if a different checkbox is checked.

The current validation script I am using is:

var v = event.value;

if (v>.7649) {event.target.fillColor = color.green;}

if (v<.7650) {event.target.fillColor = color.red;}

How would I modify this so that it also checks to see if a checkbox is checked as a condition? and is it possible to do like an "else" statement to use a different value if that checkbox is NOT checked, or if a DIFFERENT checkbox is checked? either way...

FYI the checkboxes are all named the same (Checkbox1), but the output values are different so that way only one can be checked at any given time.

Thank you again for all your help and support!

Nesa Nurani · Accepted Answer

So to incorporate the 2 different color change conditions, would something like this work? Sorry, I am not at my workstation currently...

var v = event.value;
var c = this.getField("Checkbox1").valueAsString;

if((c == "A" || c == "B") && v > .7649)
{event.target.fillColor = color.green;}
else if((c == "A" || c == "B") && v < .7650)
{event.target.fillColor = color.red;}

if(c == "C" || c == "D" || c == "E" || c == "F") && v > .8149)
{event.target.fillColor = color.green;}
else if((c == "C" || c == "D" || c == "E" || c == "F") && v < .8150)
{event.target.fillColor = color.red;}

If you use it in a field where you wish to change color as a calculation script, it should work.

Just fix small bug, you are missing parenthesis here: if((c == "C"

Also consider adding default color if no checkboxes are selected.

Nesa Nurani · Answer

Let's say you have two checkboxes with export values 1 and 2, you can use something like this:

var v = event.value;
var c = this.getField("Checkbox1").valueAsString;
if(c == "1" && v > .7649)
{event.target.fillColor = color.green;}
else if(c == "2" && v<.7650) 
{event.target.fillColor = color.red;}

I would suggest you to use it as calculation script, validation will not work if checkbox is checked after value is changed in field.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded