The Column History Viewer Control
In order to support versioning in lists as well as AppendText columns, the ColumnHistoryViewer control has been introduced.
It allows the user to retrieve historical data from columns.
To use the ColumnHistoryViewer control, just place it on the form using the designer.
Open the control properties and set ColumnName to the column you want to handle:
Set the control height to fit your needs, save your form design and you are ready to go.
NOTE : For AppendText columns, the history viewer excludes blank entries.
The DataEntryGrid control
It is a datagrid with which a user can enter, edit or delete information stored.
Records can be edited in a dynamically generated form :
The grid’s fields and columns can be declared using the designer’s Extra Configuration field.
DataEntryGrid properties:
Property : Name
Value Type : String
Name the new field.
Property : Type
Values: Textbox, DatePicker, Combobox, Checkbox, Existing
Choose how to represent the field when entering new data. Default: Textbox.
Property : Header
Value Type: String
Name the column header appearing on the grid displaying the data.
Property : Width
Value Type : String
Define a gird column’s width used to display data.
Property : Values
Value Type : String
Pre-define static values to appear on some controls. For example, static values to be used as selections on the combo-box part. (ComboItem1; ComboItem2; ComboItem3)
Property : ExistingControlName
Value Type : String
With control type set as ‘Existing’, you can set the name of an existing control on the form (should normally be created as a hidden control and used solely for this purpose).
Example :
Note : Data created using the Extra Configuration wizard is saved in XML format. Regular users should avoid editing the code manually.
Creating a new DataEntryGrid field
In order to create a new field, select the ‘Fields’ folder and press the plus (+) button.
A new Field appears with the default value in each property.
Our goal is to create a column in the DataEntryGrid as Type Existing, using a hidden control called Resource. The Resource control, called ‘c_Recource’, is a combobox type control, which contains information from a list called Resources (the Title of each row). In Order to do so, we enter the following value in its respective property:
Name : Resource
Type: Existing
Required: False
Header: Resource
Width: 200
Values: (blank)
ExistingControlName: c_Recource
Saving our changes and pressing ‘New Record’ on the DataEntryGrid control opens a pop-up window with the newly created control on top.
The TreeViewPicker control
TreeViewPicker control is like lookupPicker control but shows the data in at tree view way.
The settings that should be declared are the Lookup Details (list, displayName, value etc.) and one property in the Extra Configuration tab: ParentFieldName.
The ParentFieldName should be located in the list that is already declared in Lookup Details and it should be lookup field that is self-referenced.In Extra Configuration field should be declared the internal name of the field.(in our example below ParentFieldName=ParentCategory)
There is an example below:
Our TreeViewPicker Control contains these data:
We are reading our data from a list with 2 fields, Category and ParentCategory where Category is a single line text and ParentCategory is a lookup field that looks in Category field within the same list.
The Slider control
The Slider is a control that is not available in sharepoint. It can be used instead of a numeric textbox, or it can be connected with a numeric textbox as a different representation of the number.
In order to connect the slider with a numeric control, slider Control should be declared as Calculated.
The calculation formula should be {Control_Name} where Control_Name is the name of the numeric control that passes the value. In our example {Percentage}.
The slider control can store its data in a single line column or a numeric column.
The properties that can be used are:
Property : min
Numeric, indicates the minimum value for the progress bar
Property : max
Numeric, indicates the maximum value for the progress bar
Property : smallchange
Numeric
Property : largechange
Numeric
Property : decimals
Numeric, set the number of decimals for the value, default is 0.
The properties should be declared in the Extra Configuration field of the control
The NumberTextBox and UpDownNumberTextBox controls
A NumberTextBox is a textbox that accepts only numeric input. By default, it restricts the entry of characters to digits
Any of the available options can be used.
The NumberTextBox does not provide any Lookup options since it cannot contain lookup data
ValueChangeMode
Values : TextChange, LostFocus, None
Indicates that the control will raise the value change event in the form only when loses 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
Values: True, False (Default)
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
Values: Number
Define the number of decimal places allowed.
MinimumValue
Values: Number
Defines the minimal numeric value allowed in the textbox. If empty, no restrictions are applied.
MaximumValue
Values: Number
Defines the maximal numeric value allowed in the textbox. If empty, no restrictions are applied.
The Label control
A Label is a control that serves as a guide to the user. It provides static text that the user cannot change but can read to get information on a form.
Most controls on the form are not explicit at first glance and the user may not know what they are used for. Therefore,
you can assign a label to a control to help the user understand its purpose.
Any of the available options can be used.
The Label does not provide any Lookup options since it cannot contain lookup data.
Wrap
Values : True = wrap text, False = no wrap (Default value)
Perform text wrapping.
Underline
Values : True = underline text, False = no underlining (Default value)
Underlines the text.
Tooltip
Values : Any text
Set the tooltip of the label. Use ‘\n’ in order to add new-line characters.