I am at a lost right now on how to accomplish this task. The endstate is I want one text field to calculate using criteria from a table. I know this is confusing. Here is the layout. I want to search the table by using the age, and then to search another criteria for how many repititions was perform...

Enter this under the "Change" option of the script editor for the checkbox. just rename your fields appropriately. The second "If" will reset the fields if they accidently clicked it. Name[1] is the field you want the checkbox to fill. 'Name' is the original field.if (this.rawValue == "1") {  this.r...

You should be able to just set those to java and still use formcalc throughout the rest of the form

Can you post the form or send it to me?To be clear, you want it so that when any item is clicked, it will show which item is click in another location on the form?

Try this.Using Javascript. Under change, put these for your checkboxs. Rename appropriately. Checkbox1if (this.rawValue == "1") {  this.resolveNode("CheckBox1").rawValue = "0";}Checkbox2if (this.rawValue == "1") {  this.resolveNode("CheckBox2").rawValue = "0";}

Radzmar,Thanks for the reply. I have already tried that, but it only rounds with normal expression, not the one I am trying to get. I have played around with the 'Floor' and 'Ceil' functions, but I need to find a way to get them to express correctly also.

I am trying to get help with an expression. I have not had any luck, and not that great at scripting. I need to be able to express my numbers in a different manner than normal expression. This is the rule I have to follow:  "When expressing to the nearest whole number, express to the nearest even nu...

It was helpful and got it working. I'm trying to mess with it right now. But with that script it only makes it green. I tied typing in r or y and it comes up white or no fill. But I'm trying to tinker with it. I appreciate it so much Mandy!!!

I have four values that I want to input into a field. What I am trying to make happen is when you type in a letter, that text field will then highlight or fill to a certain color. Can anyone help me? And I want to have four values in it. The values would be "G" "R" "Y" and "0". If I type in "G" I wo...

=IF(SUM(B14:B15)/2=0,"",Bround((SUM(B14:B15)/2),0))   hopefully this may help. This is what the formula looks like in excel. I have tried working with it but still getting a lot of errors. Still any help would be great. Also, not sure how it works. But using the help, I got this answer "However, the...