Trigger to select values in two fields

Tue, 27 Jan 2015 12:02:26 GMT

Hello,

I have a field that is comprised of two other fields, i.e. Field1/Field2.

I would like for when a value in 'Field1/Field2' is selected, the filters for these individual fields, '%Field1' and '%Field2' are selected.

I can achieve this for one field, using the following

Trigger on [Field1/Field2]

Field = %Field1

Search String = if(count(distinct %Field1) = 1, %Field1)

This works well. I'd like to expand this to include the same logic to select %Field2 if one value is available. Thoughts on how to achieve this?

Thank you

Mel

Re: Trigger to select values in two fields

Tue, 27 Jan 2015 12:14:01 GMT

Hi Mel,

you can have multiple triggers on the initial field, so you just need to add the same for the second field

Joe