I’d like to find a way to construct a column that scans the Title column and updates a column in the same record with multiple select options.
To further explain, I’m building a database that has newspaper/press headlines (integrated via RSS feed and zapier). Each record has a “title” that has the heading of the article. I’d like to find a way to automatically update a column in the same record with multiple select options based on what text is in the name column.
For example (within the same record) if the “Title” column of a record says “Three birds were seen flying from the eagle’s nest on Tuesday and are now migrating north to Montreal.” - the tagged fields column would read this and output (birds)(migration)(Canada).
Is this possible on airtable? Where would I start?