Re: Make a ranking out of scores

jonathan_pineda · ‎Nov 28, 2019

1 Table, 3 columns:│Player 1 │Points │Ranking │

Have a basic table where I need to make the logic for who is winning the match based on number of points.

Next step would be to sort them in kanban view From winner to loser. (it must auto update positions based on the entered points/scores.)

But… let’s do one stepe at the time

Regards !

Justin_Barrett · ‎Nov 28, 2019

I love me a good challenge, but I don’t think this is possible. The best I can do is find the first place and last place values by connecting all records to a single record in another table, and using rollups in that table with MIN and MAX aggregation functions. Because Airtable’s array functions are currently so limited, there isn’t a way to do anything with the other values to determine their order.

This is definitely not possible (at least not with native Airtable tools). Kanban views work based on the contents of a single select field, and those fields can’t be set via formulas. You could make this work using integration with something like Zapier or Integromat, but the cost to make this update in real time would be prohibitive.

The best way to do this would be to build custom API code that reads the data, determines the ranking order, and updates a single select field appropriately.

jonathan_pineda · ‎Nov 28, 2019

I agree with you. The best I could do was to find the highest score and the lowest by prevoiously doing exactly what you mentioned here. (I am very proud of myself lol)

If there were only 3 players it would be the perfect approach.

After reading your comment I think it is time to let it go, (its been almost 6 hours trying to figure this out)

thanx God there is no way of doing it natively, otherwise long nights would be awaiting for me.

Cheers.