English Flag English Español Flag Español Deutsch Flag Deutsch Italiano Flag Italiano Polski Flag Polski Nederlands Flag Nederlands Português Flag Português Français Flag Français 中文 Flag 中文 日本語 Flag 日本語 हिन्दी Flag हिन्दी اللغة العربية Flag اللغة العربية Русский Flag Русский Українська Flag Українська עִברִית Flag עִברִית Ελληνικά Flag Ελληνικά Türk Flag Türk Latvietis Flag Latvietis Dansk Flag Dansk Norsk Flag Norsk Íslenska Flag Íslenska 한국어 Flag 한국어 Suomen Flag Suomen Gaeilge Flag Gaeilge Bahasa Melayu Flag Bahasa Melayu Svenska Flag Svenska Čeština Flag Čeština
User IconLog In
English Flag English

Log In

 

All QuintaDB form field types (data columns)

About all available field types

Using QuintaDB you can create any web form with different fields types. In this blog post you will find a description of all available field types.

All fields are sorted according to four types: Standard, Additional, Dividers and others.

Standard

Single line

You can enter text in one line in this field. This field type is used to enter short text messages.

Multiple line

This field type is used to enter a long text in a multiline line without restrictions.

Number

 This is a numeric field type. Please note that only numbers are entered.

Decimal (.02)

The decimal field type is similar to the number field. The decimal field also accepts decimal numbers.

DropDown

A DropDown field type allows you to select an item from the list. The first item is selected by default.

Question: What is your favorite soccer team?

DropDown list

  • MU 
  • Arsenal 
  • Chelsea

MU is selected for Deafult.

Radio button

Radio button (multiple selection). The user can only select one item from the field.

For example:

Question: Do you like this web service?

Option field:

  • Yes
  • No
  • I dont know

 

Checkbox

The user can select an item from the field, all items or nothing.

Confirmation checkbox
This field allows you to add the user's consent to the form, which is required for confirmation.

Example: "I accept the terms of the user agreement and consent to the processing of personal data." In addition, the text of the user agreement can be replaced with a link that leads to the page with this agreement.

Date

With the pop-up calendar and the mouse you can easily select a desired date. The date format can be changed at any time.

 

Date and Time

With the pop-up calendar and your mouse, you can easily select a time you need. The time format can be changed at any time.

Time

Use Time field so that users can enter a time (hours, minutes, seconds).

File

This type of field allows you to upload a form file of any size or type to the web. By default, the limit for attached files is 10MB. You can change it at any time. Please read more about validating the file upload type.

Photo

This field type allows you to upload an image of any size or type to the web. The attached image limit is 10MB by default. You can change it at any time. Please read more about validating the file upload type.

 

Photo field options:

- You can set a limit for each file upload;

- You can choose file types from a list of file extensions that you want to upload;

- URL options (when you click the picture):

- Open the full size image in a new window;

- Open the record widget;

- Do nothing;

- Open URL in URL field (requires single line field type with URL validation);

- Standard image size (width, height).

E-Mail

In this field, users can enter a valid email address.

Phone

Using Phone field you can collect contact information, interact with customers and make SMS-newsletter.

You can customize a specific input type for phone numbers to make data processing easier.

URL

This field allows users to enter the link to a website or webpage.

 

Advanced

Formula

Formula field Type is used to add, subtract, multiply, and divide the field value.

Signature

Use Signature field, Users can draw a signature and save it as an image in the database

 

Birthday

Used to enter the birthday date. You can see the age of the user in the table.

Boolean

It's a logical type. You can only choose yes / no.

Language

It's a drop-down list of language names. You can use this list created by QuintaDB or you can create your own. Use a drop down box type to create a language list.

U.S. States

States drop-down list.

Country

It's a drop-down list of country names. You can use this list created by QuintaDB or you can create your own. Use a drop down box type to create a list of countries.

Time zone

It's a drop-down list of time zone names. You can use this list created by QuintaDB or you can create your own. Use a drop-down box type to create a time zone list.

Matrix

The matrix field can be added to the web form to provide a range of cells. It's like an editable HTML table controller for your online database. Continue reading here.

Autoincrement

This field type is an addition to the existing fields in the table. The auto increment field value is generated automatically. You can change the starting value and the step.

In QuintaDB, the autoincrement field is the numeric field in which you can enter the value of the increasing numeric sequence.

Location

With this field you can collect coordinates in the format 'latitude, longitude'.

 

Record owner

Allows you to assign record owners.


Actions

Allows you to create and add custom actions to your database. Read more about the field of action by this link.

Relationship

Use relationship field link tables in QuintaDB

Subform

Subform field allow you to insert one form into another.

 

Dividers and others

Text, HTML and JavaScript code

With this field type you can embed any text in the form.


Section heading

This field is used to add a title to a group of fields.

Page break

This field adds a page break to the form.

 Login
Password

You can read all the detailed information about the functionality of the Login Query Engine in this blog post.