Perhaps an unusual use case here!

I've been using Airtable for nearly a decade now, but for ONLY ONE, fairly straightforward purpose. I haven't needed to use any of the more advanced and interesting features before now.

I noticed a sample Table called "Novel Planning Template" and it REALLY got me thinking as I'm in the planning stages for a serious novel attempt!

I've been setting up a bunch of tables and so on, and even considering doing a large amount of the actual drafting inside Airtable.

What I was wondering is:

Is it possible to set up some kind of automation to pick up on things like character names (and nicknames) as I write scenes, and automatically link the "scene" record to those character records?

The character records would already exist, and I expect that I'd need to have a field somewhere for alternative versions (keywords) of the character's name(s).

Scenes would be their own records, with a long rich-text field, and a variety of linked record fields like characters, locations, important objects, and so on.

Some of those fields will always need to be manually linked - for instance when an important object is present but not mentioned in the scene text.

But it would be wonderful to take SOME of that manual work done for me!

[Free user]

[Website & app]

[not a fan of AI, but for something as small and "mechanical" as this, I'm willing to give it a chance]