Querying SharePoint Lists and displaying results
Users can execute queries to the Sharepoint Lists and show the result in a DataGrid control. To enter the List Query editor, first enter PowerForms designer mode and select LIST_QUERIES from the drop down menu. The selection menu is highlighted…
List Query Criteria
List Queries is a common method to load results from a SharePoint list.
List Queris can be specified using the LIST-QUERIES section of the runtime designer or when defining parameters for lookup controls (inside the Lookup Details tab or…
How file uploading works (for new and existing records)
Navigate to Attachments Tab.
A user can add attachments in two different ways, by browsing for files or by dragging and dropping files on the Existing Attachments area.
Browsing for Attachments:
Select
The…
Delete Error Web Parts from Edit/New page
First navigate to the page that has the problematic web part. Then at the end of the url add the url parameter Contents=1. This will open the page in 'Maintenance' mode.
Now all the web parts can be viewed, even those with errors.
Users…
Define List Queries
List Queries is a common method to load results from a SharePoint list (either in the same or any other site of the current site collection).
List Queries can be specified using the LIST-QUERIES section of the runtime designer.
Name
Provide…
Show or Hide a control based on form conditions
In order to hide/show controls on the form, we can either use the "Visibility Formula" which is inside the control properties window in the designer, or write some script to perform the same action.
Examples :
Condition based on the value…
Enable or Disable a control based on form conditions
One of the most common scenarios when designing a custom form, is the requirement to enable/disable a specific control (or set of controls) based on a) the values of other controls, b) the user using the form.
For our example, we have a list…
The Slider control
The Slider can be used instead of a numeric textbox. Moving the slider left or right increases or decreases the number. The Slider can store its data in a single line column or a numeric column.
Type : Slider
Name
Provides…
The RotatedText control
An example of a RotatedText control with Font Bold and an Angle of 45:
Type : RotatedText
Name
Provides a unique name for the control.
Binding
Indicates if the control is
Unbound
Bound to list column
Is a label for…
The RichTextBox control
A Rich Textbox control is generally used for displaying, entering and manipulating text with formatting. The RichTextBox control does everything a textbox control does, but it can also display fonts, colors, links, margins, load text and images…