SIGN UP

Show highest value in a range

By: David Costin | Asked: 01/31/2024
Forums › Category: How-to › Show highest value in a range
0 Vote Up Vote Down
David Costin asked 9 months ago
Is it possible to identify the highest value in a range of fields: [1234] [4321] [2341] etc? In Excel this would be: =MAX(A1:A6) A number of Excel formulas work in Formidable, but not this one.   David
3 Answers
0 Vote Up Vote Down
Rob LeVineRob LeVine answered 9 months ago
I don't see how to do it without Javascript/jQuery. You could use something like this.
0 Vote Up Vote Down
Victor Font answered 9 months ago
You should be able to this with a calculated field and the Javascript Math object. You use the Math.max() function. This is the Knowledgebase article that shows you how to do it: https://formidableforms.com/knowledgebase/field-calculations/#kb-advanced-numeric-calculationsarticle.
0 Vote Up Vote Down
David Costin answered 9 months ago
Many thanks for your prompt reply and advice.  I will give it a go.   Regards   David

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right