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
Vote Up 0 Vote Down
David Costin asked 1 year 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
Vote Up 0 Vote Down
Rob LeVineRob LeVine Staff answered 1 year ago

I don't see how to do it without Javascript/jQuery. You could use something like this.

Vote Up 0 Vote Down
Victor Font Staff answered 1 year 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.

Vote Up 0 Vote Down
David Costin answered 1 year 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