Printing with custom XSLT file
Users can create their own custom print layout using XSLT file.
The xml file that we use to extract the data from the form is the one below:
The control c_Feedback is a DataEntryGrid control and the extra elements 'Values' and…
SQL Queries in PowerForms
Applies to PowerForms Advanced
Since version 2.6, PowerForms supports direct SQL Queries that can be used to provide lookup data for lookup controls (such ComboBoxes).
For security reasons, the actual sql query is not defined inside PowerForms…
External Lists using Power Forms
Since version 2.4, support for External Lists/External Content Types is available using PowerForms (SharePoint 2010 only).
Assuming you have already created your external list, to setup that list to use PowerForms, you should follow the steps…
Script Examples
The above system columns do not create bound controls during form initialization.
You can get the values though through script and set these values inside your custom controls through script :
You should add the following script in the…
Script Example : Setting the datasource of controls through script
In order to have filtered dropdowns, the most common approach is to use the Constraint feature of PowerForms which enables automatic filtering of a dropdown control (see this link for details)
There are cases though when you want to manually…
Script Example : Calculate average value for a query resultset
For this example, we want to dynamically load data from a SharePoint list, loop through the resultset and calculate the average value of a specific column in the resultset:
To build our script, we assume the following :
- We have a list…