Create a "partial match" relation

[MattLB]

Has anyone figured out a technique for multiple matching when a partial match occurs in a relation.

For example I want to match all records where Name contains “Disney” versus accounts that are exactly “Disney”

Is this something that AirTable or another DB/tool would be better at?

TIA

[Darren_Murphy]

Relations need exact matches, but you can trick them

For your use case you could add an if-then-else column:

• if name includes Disney, then true

Then add a template column that contains the word true, and build your relation between those two columns.