Solved: Combining contains() with a ref - Page 2

Olivia_Bryanne1 · 09-04-2019 05:19 AM

Hi there,

I’m struggling with an expression

I have a virtual column that generates a list from another table that is somehow associated with the original entry. It’s not a parent-child relationships but more like finding the other parent for a child entry and this virtual column generates a list of all other parents that this first parent is associated with through a shared child. I have this list

I then have a Y/n variable on the second parent table and I would like to create a y/n variable on the first parent table to say whether the first parent is associated through their children to any the “Y” type of second parents. Think of it as a table of men with children with multiple different women and we would like to know as a y/n if this is a man who has a child with a women who lives in London

Contains() seems to only work if it is on the same table, and wont let me use the virtual column of list of women as a ref to the right column on the mother table

thoughts?

Olivia

Steve

The expressions I gave were for use in your app, but #VALUE! is typically indicative of a spreadsheet problem. Can you provide a screenshot?

Whatever the case, your clarification is very helpful.

Instead of what I proposed above, try this as the app formula for a virtual column in the Fathers table:

ISNOTBLANK(
  SELECT(
    [Related Childs][_ROWNUMBER],
    [Mother].[Lives in London?]
  )
)

View solution in original post