Highlight each first unique item in table

feefeed · 2024-12-03T13:44:07.586Z

Hi there,

I’ve had solved this before, but completely lost my train of thought:

I have a table, with a lot of data and cannot “Group by” for particulair reasons:
Looks like this:

Chairs - Eames - $50
Chairs - Vitra - $70
Chairs - Herman Miller - $80

Tables - B&B italia - $900
Tables - HENK - $600
Tables - Table de Sud - $900

Etc.

Now i want to highlight the first of every entry:.

Got something like: "curren’t row’ item = table of items; unique element; each first item. but that highlights only all chairs.

Anyway.
Please help

oliviercoolen · 2024-12-03T13:59:22.589Z

@feefeed if your data is sorted by name, then you can reference the previous cell to figure out if the name is the same.

To do so, add a new 1x1 px group in your cell. The data source of this group will be RepeatingGroup X item# current cell’s index - 1. Let’s call this group “PrevCell”.

Then you can add a conditional to highlight the first entry.

If PrevCell Name != Current Cell name, then Highlight this text.

feefeed · 2024-12-03T14:40:13.534Z

Wow legend! thanks for pointing me in that direction of logic, but also exactly the solution!

Can you add a solution to add a header-title for each of these categories on that same condition SO:

CHAIRS

Chairs - Eames - $50
Chairs - Vitra - $70
Chairs - Herman Miller - $80

TABLES

Tables - B&B italia - $900
Tables - HENK - $600
Tables - Table de Sud - $900

all in one table.

Cheers!

oliviercoolen · 2024-12-03T15:55:29.763Z

No worries, happy to help!

And ofc. You already have all logic in place.

The only thing you’ll have to do is add a text element in your cell, give it the following dynamic expression: PrevCell's Name and add a conditional to only show that text element, when again, PrevCell Name != Current Cell name

system · 2025-02-11T13:45:05.172Z

This topic was automatically closed after 70 days. New replies are no longer allowed.