List Queries
The {url} Keyword
The {url} Keyword The {url} is a brand new keyword which can be used in the designer to indicate the local web-site url, instead of having to write the whole SharePoint site/sub-site path. Important Note: The {url} keyword can be used to substitute ...
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 red ...
Master-Detail using the ListAndForm control
This is a step-by-step guide of building a mster-detail form using the ListAndForm control. For this example. we will use 2 connected lists : Customers and Contacts. Customers list columns Title, Address Contacts list columns Title (renamed to Full ...
Master-Detail using the DataEntryGrid control
The DataEntryGrid control gives you two options. The first option is to add structured data that would be saved inside a multi-lines-of-text control (using XML). So it is ideal for cases that no external list is required to store the related data. ...
Complex List Query Examples
This article contains some more advanced examples on query building : You can read some basic instructions on how to build list query criteria HERE : For our examples, we will use a list of Cases having the following columns : Title (Single line of ...
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 the control ...