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

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!

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

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

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

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

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.

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

1 Like