Using a lookup in user defined rule
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
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
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
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
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
-
- Information
-
Who is online
Users browsing this forum: No registered users and 17 guests