Forms Designer Forum

Hi,


I am trying to use a lookup field in the user-defined rule for a group of forms, but am unable to get it to work at the moment. Is there some special syntax for it? Or is the result it is looking for a combination of ID and title?


In this situation, the lookup field I am trying to use is called "Portfolio". Many thanks in advance.


Tjon

Hi,


You are correct, the value stored in the lookup field has a syntax of form "ID;#Value", where ID is the id of the given entry in the list and Value is the value displayed in the lookup field box. So, you can do your comparison like this:

[Portfolio] == '1;#A Portfolio Item'

Or you can use Contains or Match functions to match only ID or Value, see http://spform.com/documentation/groups/functions for details.


Regards,

Rostislav

Works thanks!