lookup field in Form field

rss

Posted by RMIC - May 11 ’15 at 06:48

When use a lookup field in "Form field" in Data Source Editor, no data is displayed. Is there already a solution?

Thanks smile

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 10 months 26 days
    #1 by Dmitry Kozlov May 11 ’15 at 08:59

    Thank you for the good question. Actually, you can configure filtering by a lookup field of the form but you need to do extra work here. First, configure filtering in the Data source dialog of the Related items control. Next, drop HTML-control onto your form and turn its CDATA property into False. Then insert the following code into its Content property:

    <xsl:variable name="LookupValue" select="substring-before(substring-after(@LookupColumn,'&gt;'),'&lt;')"/>
    <xsl:comment>
        <xsl:value-of select="ddwrt:GenFireConnection(concat('*', '@LookupColumn=', ddwrt:ConnEncode(string($LookupValue))), '')" />
    </xsl:comment>

    Please, replace the highlighted text (LookupColumn) with the internal name of the lookup field from the form.

  • RMIC
    Member
    Member for: 4 years 3 months 8 days
    #2 by RMIC May 29 ’15 at 04:31

    This worked, thanks a lot!

Displaying 1 to 2 of 2 messages