Hi,
I'd like to ask people more advanced than me to see if there is a way to do this.
I have 2 tables: a Contact one and an Articles one.
Each one has a multiselect field that hold the same data: Contacts select their interest (i.e. Sport, Tourism, etc) and Articles are tagged based on their topic (Sport, Tourism, etc).
What I would like is to find the Articles for each Contact: a match would be considered if at least one of the Contact's interest matches at least one of the Article topics.
I found a way to do this via code in a script, but scripts have limitations and I have around 5k contacts and around 10-20 articles to search for. Ideally I would like to do this with formulas or linked records or something in the UI.
Otherwise I'll just resort to Make.com.
Let me know if you have any suggestions or ideas!
Thanks,
Stefano