Hi everyone! I need your help with a problem I still haven't managed to solve on Airtable
I'm creating an online store where the cart is generated by answering a diagnostic/questionnaire.
Each answer to the questions assigns tags (words from the "single select" menu) to the people who answer.
Some tags may appear several times.
I want to create a program that allows me to count the number of times a tag appears in one cell and rank them from the one that appears the most to the one that appears the least.
Then I would like to be able to search, in the "product" table, those that correspond the most to the first 5 tags of the ranking.
Thus, I will give the best product to the people answering the questionnaire.
(If you also know how to use the TF-IDF (Term Frequency - Inverse Document Frequency) in my case, it would help me a lot)
I thank in advance the people who will want to help me with this original request 🙏