Yes.

DB-Views offers a free of charge starter license. With this license, you can experiment with all the features of DB-Views. You may permanently utilize your apps and views for commercial applications. You may create application prototypes and demos as well.

Text fields

Character length  limit can be set on fields.

Web fields

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

Numeric fields

  • Integer number
  • Number with fraction (real number)
  • Money value
  • Percent value
  • Number range

Range check can be set on 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 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

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

Besides of the built-in field validation, DB-Views supports the following input validation methods:

  • Text fields can be validated by defining an input pattern. (e.g., zip codes)
  • Text fields can also be validated by specifying a JavaScript regular expression. This expression is evaluated whenever the end-user types a character.
  • A JavaScript validation snippet can be defined on all field types.  This snippet is executed whenever the end-user types a character providing a powerful and detailed error detection.
  • Cross-field validation is done by specifying a form-level JavaScript snippet. This snippet is executed when the end-user submits the form.

Yes. You may define webhooks for every table. Events supported: row add, row delete and row update.