minListValue ( ~list )
Returns the minimum value from a filemaker value list.
Be the first to rate this function Log in to vote
|
Benedick Miller - Show more from this author |
Sample input:
(1¶2¶3)
Sample output:
1
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Returns the minimum value from a filemaker value list.
Uses the While() function FileMaker Minimum version 18 required.
Comments
 |
Tim Anderson, Tim Anderson Group Jan 2, 2024 |
|
| Hey Ben, Hope you are well. I have always used something like the below for these operations - admittedly pre 'while'. Any benefit in using 'while'? Perhaps for longer lists? let( [ _listin= "(1¶8¶3)"; _list=substitute(_Listin; "¶"; ";") ] ; evaluate("Min " & _list ) ) |
||
|
Benedick Miller Jan 3, 2024 |
|
| Hi Tim, you are right! In truth i forgot that Min & Max can take more than 2 parameters! So your way is probably simpler than using while. I probably overuse While because I like the logic of it. At very least perhaps this is an example of how while works, as you know there are often several ways to solve a problem with FM :) |
||
|
Benedick Miller Jan 3, 2024 |
|
| ...continued. I did write my custom function to update a recursive custom function I found, but as you have pointed out the recursion is not really needed in this case. | ||
|
Tim Anderson, Tim Anderson Group Jan 4, 2024 |
|
| I have to admit to also favouring While. Often after spending some time working on a While calc I realise I am over complicating things! Keep well |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.