Hi all!
I publish lots of blog posts about a variety of topics and I have huge comma-separated lists of keywords for each blog post that get fed into a search mechanism for readers to be able to find content that resonates with them.
I’m wondering if there’s a way to track all those keywords so that I can see, for example, how many blog posts share the keyword of “tree”? I definitely don’t want to have to select from a multi-list each time I’m entering 50 keywords per blog post, so if I have to just paste the list into a field each time, that’s fine, but it would be nice to be able to have them pointing to a complete list where I can then see how many blog posts we have per each keyword.
Thanks in advance!
To do that, you would need to create a linked record field in your main table.
This linked record field would be linked to a brand new table called “Keyword Tags”.
In that new table, you would be able to use count fields or rollup fields to get statistics on those tags.
From your main table, you can even copy and paste groups of keyword tags from one record to another (i.e. from one blog post to another).
You can learn more about linked records in Airtable’s support article here.
Also, for a complete deep dive into linked record fields, you can check out my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning.
The course is very outdated because it was created many years ago, but the core concepts of linked record fields still remain the same to this day.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Hey
For creating all records mentioned by Scott in the new table, you might want to create a script that will get the Tags value out of every single Blog record, do some sort of Arrayunique, split for commas, and iterate through the items to get one record per tag!
Let me know if you need any help with this.
Ideally you would replace your comma separated system for tags with multiple select of linked records -I don’t see how effort would be way bigger if you are already typing the full list I guess? I might be getting this wrong!
Otherwise, you can keep your long text field for comma separated tags and have an automation doing the iteration of tags and linking on a different field as soon as you create new records on Blogs table where Tags field is not empty (or similar trigger).
Hope this brainstorming helps!
Feel free to reach out if you need any help. I’d be happy to go through it together on a call.
Mike, Consultant @ Automatic Nation
Also, building upon
If you already have comma-separated values in a text field in Airtable, you can just convert the field to a linked record field, and Airtable will automatically create all the linked records for you in the other table!
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.