Create a "partial match" relation

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?


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.


This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.