DB-Views Column Types

Text fields

  • Identifier – accept letters, digits & underscore
  • Password – 6 to 30 characters, at least one digit and one capital letter
  • Domestic and international phone number. Numbers are formatted and validated by using the Google’s international phone numbers database.
  • Domestic and international mobile phone number. Numbers are formatted and validated by using the Google’s international phone numbers database.
  • General Text with optional validation
Character length limit can be set on all text fields.

Web fields

  • Email address
  • URL address
  • IP address
  • File upload
  • Multiple file upload (file gallery)

Numeric fields

Range check can be set on numeric fields.

Date and time fields

  • Date
  • Time of day
  • Date and time
  • Date range
  • Time of day range
  • Date and time range

Range check can be set on date & time fields.

Boolean fields

  • Check box
  • Switch
  • Tri-state checkbox

Selection fields

  • Fixed values
  • Values from lookup table
  • Values calculated by JavaScript snippet
  • Values calculated by REST call

Note: Large number of selections supported by auto-complete widget

Multi-selection fields

  • Fixed values
  • Values from lookup table
  • Values calculated by JavaScript snippet
  • Values calculated by REST call
  • Values by multi-to-multi table relation

Calculated fields

  • Value based on other fields, calculated by JavaScript snippet

General comments

  • Fields can be set as mandatory (user input forced) or optional.
  • Fields can be set as unique or may-repeat