how to determine the highest Value in database ?
I’m not sure what you’re trying to do in your conditional…
But to find the highest value you can just sort the search by that particular field, descending ‘yes’ and select the first item (or descending ‘no’ and select the last item).
I’m not sure what the conditional is for either, but couldn’t they just throw the :max operator on the end of that expression to get the highest value?
Yes it is correct when sorting database in Repeating Group,
But what I’m going to use is for the function here
For example: If the value is the highest it will be green
Well, seeing as you’re already sorting the RG by the value, then the simplest way would be to use the conditional when current cell's index is 1 or when current cell's item is RG's list of items first item
Or
(especially if the RG is not being sorted by value) use when current cell's item is [search for items, sorted by value, descending 'yes'] first item
Or
as @mikeloc suggests you could use the ‘Max’ operator by using the condition when current cell's item's value is RG's list of items, each item's value 'max'
2 Likes
This topic was automatically closed after 70 days. New replies are no longer allowed.