Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Finding the highest value in user entered numeric fields.

Avatar

Level 2

I have a number of user entered numeric readiings on a form. Lets say 13 for now(rhr1-rhr13). I wish to pick the highest value of all of these user entered numbers and autopopulate another "Highest reading" Field(Hr1) with the highest reading. How could I do this in an elegant manner using FormCalc? I say FormCalc because that is what I have been using lately in the form to resolve other issues. I am not opposed to a java solution if that is what is called for. I also want to make sure all the appropriate fields are populated before throwing down a number as well.

Thank you very much.

Here is what I have so far:

HR_1.rawValue = Max(Rhr1.rawValue[0], Rhr2.rawValue[0], Rhr3.rawValue[0], Rhr4.rawValue[0], Rhr5.rawValue[0], Rhr6.rawValue[0], Rhr7.rawValue[0], Rhr8.rawValue[0], Rhr9.rawValue[0], Rhr10.rawValue[0], Rhr11.rawValue[0], Rhr12.rawValue[0], Rhr13.rawValue[0])

Ok. it took me some time but I figured it out. Thanks. You guys are awesome.

1 Reply

Avatar

Level 1

Are you able to share your solution, if you still have it? I am trying to do the same thing, but to no avail.

Thanks!