Identify highest number from order number to change the color of an icon

[luminrabbit]

Hi Bubblers,

I have an “Order Number” in the database and need some help on how to figure out when its the highest number to turn a checkbox icon green when I get to the last item.

The repeating group shows 1 item at time and Im using a button workflow to Show Next.

Here Im turning an icon green when Order Number is 2 because I know it’s the last or highest number but if more questions are added 2 would not be the highest number anymore and that’s what I need help with (logic to know what the highest number is, which would be the last question).

Any suggestions would be greatly appreciated!

[adamhholmes]

Identify the highest number, using :each item's Order Number: max

Then compare the current cell’s thing’s order number to that

[luminrabbit]

Thank you very much for pointing me in the right direction!

[adamhholmes]

You’re using :count there… I though you wanted the highest order number?

[luminrabbit]

Hi @adamhholmes ,

I did want the highest number (which would be the last question) and both seem to work the same to change the checkbox color.

[adamhholmes]

Well they’re two completely different things, obviously… so as long as you know which one you need…