Hi,
I have a data lookup (Likelihood Scores) inside a repeating section.
I would like to get the max / highest score.
How can I get it?
See attached screenshots.
Solved
How to Get the Max / Highest Number from Repeating Section
Best answer by Gavin-Adams
The only way I could work it out was to put a number control in the repeating section
(set range validation to yes min 1 max 5, and data type integer.)
you could add a description or label to describe the numbers.
Then in a variable do a max function around the form.repeatingsection.intcontrol
Then I added the variable into a label outside the repeating section on the form.
It's not pretty but I couldn't see a way on the row by row to convert the text dropdown to an integer for use in the max function.
+13The only way I could work it out was to put a number control in the repeating section
(set range validation to yes min 1 max 5, and data type integer.)
you could add a description or label to describe the numbers.
Then in a variable do a max function around the form.repeatingsection.intcontrol
Then I added the variable into a label outside the repeating section on the form.
It's not pretty but I couldn't see a way on the row by row to convert the text dropdown to an integer for use in the max function.
Translate
Hi Gavin,
Thank you so much for validating that we can't convert the text dropdown to an integer for use in the Max().
Will try the solution you recommended.
Cheers,
Michael
Thank you so much for validating that we can't convert the text dropdown to an integer for use in the Max().
Will try the solution you recommended.
Cheers,
Michael
Translate
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.