Using a lookup in user defined rule

rss

Posted by tjon.kim - Sep 11 ’15 at 12:17

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

  • rostislav
    rostislav
    Moderator
    Member for: 6 years 6 months 24 days
    #1 by rostislav Sep 11 ’15 at 07:45

    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

  • tjon.kim
    Member
    Member for: 6 years 7 months 13 days
    #2 by tjon.kim Sep 13 ’15 at 07:06

    [#1]:

    Works thanks!

Displaying 1 to 2 of 2 messages