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 below : REGISTER PowerForms The PowerForms registration buttons should be available in the list ribbon, so register PowerForms for […]
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 “Load Completed” script of the form : Designer > Options > Scripting > Load Completed Code […]
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 apply the datasource of a control using business rules. For example a set of COUNTRY and STATE combos. The State combo needs to […]
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 of “Cases” that have a Rate field (number) and a Customer lookup – We have […]
There are cases when the complexity of your business cases require that you need to take over and save list items manually. Besides controlling how data are saved through a normal PowerForms designed form, or by using the ListAndForm control to save “related” items to connected lists, saving through script is now available (v.2.4) The […]
The Default Value property is used to set the value of the control for new records. The default value can be either static or calculated. For static values, just enter the required value in the default value field. For labels and textboxes just enter the required text. For lookups, enter the ID of the […]
By setting a field to be calculated, you have to define the calculation formula for the field values. Moreover, you can use formulas in the “Visibility formula” and “Enabled formula” properties. Whereas in the Calculation formula should return the actual value that must be applied to the control, the Visibility and Enabled formulas should return […]
There are cases when the data source of a choice control depends on the value of another control on the form. For example: You have a multi-choice field with the associated company departments for a support request, called c_Department. You want the user to select the primary department and store it in another field. You […]
Python scripting is a powerful tool for your customizations. You can find here some common scripts you can use in your forms. IMPORTANT: Python uses “Significant Whitespace”, meaning that whitespaces in front of commands are important for the interpreter to identify code blocks. You can apply scripting to either Control Value Change events, or to handle the Form […]
Body