Combine two SharePoint columns into one InfoPath ComboBox - InfoPath Dev
in

InfoPath Dev

Combine two SharePoint columns into one InfoPath ComboBox

Last post 07-02-2008 02:05 PM by altja. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 07-02-2008 02:05 PM

    • altja
    • Not Ranked
      Male
    • Joined on 07-02-2008
    • Grand Rapids, MI
    • Posts 10

    Combine two SharePoint columns into one InfoPath ComboBox

    Question 1) I can get it to concat with my dash, but I cannot get the right values to display in the second part.   The second part always displays the first entry from the sharepoint list.

     I tried to create my second part val2 <xsl:variable name="val2" select="my:itemAccount"/><xsl:if test="not(xdXDocument:GetDOM(&quot;Chart of Accounts&quot;)/dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Shortt_text[../@VisiblePaymentRequest = &quot;1&quot;][.=$val2] or $val2='')"> and then using that in the concat, but that did not work.

     Qustion 2) Where is dot being set at?  I assume it reprsents the slected val.

     

    Many thanks to any answers to my questions. 

    Sincerly, 

    Joe

     

    My actual xlt code. 

    </
    div>Account:<select class="xdComboBox xdBehavior_Select" title="" style="WIDTH: 100%" size="1" xd:CtrlId="CTRL443" xd:xctname="dropdown" xd:binding="my:itemAccount" value="" xd:boundProp="value" tabIndex="0">

    <xsl:attribute name="value">

    <xsl:value-of select="my:itemAccount"/>

    </xsl:attribute>

    <xsl:choose>

    <xsl:when test="function-available('xdXDocument:GetDOM')">

    <option/>

    <xsl:variable name="val" select="my:itemAccount"/>

    <xsl:if test="not(xdXDocument:GetDOM(&quot;Chart of Accounts&quot;)/dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Account_number[../@VisiblePaymentRequest = &quot;1&quot;][.=$val] or $val='')">

    <option selected="selected">

    <xsl:attribute name="value">

    <xsl:value-of select="$val"/>

    </xsl:attribute>

    <xsl:value-of select="$val"/>

    </option>

    </xsl:if>

    <xsl:for-each select="xdXDocument:GetDOM(&quot;Chart of Accounts&quot;)/dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Account_number[../@VisiblePaymentRequest = &quot;1&quot;]">

    <option>

    <xsl:attribute name="value">

    <xsl:value-of select="concat(.,' - ', /dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Short_text)"/>

    </xsl:attribute>

    <xsl:if test="$val=.">

    <xsl:attribute name="selected">selected</xsl:attribute>

    </xsl:if>

    <xsl:value-of select="concat(.,' - ', /dfs:myFields/dfs:dataFields/dfs:Chart_of_Accounts/@Short_text)"/>

    </option>

    </xsl:for-each>

    </xsl:when>

    <xsl:otherwise>

    <option>

    <xsl:value-of select="my:itemAccount"/>

    </option>

    </xsl:otherwise>

Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.