+1 (408) 320-0380
« Back to List

Fields

Field types

The list of field types available for creating:

  • Varchar – a single-line text;
  • Enum – selectbox, only one value can be selected;
  • Text – a multiline text with markdown support;
  • Date – date w/o time;
  • Date-Time – date and time;
  • Currency – for currency values, a pair of number and currency;
  • Int – a whole number;
  • Float – a number with a decimal part;
  • Boolean – a checkbox;
  • Multi-Enum – a list of values, multiple values can be selected;
  • Checklist – a list of checkboxes;
  • Array – a list of values, similar to Multi-Enum field;
  • Address – an address with street, city, state, postal code and country;
  • Url – for storing links;
  • Wysiwyg – similar to Text field, but with HTML support;
  • File – for file uploading;
  • Image – for image uploading;
  • Attachment-Multiple – for multiple file uploading;
  • Number – an auto-incrementing number of string type with a possible prefix and specific length;
  • Auto-increment – a generated read-only auto-incrementing integer number.

Field types not available for creating directly:

  • Email – a set of email addresses;
  • Phone – a set of phone numbers;
  • Link – a record related through Belongs-To (many-to-one or one-to-one) relationship;
  • Link-Parent – a record related through Belongs-To-Parent relationship; can be of different entity types;
  • Link-Multiple – a set of records related through Has-Many relationship.

Common field parameters

  • Label – a name of a field displayed on UI;
  • Required – whether a field is mandatory; user won't be able to save a record w/o filling the field;
  • Audited – field changes will be stored in stream;
  • Read-only – a field value can't be specified; can be calculated by formula or workflow rule;
  • Default – a value pre-filled when creating a new record;
  • Disable Inline Edit – useful when using dynamic forms logic;
  • Tooltip Text – info about a field for users.

Dynamic Logic

Provides an ability to make forms dynamic. It's possible to define conditions making certain fields visible, required or read-only. Conditions will be checked automatically when data in the form is changed.

For Enum, Array and Multi-Enum fields it's possible to define different sets of options that will be available for the field depending on which condition is met. See more here.

Available items:

  • Conditions making field visible
  • Conditions making field required
  • Conditions making field read-only
  • Conditional options – for enum, multi-enum, checklist, array, varvhar fields

Varchar

A single-line text.

Parameters:

  • Max-length – a max acceptable length of text;
  • Trim – to trim whitespaces from text;
  • Options – a pre-defined list of values for an autocomplete.

Varchar

Enum

Selectbox, only one value can be selected.

Parameters:

  • Options – a list of values (key => label pairs); color (style) for each value can be specified (applied when param Dispaly as Label is enabled);
  • Is Sorted – to sort a list alphabetically;
  • Display as Label – a value will be displayed as a label with a color; a color for each option can be specified.

It's possible to define conditional options with Dynamic Logic.

Enum

Enum detail view

Text

A multiline text with markdown support.

Parameters:

  • Max-length – a max acceptable length of a text;
  • Disable Text Cut – if not checked, then long texts will be shortened and can be expanded (for detail view mode);
  • Number of rows of textarea – if specified, then height of a textarea will be fixed, otherwise it's flexible (for edit view mode);
  • Cut Height (px) – a max height of a text, if longer, then it will be cut (for detail view mode);
  • Display raw text (no markdown) – to disable markdown support.

Text

Text detail view

Date

Date w/o time.

Parameters:

  • After (field) – a validation: a date value should be after a date value of a specified field;
  • Before (field) – a validation: a date value should be before a date value of a specified field;
  • Use Numeric Format – if not checked, then words 'today', 'yesterday', 'tomorrow' are in the detail view mode.

Date

Date detail view

Date-Time

Date and time.

Parameters:

  • After (field) – a validation: a date value should be after a date value of a specified field;
  • Before (field) – a validation: a date value should be before a date value of a specified field;
  • Use Numeric Format – if not checked, then words 'today', 'yesterday', 'tomorrow' are in the detail view mode;
  • Minutes Step – defines items displayed in the minutes dropdown (in the edit mode).

Date-Time

Date-Time detail view

Currency

