Hi all,
In my database I have user inputted fields (numbers) and I am trying to display the lowest unique number.
For example when I display the text of all the values in the list I have the following:
1.1, 1.1, 1.12, 1.25
What I am trying to get would be 1.12 in this case (as it is the lowest value that does not have a duplicate (it’s count = 1, where the count of “1.1” = 2)
Please help!
How about:
However, there’s a complication. If a new number is input that equals the lowest unique number, then you would need to find the next higher unique number, which would be the new lowest unique number. To do this, you could run a recursive backend workflow to cycle through the list of numbers, sorted from low to high, to find the next lowest unique number.
This feels convoluted however, and someone may have a more elegant solution. Also I’m sure someone who knows some code would know how to write a plugin to do the calculation.
First of all thank you very much!!! Given the urgency on the matter, I’ll give it a shot- this makes sense. will keep you posted!
Hi there, @rudycelekli… I probably wouldn’t call this suggestion elegant, but if I understand your post correctly, the expression I am about to suggest does seem to produce the desired result.
In my example, I have a field called num on the User data type. Here is the expression in a text element that gets the lowest num value across all users that is not a duplicate value.
There are no constraints on the search for users on the right, and here is the constraint on the search for users on the left.
Again, this suggestion might not be the best way to go (who knows, it might actually be the worst), but it does seem to work, so I didn’t think it could hurt to throw it out there as food for thought.
Best…
Mike
