Calling external web services and displaying data
Users can create external web service calls and display the data using a datagrid on the form.
NOTE: Other controls can also be connected with a web service call. In that case only the first attribute for the first record will be used and…
SQL Queries in PowerForms
PowerForms HTML 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 designer but another setup model…
SetSectionCellSpacing, SetSectionCellPadding methods for Sections
SetSectionCellSpacing, SetSectionCellPadding are two new methods which when used, will control the internal cell spacing and padding of a section on a form.
The generic way of calling both methods is:
Code
form.SetSectionCellSpacing("Section…
SetDataSource method for DataGrid
SetDataSource is a new method used to bind a DataGrid to an array of objects during runtime.
c_Control5 is our example datagrid.
Code
var c = form.GetControl("c_Control5").InputControl;
var data = [];
var item = new…
Using the SetCellColor method
SetCellColor is used to dynamically change the cell color of a control using scripting. To call the method:
Code
form.GetControl("ControlName").SetCellColor("ColorCode");
where ControlName is the name of the control…
Using the ParentListName method
A new method called ParentListName was added in the latest version of PowerForms HTML. This method can be called from a form used inside a ListAndForm control and will return the list name of the form containing the actual ListAndForm control.
In…
Enable, Disable, Select Tab on Form using scripting
You can now programmatically Enable, Disable and Select a tab on the form. The generic syntax is:
Code
form.EnableTab(integer);
form.DisableTab(integer);
form.SelectTab(integer);
where interger represents…
Handling the BusyChanged event for controls
Each control exposes a "BusyChanged" event which is raised when the controls starts loading data (for example for comboboxes, radiobuttons, checkboxes) and when loading completes.
The event provides a boolean parameter indicating if the loading…
Handling the AttachmentsLoaded event
The "form" object available from script, exposes a specific event that is raised after the item attachments are loaded.
The event is called "AttachmentsLoaded" and provide a list of the available item attachments. For each attachment, the…
Include custom javascript in the form
Sometimes we need to have a common function that must be called from several controls. For this purpose there is a new category in the scripts section called 'Includes'. In this section you can write either javascripts that will be added in…