Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

...

Property
Description Of propertyValues / Conditions

Default

View

List

View

Add

View

Edit

View

Delete

View

 
Read OnlySets field to read only in viewCheckbox true or false   x  
Use DefaultSets field to use default valueCheckbox true or false   x  
CustomiseCan customise field per form viewCheckbox true or false xxxx 
NameThe unique field namePlease ensu the field name contains only a-z A-Z 0-9 _ x     
TypeA solution from the available fields listMandatory requirementx     
LabelThe field label to display on the form

Characters limits by form width

xxxxx 
Label PlacementA selection on the label placement on the form

value include:

  • Default (See at form level) (Default)
  • Auto
  • Left
  • Above
xxxxx 
Label StyleA selection on the label style types

value include:

  • Plain (Default)
  • Bold
  • Italic
xxxxx 
Default ValueSet the default value to display in field x xx  
RequiredIf true, field must contain a valueCheckbox true or falsex xx  
TooltipText to be displayed on clicking "?" symbol on form xxxxx 
Hint textText to be displayed below field on form xxxxx 
Row ClassCustom CSS class for rows on form xxxxx 
Row StyleCustom CSS style for that field on form xxxx  
Max WidthSet the maximum width to display for that field

A numeric number ever set by

  • Characters (Default)
  • Ems

 

xxxx  
PrefixText use want to display before the fieldCharacters limits by form widthx xx  
SuffixText use want to display after the fieldCharacters limits by form widthx xx  
Character LimitSet the maximum number of characters you can enter in that field x xx  
Placeholder TextText use want to display in the fieldText will disappear once field is enteredx xx  
Conditional LogicAbility to add conditional logic to that fieldFor more information see Field Conditional Logicxxxx  
Max Decimal PlacesSets the number of max decimal places Number, Currency, and calculation fields onlyx xxx 
StepSets the value for increments on number fields Number fields onlyx xxx 
Use SliderSet to true provides a slider control instead of text field Number fields onlyx xxx 
Minimum ValueSets the minimum value that can be entered in the field Number and currency fields onlyx xxx 
Maximum ValueSets the maximum value that can be entered in the field Number and currency fields onlyx xxx 
SymbolSets the currency symbol used for the field Currency fields onlyx xxx 
Show Textbox

Currently inactive for future feature development.

If you require to include / exclude the field for display on all or selected views ,

You can include / exclude them from the forms elements configuration selectors.

For more information see Form Configuration.

Currently inactive

 Calculation fields only. Values include:

  • Show (Default)
  • Hidden

Field is always read-only 

x xx  
Calculation Type

Selection for automatic or manual calculation of form.

For more information see Field Calculation Logic.

Calculation fields only. Values include:

  • Auto. (Automatically calculates result)
  • Manual . (Requires a button to be pressed to start calculation)

 

x xx  
OptionsOptions for selections to be displayed in the field. Radio and select fields only.x xxx 
Data Source

Select the external source of options or selections to be displayed in the field.

This options list can come from a data suitcase or an interaction.

For more information See Field Cascading Select Lists Logic

Select field only. Values include:

  • None (Default)
  • Data Suitcase
  • Interaction
x     
Data Suitcase Name

Here you add the name of the data suitcase used in the data source.

Displayed when data source property is set to "Data Suitcase".

Select fields onlyx     
Interaction Name

Here you add the name of the interaction used in the data source.

Displayed when data source property is set to "Interaction".

Select fields only      
Data Suitcase Type

Here you add the type of the data suitcase used in the data source.

Displayed when data source property is set to "Data Suitcase".

For more information see Data Suitcase Types.

Select fields only. Values include:
  • server-related
  • personal
x     
XPATH (for options)

Here you add add an xpath expression for filtering results to be used in the options list for the field.

Displayed when data source property is set to "Data Suitcase" or "Interaction".

For more information See Field Cascading Select Lists Logic

Select fields onlyx     
Update On Change

Here you can select from a list of available fields which display options

will be changed based on the selection made in this primary field creating cascading results.

Displayed when data source property is set to "Data Suitcase" or "Interaction".

For more information See Field Cascading Select Lists Logic

Select fields onlyx     
Update On Form Load

If set to true, the select list options are created and displayed at the form load event.

Displayed when data source property is set to "Data Suitcase" or "Interaction".

