How do I make the “Connected in any way” column automatically use any circle that is in any way connected to some other circle.
If ’s child () has a parent (), then and are connected.
Another example, if circle’s child has a parent whose parent has a child, and that child has a child, and a child of that child’s child is then connect to the initial circle. Those two circles on the far ends and any other circles in-between are connected.
Requested edit access to the doc. This looks similar to the task I was solving here:
I had a table of items with child items (or actually the other way around, items and their parent items, because each item could have many children but only one parent) and I wanted to prevent circular dependencies. For that I had to know which items were already some descendants of the current item so that I could filter them out of the selection list.
I’m compensated in various ways, namely being a Community Champion I enjoy the benefits of it: a free Team workspace and a direct line to Codans from whom I can learn how the internal stuff works (if I cannot reverse-engineer it myself, lol). Also I’ve been Maker Funded for the courses and getting a lot of support for my initiatives otherwise. So I wouldn’t complain