⚡ Rich Text > Actions!

[ThinhDinh]

I have a rollup to count the number of items in the inline lists to deal with that

[Joe_Gabriele]

Genius!

[Robert_Petitto]

Great idea, @ThinhDinh

[V88]

Do you have a way of only showing the first X items in a list? I could never do that without using RANK in the Google Sheet.

[ThinhDinh]

I have tried ranking using computed columns in the past but never succeeded. Wish there’s a rank option for rollups.

[Robert_Petitto]

@ThinhDinh

Wish there’s a rank option for rollups.

Rollup...by rank?

Is there anyway to get the sort order of a list based on value to the maximum? With rollup, I can get the max, avg and min, but I’d love to get the RANK of a list based on these values. Sure, I can sort by the value in an inline list, but i wanted to retrieve the ordinal number of each row in this sorted list. I could always use a spreadsheet formula, but was hoping to avoid it.

@Mark @Jason

[Darren_Murphy]

@V88

Do you have a way of only showing the first X items in a list? I could never do that without using RANK in the Google Sheet.

Do you mean the first X items in an ordered list? ie. something like the Top 5 from a Leaderboard?

[V88]

Yup. That’s certainly one example.

[Uzo]

add row number =ROW() column to the sheet, and than filter items where row is less than x+2

[Darren_Murphy]

okay, that’s an interesting challenge. Maybe I’ll have a play around with it later. If I come up with anything will let you know.

Edit: Just noticed @Uzo 's suggestion, which would probably get you there. But a Glide-only solution would still be nice, I expect?

[V88]

Thanks @Uzo but I can do it in GS using RANK which is perfect, but I’d like to achieve it with Glide columns if possible

[Joe_Gabriele]

Would you know how to maybe do a Title on the Left and the See all in line on the right? Sort of how to make it look like the current “See All”?

[ThinhDinh]

Here you go.

However please keep in mind that the action will apply even if you click in the Title.

<div class="same-line-test">
<div class="title">Title</div>
<class="see-all">→ See all</class></div>
<pre><span><style>
.same-line-test {
display: flex;
-webkit-box-pack: justify;
justify-content: space-between;
}
.same-line-test .title {
position: relative;
float: left;
font-weight: 700;
font-size: 1rem;
line-height: 1.1875rem;
color: #006400;
}

[Joe_Gabriele]

@ThinhDinh

<div class="same-line-test">
<div class="title">Title</div>
<class="see-all">→ See all</class></div>
<pre><span><style>
.same-line-test {
display: flex;
-webkit-box-pack: justify;
justify-content: space-between;
}
.same-line-test .title {
position: relative;
float: left;
font-weight: 700;
font-size: 1rem;
line-height: 1.1875rem;
color: #006400;
}
.same-line-test .see-all {
position: relative;
float: right;
font-weight: 600;
font-size: 0.875rem;
line-height: 1.0625rem;
color: rgb(236, 169, 176);
}

Perfect, Thank you!!

[ThinhDinh]

Edited the styling for see-all out as I realized I wasn’t able to target that class.

[Uzo]

i don’t think there is any pure Glide solution for this… I would suggest that from the beginning, you should have row number starting 1 , and any add row or form action you should add +1 from previous row, in set columns. this way data will be better organized and accessible. Thats what i do with all my sheets and it helps me with all kind of purposes (searching, relating, ranking, filtering…) Anyway, it would be a great help if Glide will give us a ROW() function, or simply have numbers next to ROW ID column.

[BlakeWS]

@ThinhDinh

I have some apps with the need for having multiple inline lists sourcing from the same table, which obviously will show different sides of the same dataset.

I’m going through this right now. The issue I’m having is that I want inline lists drawing from the same table on multiple tabs, but with independent components drawing from different columns. But each time I put an inline list on a new tab, which draws from the same table as the other, the same components get pulled over as though each list is the supposed to be the exact same list. Are you doing something different? I tried different visibility options, but it gets messy.

[Darren_Murphy]

Are you referring to the Title/Details/Captions for the Inline List component?

I have a method for having different values for each when viewing different inline lists of the same data.
It involves setting a user specific column in my user profiles table, and then using an if-then-else column to set my list title/details/caption (and sometimes image) depending on the value of that column.

It’s ugly, but it works. I’d be completely open to a simpler approach.

[BlakeWS]

No, but I’ll keep that method in mind.

I have users and an admin using the same app. Within the app, to save on tables and rows, I went horizontal with extra columns instead (1000+). It still works pretty good with the inline lists. The next step is I thought that I would create separate tabs for the users and the admin, with row owners & a visibility control, and that works fine too. However, when I create an inline list on a tab for one set of columns, all of the components that I’ve applied to that table will be shown on all tabs with an inline list. It’s like I need the “independent screen configuration”, but per inline list. I started adding visibility controls for the components, but I’m not very happy about all the extra work.

[Robert_Petitto]

@BlakeWS

I started adding visibility controls for the components, but I’m not very happy about all the extra work.

This is what I was going to suggest. No great solution otherwise…unless one inline list is set to “show details” and the other is set to “show new screen”…not a great solution, but it might get you there.