Create a "partial match" relation

Ask for Help
1

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

2

Relations need exact matches, but you can trick them :slightly_smiling_face:

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.