Display row markers in tables not just the data grid

[Carl_Johnson]

I have a table that ranks teams based on their score. I would like to display the row marker value in the table view like the data grid currently does.

example where rank is dynamically generated in the table view like the data grid

rank team score
1 red 500
2 blue 480
3. green 100

Any ideas?

[Jeff_Hager]

I would use use case number 2 in the following post, but use a sorted query instead of a relation.

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

[Darren_Murphy]

Do you need to account for ties?

[Carl_Johnson]

i don’t need to populate auto-incremented rows numbers in columns. I only want to display ranking when the table is sorted - just like the data grid currently does. But I want to use a table to avoid enabling data entry.

if entry 3 is now the top score it will be listed in the first row of the collection viewer.

and YES - I do need to account for ties.

[ThinhDinh]

I used JavaScript for a use case like this recently.

function getRank(clicksJoined, clicksCount) {
    // Split the joined clicks string into an array of numbers
    const clicksArray = clicksJoined.split(', ').map(Number);

    // Sort the clicks array in descending order
    clicksArray.sort((a, b) => b - a);

    // Initialize rank and previous click count
    let rank = 1;
    let previousCount = clicksArray[0];

    // Iterate through the sorted clicks array to determine the rank
    for (let i = 1; i < clicksArray.length; i++) {
        if (clicksArray[i] < previousCount) {
            rank = i + 1;
            previousCount = clicksArray[i];
        }
        if (clicksArray[i] === clicksCount) {
            return rank;
        }
    }

    // If the clicksCount is the highest, return 1
    if (clicksCount === clicksArray[0]) {
        return 1;
    }

    // If the clicksCount is not found in the array, return -1 (indicating not ranked)
    return -1;
}

return getRank(p1, p2)

p1: Comma-delimited list of all “scores”
p2: Current row’s score

Gets something like this.

[Darren_Murphy]

@Carl_Johnson

I only want to display ranking when the table is sorted

Do you mean by clicking the table column headers? I don’t believe that is possible.

@ThinhDinh

I used JavaScript for a use case like this recently.

That’s cheating
I used 8 computed columns, haha

[Carl_Johnson]

looks like this is just what i need. thanks.

foirst time embedded js in a glide app for me. is this post the one to use?

Web Embed Component

Create a text column and place your code in that column cell, OR create a template column and put that code in as the template value. The goal is to get your code into one or many cells within your table. Then create a javascript column and put in the code that I included in my previous post. Set the replacement value for p1 to point to the column that contains YOUR code. That should be it. Point the web embed component to that javascript column and hopefully it should work. In theory, it …

[ThinhDinh]

If you use my JS, it’s in the JavaScript column in the data view to calculate the rank, and not something you embed.