A currency value, a pair of number and currency.

Parameters:

  • Min – a validation: min acceptable value; if empty, then no validation applied;
  • Max – a validation: max acceptable value; if empty, then no validation applied.

Currency

Currency detail view

Int

A whole number.

Parameters:

  • Min – a validation: min acceptable value; if empty, then no validation applied;
  • Max – a validation: max acceptable value; if empty, then no validation applied;
  • Disable Formatting – if not checked, then a value is formatted with a thousand separator.

Float

A number with a decimal part.

Parameters:

  • Min – a validation: min acceptable value; if empty, then no validation applied;
  • Max – a validation: max acceptable value; if empty, then no validation applied.

Boolean

A checkbox. Two possible values: true and false.

Boolean

Multi-Enum

A list of values, multiple values can be selected. The list is ordered.

Multi-Enum

Multi-Enum detail view

Parameters:

  • Options – a list of values (key => label pairs); color (style) for each value can be specified (applied when param Dispaly as Label is enabled);
  • Is Sorted – to sort a list alphabetically;
  • Allow Custom Options – if checked, a user can add custom values (not defined by Options parameter) by typing text and pressing the enter key;
  • Max Item Count – validation: how much items can be added;
  • Display as Label – values will be displayed as a label with a color; a color for each option can be specified;
  • Display as List – values will be displayed each in new line.

Checklist

A list of checkboxes.

Parameters:

  • Options – a list of values (key => label pairs); color (style) for each value can be specified (applied when param Dispaly as Label is enabled);
  • Is Sorted – to sort a list alphabetically;
  • Max Item Count – validation: how much items can be checked;

Array

A list of values, similar to Multi-Enum field.

Parameters:

  • Options – a list of values (key => label pairs); if no options specified, then a user will be able to add any options;
  • Empty string value is not allowed – if not checked, a user can add an empty string as an item;
  • Max Item Count – validation: how much items can be added.

Array

Address

An address with street, city, state, postal code and country.

Address

Url

For storing links.

Parameters:

  • Max-length – a max acceptable length of text;
  • Strip – if checked, then http(s):// if trailing / will be stripped.

Wysiwyg

Similar to Text field, but with HTML support.

Parameters:

  • Height (px) – a height of the field (in edit view mode); if empty – then height is flexible;
  • Min Height (px) – a min height of the field (in edit view mode);
  • Use Iframe – if checked, then HTML will be placed into IFRAME element.

File

For file uploading.

Parameters:

  • Source List – allows a user to get a file from another record (Documents source is available out-of-the-box);
  • Max File Size (Mb) – validation;
  • Accept – which file types cab be accepted; see info about file types.

Image

For image uploading.

Parameters:

  • Preview Size – defines a size of an image displayed on the detail/list view;
  • Max File Size (Mb) – validation.

Attachment-Multiple

Allows to upload multiple files.

Parameters:

  • Source List – allows a user to get a file from another record (Documents source is available out-of-the-box);
  • Max File Size (Mb) – validation;
  • Accept – which file types cab be accepted; see info about file types;
  • Preview Size – defines a size of an image displayed on the detail/list view.

Number

An auto-incrementing number of string type with a possible prefix and specific length.

Parameters:

  • Prefex – a text that will be preprended to a number;
  • Next Number – a number that will be applied to the next created record;
  • Pad Length – a length of the numeric part; if less then will be padded with zero digits, e.g. 00001.

Number

Auto-increment

A generated read-only auto-incrementing integer number.

Email

A set of email addresses with their parameters: Opted-out, Invalid, Primary.

Phone

A set of phone numbers with their parameters: Type, Opted-out, Invalid, Primary.

Parameters:

  • Type List – a list of types available for phone numbers (e.g. Home, Office).

A record related through Belongs-To (many-to-one or one-to-one) relationship.

A record related through Belongs-To-Parent relationship. Can be of different entity types.

Parameters:

  • Entity List – a list of entity types available to be related through the field.

A set of records related through Has-Many (many-to-many or one-to-many) relationship. Not all relatioships have their link-multiple fields. Only those do, where Link-Multiple parameter(s) is enabled.