Blog Elements

Half Sized Blog Element (Single Author Style)

Half Sized Blog Element (Multi Author Style)

Controls, Knowledge Base, PowerForms Siverlight

The TextBox control

The TextBox control is commonly used to display column data of single-line-of-text or multi-line (Plain Text) columns. If the TextBox control type is selected inside the control properties window, the “MultiLine” property is available allowing users to display multiple lines of text column data (the control automatically displays a vertical scrollbar and accepts the Enter […]

August 13, 2017/by Konstantinos

Controls, Knowledge Base, PowerForms Siverlight

Define Extra Control Parameters

Common control properties for each form control are defined inside the designer pages like Color, Size, Alignment, etc. Most of the available controls, support special configuration settings that can be accessed through the “Extra Configuration Tab” in the control properties window. The designer provides easier control configuration through an easy user interface. Available configuration values in […]

August 13, 2017/by Konstantinos

Controls, Knowledge Base, PowerForms Siverlight

The TextBox control

August 13, 2017/by Konstantinos

Controls, Knowledge Base, PowerForms Siverlight

Define Extra Control Parameters

August 13, 2017/by Konstantinos

Full Sized Blog Element (Big Preview Pic)

Controls, Knowledge Base, PowerForms Siverlight

The TextBox control

The TextBox control is commonly used to display column data of single-line-of-text or multi-line (Plain Text) columns.
If the TextBox control type is selected inside the control properties window, the “MultiLine” property is available allowing users to display multiple lines of text column data (the control automatically displays a vertical scrollbar and accepts the Enter key during data input)

Any of the available options can be used.
Specifically for the List Query and the Web Service value binding options, the first of the attributes/fields retrieved from either the ListQuery or the WebService is used to provide control data.

More details can be found HERE.

The TextBox does not provide any Lookup options since it cannot contain lookup data.

ValueChangeMode

Values : TextChange (default) or LostFocus
This option defines if the ValueChanged event will be raised at TextChange or LostFocus

Align

Values : Left (default), Right, Center
Indicates the text alignment of the text inside the TextBox control

EnterRaisesValueChange

Values : Yes, No (default)
This option defines if the ‘ENTER’ key will raise the ValueChange event.
It can be used to add filter controls for ListDataGrids or WebServiceDataGrids.
For example,

We have an unbound TextBox on the form named c_Filter.
We add a ListDataGrid on the form and we bind the value of the ListDataGrid to a ListQuery.
In the ListQuery properties, we setup the criteria as follows :

Title Contains {c_Filter} , IgnoreBlank = Yes

Inside the properties of our filter TextBox, we set the ValueChangeMode to LostFocus and the EnterRaisesValueChange to Yes.

This will have the following effect :

The list query will be executed during form initialization and retrieve the results.

Typing in the filter TextBox and pressing the ENTER key or loosing focus, wil force the ListQuery to execute the query again taking into account the filter text and retrieve the relevant records from the corresponding list.

August 13, 2017/by Konstantinos

Controls, Knowledge Base, PowerForms Siverlight

Define Extra Control Parameters

Common control properties for each form control are defined inside the designer pages like Color, Size, Alignment, etc.

Most of the available controls, support special configuration settings that can be accessed through the “Extra Configuration Tab” in the control properties window.

The designer provides easier control configuration through an easy user interface.

Available configuration values in standard controls :

PrefixLength
The number of characters you need to input until AutocompleteTextBox shows the filtered items. A zero(0) value means the texbox will display all available items in the dropdown part, as soon as the user clicks on it. A value of two(2) means the dropdown part will display the matching items, after the user inserts two characters in the textbox.

DropDownHeight
Defines the size of the drop down area, displaying the available items.

SaveValueFieldOnly

Set this property to TRUE to force the control to send only the Value Member value of the underlying lookup value when saving its value. Normally lookup controls that load data from other lists, use the ID;#TITLE format to save data

Sorted

Defines if the results will be sorted by the Display Field

UniqueField

If the internal name of a column is supplied, the retrieved results will be filtered allowing unique values for that specific field

Supports multiple fields. Any field supports the following properties:

Name

Name the new field.

Type

Values : Textbox, Datepicker, Combobox, Checkbox, Existing *
Choose how to represent the field when entering new data. Default : Textbox

Header
Name the column header appearing on the grid displaying the data.

Width
Define the column width on the grid displaying the data.

Required

Defines if the field is required or not.

Values
Pre-define values appearing e.g. on the combo-box part, while entering new data; E.g. ComboItem1;ComboItem2;ComboItem3.

* Existing type enables users to host any kind of control inside a DataEntryGrid form.

To do that, users have to

Create any kind of control inside the parent form
Set its properties, formulas, dependencies and scripts
Select and Hide the control (the control must be hidden in order to allow the DataEntryGrid form to use it)
Define a new field in the DataEntryGrid extra configuration and use “Existing” for the field type
In the “ExistingControlName” property type the control name of the corresponding control

ColumnName

Defines the list column internal name for which we want to show historical data .

ItemCount

Defines the count of the historical records to retrieve.

Note : For AppendText columns, only non-blank entries are retrieved.

Text
Indicates hyperlink’s description. If no value is specified, the control displays the navigation url.

Kind
Values : Relative/Absolute
If no value is specified, absolute is used.

Target
Values : _blank, _self
Indicates the hyperlink’s target website. If no value is specified, _self is used.

ShowDescription
Values Type : Boolean
Shows or hides the description textbox.

ShowBrowseButton

Shows or hides the Browse Button that can select document urls from SharePoint Document libraries

GetFullUrlFromBrowseDialog

If selected returns the full url (including the site url) from the popup browse dialog. If not it returns the relative url.

AllowSearchInFolders

Enables recursive search inside folders in the popup browse dialog.

AllowSelectURL

Allows the users to select the target URL.

AllowSelectLibrary

Allows the users to select the target Document Library.

TargetURL

Sets the target site url

TargetLibrary

Sets the Title of the target Document Library

Wrap
Value Type : Boolean (True = wrap, False = no wrap)
Wrap the Text

Underline

Defines text style

Tooltip
Value Type : String
Sets the tooltip text for the control. To add line breaks inside the tooltip, use the ‘\n’ character.

Columns
Value Type : Integer
Set the number of appearing columns

Sorted

Defines if the results will be sorted by the Display Field

UniqueField

If the internal name of a column is supplied, the retrieved results will be filtered allowing unique values for that specific field

Delimiter
Defines the character that delimits the records. E.g. \\n for new line

Prefix
Defines the beginning character of each line. E.g. \\counter for a numbered list

ButtonVAlign

Sets the vertical alignment of the browse/search button

AllowBlankSearchText

Defines if the user is allowed to search the list without providing text-search criteria

Sorted

Defines if the results will be sorted by the Display Field

SearchAnyPartOfText

If selected, searches the provided text in any part of the taregt column value. If not, returns the records that begin with the provided text.

UniqueField

If the internal name of a column is supplied, the retrieved results will be filtered allowing unique values for that specific field

EnableSearchOnFocus

This property defines if the control will display a search textbox when it receives focus, allowing users to type criteria and activate search by pressing the enter key

SearchFields

Define the fields that you want to search with. It the property is blank, then the display member will be used

DisplayFields

Define the fields that will be retrieved and displayed in the results list. It the property is blank, only the display member will be shown

Delimiter
Defines the character that delimits the records. E.g. \\n for new line

Prefix
Defines the beginning character of each line. E.g. \\counter for a numbered list

ButtonVAlign

Sets the vertical alignment of the browse/search button

AllowBlankSearchText

Defines if the user is allowed to search the list without providing text-search criteria

Sorted

Defines if the results will be sorted by the Display Field

SearchAnyPartOfText

If selected, searches the provided text in any part of the taregt column value. If not, returns the records that begin with the provided text.

UniqueField

If the internal name of a column is supplied, the retrieved results will be filtered allowing unique values for that specific field

SearchFields

Define the fields that you want to search with. It the property is blank, then the display member will be used

DisplayFields

Define the fields that will be retrieved and displayed in the results list. It the property is blank, only the display member will be shown

Delimiter
Defines the character that delimits the records. E.g. \\n

Prefix
Defines the beginning character of each line. E.g. \\counter

ActiveDirectorySearch

When set to True, the control searches Active Directory users also the same way that SharePoint does in People Pickers and requires the user to provide a search filter. If set to False, it retrieves users and groups from SharePoint groups.

ButtonVAlign

Sets the vertical alignment of the browse/search button

ValueChangeMode
Values : TextChange, LostFocus, None
Indicates that the control will raise the value change event in the form only when looses focus. If not set, the control will raise the event in every text change.

Align
Values : Left, Right, Center
Control the appearance of text alignment on the control.

EnterRaisesValueChange
If set to True, the control will raise the value change event when the user presses the Enter key inside the control. This can be used in order to create filter controls for list queries or web services and allows the user to provide filter criteria or apply the criteria by pressing the Enter key.

Decimals
Value Type : Integer
Define the number of decimal places allowed.

MinimumValue
Value Type : String
Defines the minimal numeric value allowed in the textbox. If empty, no restrictions are applied.

MaximumValue
Value Type : String
Defines the maximal numeric value allowed in the textbox. If empty, no restrictions are applied.

ActiveDirectorySearch
Value Type : Boolean
Use the control to lookup people information from the Active Directory listing.

MinimumValue
Defines the minimal numeric value allowed in the textbox. If empty, no restrictions are applied.

MaximumValue
Defines the maximal numeric value allowed in the textbox. If empty, no restrictions are applied.

Smallchange, Largechange
Value Type : Double

Decimals
Defines the number of decimals allowed.

Textmode
Values : None, Percentage, Value
Define how the value is represented on the bar itself. Percentage uses the (value * 100 / (max-min)) formula.

MinimumValue
Value Type : String
Defines the minimal numeric value allowed in the textbox. If empty, no restrictions are applied.

MaximumValue
Value Type : String
Defines the maximal numeric value allowed in the textbox. If empty, no restrictions are applied.

Smallchange, Largechange
Value Type : Double

Decimals
Value Type : Integer
Defines the number of decimals allowed.

Align
Values : Left, Right, Center
Control the appearance of text alignment on the control.

ParentFieldName
Defines the Parent in the self-referenced list.

Same configuration with the NumberTextBox plus the following parameter:

Step
Defines the rate at which the numeric value changes when pressing the directional (up,down) buttons on the control.

DefaultValues
Provide multiple default values for new records.

Pairs of Name/Value must be defined. The value part may depend on parent-form controls (i.e. {c_ID})

Showfilter
A Combobox appears above the datagrid which helps you to filter the data.

Filters
Values: Internal name of the fields
It contains the fields that are used in the filter combobox

GridHeight
Values: Numeric
The height of the list Datagrid.

Example :

DisplayMode

Defines the rendered type of the control. Supported values are : Button, Hyperlink, Label, ImageButton

Underline

Sets the text style of the Label and the Button control types

Image

Defines the image uri for the ImageButton control type

Actions

Defines multiple actions to be executed be the ActionButton control.

Action types supported are : SetValue, JavascriptCommand, Script.

Extended reference to the control can be found here :

Action button control

August 13, 2017/by Konstantinos