Originally Posted by Noughty
Just how to make a custom column from two columns which would extract only specific values?
Yes, it is possible. It isn't particularly easy.
One way to have the columns dynamically correct (reflect the values currently in the other two columns) is to use a composite column (a column built from other columns). These columns use the template language to construct the value. For example, the template
will construct a column from the values in the two custom columns #column1 and #column2. Unfortunately, that isn't what you want.
It is possible to extract values from columns. The problem is knowing what values to extract. If what you want to extract is a fixed set of values, then you probably can use something like:
list_intersection(field('#textmult'), 'val1, val2', ','),
list_intersection(field('#textmult'), 'val3, val4', ','),
If you don't have a set of fixed known values, then things get much more complicated. You would need some way to identify a value, and you would probably need a custom template function to prune the list to the correct set of values.