Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 10, 2020 06:01 AM
I have a table that contains my users, and their current balance of chips in a casino. I’m building a leaderboard that will tell them who the top five chip holders are. (This is the easy part.)
I also want to tell them what place THEY are in, if they’re not in the top five. This requires one of two solutions:
Do any of you amazing people have some guidance or advice? Thanks!
Sep 10, 2020 07:14 AM
How are you accessing the data? A human looking at the native Airtable interface on a computer? Via the Standard REST API?
Airtable is not designed for calculations across records in the same table, which is what you are requesting. Formulas fields can only perform calculations within a record. Lookups and rollups only work across linked records.
You could use Airtable’s new automations to do the calculations for option 2. However, depending on the number of users and how quickly their balances change, you might run into automation limits on the number of updates, processing time, runs, etc.