set dropdown filter in PSC lookup to dynamic value from reference column

Copper Contributor

I have the following problem:

From list “A” I want to look up information in list “B” using a column of type “PSC Lookup”. This column is named “variants”.

 

I managed to have a drop down list opening in column “variants” showing the preselected columns from list “B” which I have defined in dialogue “Search fields definition (dropdown columns):”

One column in list “B” is named “tool” and I want to set the filter option to filter the dropdown for a specific tool number. I can do so using the dialogue input line “Conditions for search query (dropdown filter):” and enter e.g. “tool eq ‘123’” This works fine!

 

But how do I set this filter to use a dynamic value from list “A” which is found in a column (Type=text) called “reference”? I tried “tool eq reference”. But this leads to an error message saying “Column reference does not exist”.

So what would be the correct setting for having a filter set to the individual entry of a value in column “reference”?

 

Thanks for your advices

0 Replies