Quote:
|
The configuration field in the driver is a comma separated list of column lookup names. It does not allow templates. If you want to do something like that, you will need to create a column with that template, then use the column in the driver configuration.
|
Sorry, I thought I had made myself clear that I was making a column by stating that I could get one tag into the column, but not two, but I guess not. I'll try again. I figured out the issue though (extra comma that messed it up).
Correct:
Code:
{tag:contains(abc, ABC,)},{tag:contains(xyz,XYZ,)}
However, it still isn't doing quite what I want it to do...
I have the column set up as "Columns built from other columns, behaves like tags". I've tried it with just the "Columns built from other columns" but it didn't work there either.
The first part now has my read status (custom column) added in front, and the rest added after, and still works:
Code:
{#read_status} - {tag:contains(abc, ABC,)},{tag:contains(xyz,XYZ,)}
This gives me the result of: Read - ABC,XYZ or Unread: ABC,XYZ (if more than one tag meets the criteria).
What I want is the result of: Read - ABC or Read - XYZ or Unread - ABC or Unread - XYZ. I'm only looking for one tag value in the column, so if the first condition is met, it doesn't need the rest, or if the first criteria isn't met, but the second one is met, it doesn't need the rest & so on and so forth.
In my mind, it would look like this, but that doesn't work:
Code:
{#read_status} - {tag:contains(abc, ABC,tag:contains(xyz,XYZ,))}
Is this possible? And which column type would it require if so?
NOTE - I speak 'Excel', and it's a nested IF function I'm looking to duplicate here... maybe that will make my meaning clearer if you (or anyone else) knows what that is. The If-then-else "contains(val, pattern, text if match, text if not match)" option I'm currently using is as close as I've been able to find. The List Lookup "in_list(val, separator, pattern, found_val, ..., not_found_val)" sounds like it might be what I want, but I can't make it work for me.