For more information See Field Cascading Select Lists Logic

Select fields onlyx     
1st option not valid

If set to true the 1st option in the list is display but is not valid for a selection.

Example use " == Please Select One=="

Select fields onlyx xxx 
Can Specify Other

If set to true a selection marked "Other" will be displayed in the list of options.

If selected on the form an addition field will be displayed below for entered a value.

Select and multi select fields onlyx xxx 
Allow zero stars

If set to true the star rating value on form load will be zero (Or no stars selected).

Once a star rating has been selected the value will never return to zero.

Star Fields only.

If true, will allow zero stars selection even if field is set to "Required" on form submission event and will show no user error.

x xxx 
Date DisplayHeres you can select 1 of 3 display methods for the date or date / time fields across all form views and actions. Date / Date Tme fields only. Values include:
  • Picker ( Display a date / Date Time Picker) (Default)
  • Read Only ( Show a read only date display)
  • Hidden ( Hide the field across all form views and actions)
x xxx 
Date Display Format

Here you can select the display format for your date field.

These formats can be overrode at a global form configuration level.

Date fields only. Values include:

  • DD-MM-YYYY) (Default)
  • YYYY-MM-DD
  • MM-DD-YYYY
  • DD/MM/YYYY
  • YYYY/MM/DD
  • MM/DD/YYYY
  • Custom Format (Allows use to add your own format)
x xxx 
Time Display Format

Here you can select the display format for your time field.

These formats can be overrode at a global form configuration level.

Time fields only. Values include:
  • HH:MM (23:59) (Default)
  • MM:SS (23:59:59)
  • HH:MM AM/PM (11:59 AM)
  • HH:MM:SS AM/PM (11:59:59 AM)
  • Custom Format (Allows use to add your own format)
x xxx 
Allow From

Sets the starting date range on the date picker. The calendar date picker select options for month and year will start at this date.

If the "Read Only" property is set the default or "Now" date will be displayed only, No date picker.

Date fields only. Values include:
  • Now Sets the start date as today (Default)
  • Now -/+ (Enter a plus or minus value of a number of days)
  • Date (Allows you to select an actual date to start from)
x xxx 
Allow To

Sets the ending date range on the date picker. The calendar date picker select options for month and year will end at this date.

Date fields only. Values include:
  • None (Default)
  •  Now -/+ (Enter a plus or minus value of a number of days from the now date)
  • Date (Allows you to select an actual date to end from)
x xxx 
Default Date

Sets the default date on the date picker. The calendar date picker select options for month and year will start at this date.

If the "Read Only" property is set the default or "Now" date will be displayed only, No date picker.

 Date fields only. Values include:
  • None (Default)
  • Now Sets the default date as today
  • Now -/+ (Enter a plus or minus value of a number of days from the now date)
  • Date (Allows you to select an actual date to end from)
x xxx 
Default TimeSets the default time on the time picker. Time fields only. Values include:
  • None (Default)
  • Now Sets the default time as the form load time
  • Now -/+ (Enter a plus or minus value of a number of minutes from the form load time)
      
Native Date PickerSet to true the form will allow the native device to use its default builtin date picker instead of the form control. Date fields onlyx xxx 
Native Time PickerSet to true the form will allow the native device to use its default builtin time picker instead of the form control. Time fields only.x xxx 
Minute StepSets the number of minutes to step thru in the time picker Time fields only. Values include:
  • 1 Minute (Default)
  • 5 Minutes
  • 10 Minutes
  • 15 Minutes
x xxx 
Button Text

The text to be displayed the manual calculation button.

Displays only when calculation type property is set to "Manual".

Calculation fields only.

x     
Hidden

Set to true will hide this field with the defaulted value on the default view.

You can include / exclude them from the forms elements configuration selectors.

For more information see Form Configuration.

Value fields onlyx     
ValueIn this property you can enter a default hardcoded value to be used in every form record.  Value fields only x     
Default is checkedIf set to true the checkbox will be checked as default Checkbox fields onlyx     

For a list of properties by field type see Field properties By Type List

Field Data Dictionary

Type User Type SystemType DatabaseSize
  autonumberINT10
