Any ideas how to fix this very undesirable separato behavior?

Hey, all not sure if this is the expected result, but I am not digging the way that the separato behaves when an RG breaks to a new row, and the final row does not contain enough results to fill the row. Am I missing something with the separato controls?

I understand why the vertical separatos are not there, but the missing horizontals creates a disjuncture between what’s on the screen, and what’s in the data: 3 items in one irregularly shaped cell. This RG shows “Satori” “Shorty’s” and “Vans” with no separation between their respective cells, and also no separation from the empty cells that finish out the row.

Anyone have any ideas how to make the horizontal separato continue to the edge of the group and maintain the

If you will always horizontally show five items/cells:

Add four blank items to your database under the brand data type and give a field of theirs, like slug, the value of “empty”.

Do when RG List of Things:count modulo 5 is 1
Data Source: “Input original data source here” plus item: Do a search for brand where slug = “empty” :first item

Do when RG List of Things:count modulo 5 is 2
Data Source: “Input original data source here” MERGE WITH Do a search for brand where slug = “empty” :items until #2

Do when RG List of Things:count modulo 5 is 3
Data Source: “Input original data source here” MERGE WITH Do a search for brand where slug = “empty” :items until #3

Do when RG List of Things:count modulo 5 is 4
Data Source: “Input original data source here” MERGE WITH Do a search for brand where slug = “empty”

Then on the cell of the repeating group you can just add to any display text element a conditional where if current cell’s brand’s slug = “empty” This element is not visible. Don’t add that conditional to the cell itself though or it will defeat the purpose.

1 Like

Thanks so much for this very thorough response Will!

I am still not proficient with Modulo, and it’s something I have to make some time to understand. I am looking forward to giving this a try once I get a better understanding.

@zach8
In easiest terms modulo is when 2 numbers have a leftover (modulo) of X
In our example below X is 0

A/B = X

Always round result down if it’s not a whole number

Let’s say default background is white

So for example current cell index modulo 2 IS 0
Change background to grey

Cell 1/2 leftover 1 = white
Cell 2/2 leftover 0 = grey
Cell 3/2 leftover 1 = white
Cell 4/2 leftover 0 = grey
Cell 5/2 leftover 1 = white

Example of leftover
5 modulo 2

How many times does 2 go into 5 fully without overlap?

2 times

How many is leftover between the number of times it goes in an value A (5)

2*2 = 4
5-4= 1

Is it 0 like our conditional looked for? No. Leave white background.

Bigger number example, same modulo statement
current cell index modulo 2 IS 0
Turn background grey

Current cell is 425
How many WHOLE times does value B (2) go into value A (425)

425/2 = 212.5 (round down) = 212
412*2 = 424
425-424= 1

So the modulo of 425 and 2 is 1

The background will remain white because the condition of it being 0 to turn grey didn’t pass.

2 Likes

Hi Chris, I already understand that modulo = remainder.

My bad man, that’s for anyone else searching then :rofl: