I’m quite new to Airtable and have been reading everything I can find (the oficial videos, the reference guide, several blog posts etc). But still can’t seem to get my head around this. Any help would be much appreciated.
This is my simplified current setup:
Table 1 - Events
Field 1: EVENT NAME [text]
Field 2: CATEGORY [single select dropdown]
Table 2 - Category Rules
Field 1: SEARCH STRING [text]
Filed 2: CATEGORY
I’m importing data from another source into Table 1 and want to be able to auto categorize the Events.
So basically, if the value of EVENT NAME matches the SEARCH STRING on Table 2, the category field would be auto-selected with the correct category.
Is this possible with Airtable?
It would be super helpful if anyone could point me in the right direction. I really have no idea how to tackle this.