Text BoxImage AddedtextboxTINYTEXT 
Text AreaImage Addedtext_areaTEXT 
Password BoxImage AddedpasswordTINYTEXT 
EmailImage AddedemailTINYTEXT 
URLImage AddedurlTINYTEXT 
Phone NumberImage Addedphone_numberTINYTEXT 
NumberImage AddednumberVARCHAR20
CurrencyImage AddedcurrencyTINYTEXT 
CalculationImage AddedcalculationTINYTEXT 
Radio ButtonsImage AddedradioTINYTEXT 
Select BoxImage AddedselectTINYTEXT 
Star ratingImage Addedstar_ratingVARCHAR255
Multi SelectImage AddedmultiTINYTEXT 
CheckboxesImage AddedcheckboxesTINYTEXT 
CheckboxImage AddedcheckboxSMALLINT1
DateImage AddeddateDATE 
TimeImage AddedtimeTIME 
  _time_offsetVARCHAR6
Date + TimeImage AddedImage AddedtimestampDATETIME 
  _time_offsetVARCHAR6
CameraImage AddedcameraMEDIUMBLOB 
  _infoTEXT 
  _exifTEXT 
Image LibraryImage Addedimage_libraryMEDIUMBLOB 
  _infoTEXT 
  _exifTEXT 
File UploadImage Addedfile_uploadMEDIUMBLOB 
  _infoTEXT 
  _exifTEXT 
Sketch / SignImage Addedsketch_signatureMEDIUMBLOB 
ValueImage AddedavalueTINYTEXT 
Logged in UserImage Addedlogged_in_user_idINT10
User AttributeImage Addeduser_attributeTINYTEXT 
GET ValueImage Addedget_valueTINYTEXT 
LocationImage AddedlocationVARCHAR255
  _latitudeVARCHAR255
  _longitudeVARCHAR255
  _accurancyVARCHAR255
  _altitudeAccuracyVARCHAR255
  _headingVARCHAR255
  _speedVARCHAR255
  _geocodeVARCHAR255
  _geocode_accuracyVARCHAR255
  _providerVARCHAR255
Type User Type SystemType DatabaseSize
  autonumberINT10
Text BoxImage ModifiedtextboxTINYTEXT 
Text AreaImage Modifiedtext_areaTEXT 
Password BoxImage ModifiedpasswordTINYTEXT 
EmailImage ModifiedemailTINYTEXT 
URLImage ModifiedurlTINYTEXT 
Phone NumberImage Modifiedphone_numberTINYTEXT 
NumberImage ModifiednumberVARCHAR20
CurrencyImage ModifiedcurrencyTINYTEXT 
CalculationImage ModifiedcalculationTINYTEXT 
Radio ButtonsImage ModifiedradioTINYTEXT 
Select BoxImage ModifiedselectTINYTEXT 
Star ratingImage Modifiedstar_ratingVARCHAR255
Multi SelectImage ModifiedmultiTINYTEXT 
CheckboxesImage ModifiedcheckboxesTINYTEXT 
CheckboxImage ModifiedcheckboxSMALLINT1
DateImage ModifieddateDATE 
TimeImage ModifiedtimeTIME 
  _time_offsetVARCHAR6
Date + TimeImage ModifiedImage ModifiedtimestampDATETIME 
  _time_offsetVARCHAR6
CameraImage ModifiedcameraMEDIUMBLOB 
  _infoTEXT 
  _exifTEXT 
Image LibraryImage Modifiedimage_libraryMEDIUMBLOB 
  _infoTEXT 
  _exifTEXT 
File UploadImage Modifiedfile_uploadMEDIUMBLOB 
  _infoTEXT 
  _exifTEXT 
Sketch / SignImage Modifiedsketch_signatureMEDIUMBLOB 
ValueImage ModifiedavalueTINYTEXT 
Logged in UserImage Modifiedlogged_in_user_idINT10
User AttributeImage Modifieduser_attributeTINYTEXT 
GET ValueImage Modifiedget_valueTINYTEXT 
LocationImage ModifiedlocationVARCHAR255
  _latitudeVARCHAR255
  _longitudeVARCHAR255
  _accurancyVARCHAR255
  _altitudeAccuracyVARCHAR255
  _headingVARCHAR255
  _speedVARCHAR255
  _geocodeVARCHAR255
  _geocode_accuracyVARCHAR255
  _providerVARCHAR255