Copy link to clipboard
Copied
Hi,
My team has a document that we use to determine whether to launch a project or not based off of a point value system based on several criterias. There is a Total Score that is calculated with a value is sum(+) function and a Overall Rating that is calculated with a value is the average function. At the end of the document are two check boxes to either launch or not to launch the project. We would like these checkboxes to trigger based on the Overall Rating criteria.
- GO=requires 2 points and higher
- NO GO= anything under 2 points
I am not well versed in javascript so I was hoping someone could get us pointed in the right direction. If anymore information is needed, please me know and ill provide what I can.
Thank you in advance!
Copy link to clipboard
Copied
If your checkboxes are named "GO" and "NO GO" you can use this as 'Validation' script of "Overall rating" field:
this.getField("GO").checkThisBox(0,Number(event.value)>= 2 ? true : false);
this.getField("NO GO").checkThisBox(0,Number(event.value) != 0 && Number(event.value) < 2 ? true : false);
Copy link to clipboard
Copied
Yous just need the chexkboxes to get ticked automatically based off of a total value that executes in the sum field, correct?
What role is the field that calculates theAverage total field playing in relation to the checbox objects or the sum field?
Copy link to clipboard
Copied
If your checkboxes are named "GO" and "NO GO" you can use this as 'Validation' script of "Overall rating" field:
this.getField("GO").checkThisBox(0,Number(event.value)>= 2 ? true : false);
this.getField("NO GO").checkThisBox(0,Number(event.value) != 0 && Number(event.value) < 2 ? true : false);
Copy link to clipboard
Copied
Wow, this did exactly what we wanted. I sincerly appreciate your help Nesa!
Best Regards!

