How to create an automatic relation based on a number of different criteria

You would need to combine multiple lists in one.
There was a topic for that sometime ago. At the end there is an instruction from @Matt_Blais on how to make it work.
TLDR:
Two of your lists would be automatically linked based on from/to. You can hide those lists from UI as they are only used in automation.
Automations would sync those two lists into one by adding and removing links when lists are updated.

Having union function would be way nicer though /cc @Chr1sG

1 Like