Related items - fliter by lookup
- Sebastian Haugland
- Posts: 43
- Joined: Fri Sep 19, 2014
- Contact:
In related items I dont get any value in the field "filter by lookup" , I have tried different lists and views. Any suggestions?
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
What version of Forms Designer do you use? You can find the version at the lower right corner of the Forms Designer dialog.
- Sebastian Haugland
- Posts: 43
- Joined: Fri Sep 19, 2014
- Contact:
ver 2.8.11
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
Please, install the latest version (2.9.1). You can download it from our website:
http://spform.com/download
The following article may help you to configure the related items:
http://spform.com/office-365/filt ... point-form
http://spform.com/download
The following article may help you to configure the related items:
http://spform.com/office-365/filt ... point-form
- Sebastian Haugland
- Posts: 43
- Joined: Fri Sep 19, 2014
- Contact:
Thanks! Now its working
- Sebastian Haugland
- Posts: 43
- Joined: Fri Sep 19, 2014
- Contact:
Hi The code above worked fine, in my task list I also have another lookup field called "Product" from a list called Product. The list has has a ID field and a Title field - the Title field (product name) is shon in the task form.
Any suggestion on how to change the html below to work for product? In related items I set filter Product in form and Title from the productlist.
HTML for "Assigned To"
<xsl:variable name="UserName" select="substring-after(substring-before(substring-after(@AssignedTo,'userdisp.aspx?ID='),'<'),'>')"/>
<xsl:comment>
<xsl:value-of select="ddwrt:GenFireConnection(concat('*', '@AssignedTo=', ddwrt:ConnEncode(string($UserName))), '')" />
</xsl:comment>
Any suggestion on how to change the html below to work for product? In related items I set filter Product in form and Title from the productlist.
HTML for "Assigned To"
<xsl:variable name="UserName" select="substring-after(substring-before(substring-after(@AssignedTo,'userdisp.aspx?ID='),'<'),'>')"/>
<xsl:comment>
<xsl:value-of select="ddwrt:GenFireConnection(concat('*', '@AssignedTo=', ddwrt:ConnEncode(string($UserName))), '')" />
</xsl:comment>
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
Do you want to display all tasks relating to the current product on the product form?
- Sebastian Haugland
- Posts: 43
- Joined: Fri Sep 19, 2014
- Contact:
Yes in the task form I would like to se all the tasks on the related product.
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
Hi,
First, you need to configure filtering by the lookup field 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:
Please, replace ''Lookup1' with the internal name of your lookup field (Product).
First, you need to configure filtering by the lookup field 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:
Code: Select all
<xsl:variable name="LookupField" select="substring-before(substring-after(@Lookup1,'>'),'<')"/>
<xsl:comment>
<xsl:value-of select="ddwrt:GenFireConnection(concat('*', '@Lookup1=', ddwrt:ConnEncode(string($LookupField))), '')" />
</xsl:comment>
-
- Information
-
Who is online
Users browsing this forum: No registered users and 5 guests