Aug 01, 2021 07:50 AM
I have a look up field that contains a list of companies’ names. I want to get the most mentioned company in that list.
I have three tables:
Tenders table has a linked record from both entities and companies.
From the entities table I created a look up table that retrieves the companies column. I’d like to get the name of the company that was mentioned the most.
The idea is to answer the following question: Which company gets the most tenders of each entity?
Aug 01, 2021 08:03 AM
I would just do it from the companies table. Create a field of type “count”, and then sort or group by that field.
Aug 01, 2021 08:42 AM
Thanks for the reply but this isn’t the right approach.
The approach that I think would work but do know how to do it on Airtable is:
List the companies on a field > count the occurence of each company (still a list) > get the name of the company with the highest number.
Aug 08, 2021 12:11 AM
Unfortunately that’s not possible in a formula field. It can be done via a script, though. Depending on how frequently you want to update this bit of data, you could perhaps use a scheduled automation to run the script.