DatabasesWork with data

Field types

The 27 field types available in Formclick Databases, from text and numbers to linked records and formulas.

Every field has a type, which decides what it can hold and how values are checked. Each table also has a primary field, the value that names a record (for example, a contact’s name).

Group	Field type	Holds
Basic	Single line text	A short line of text.
Basic	Long text	Multiple lines of text.
Basic	Email	A validated email address.
Basic	Phone	A phone number.
Basic	URL	A web address.
Basic	Number	An integer or decimal number.
Basic	Currency	A monetary amount.
Basic	Percentage	A percentage value.
Date & time	Date	A calendar date.
Date & time	Date & time	A date with a time.
Date & time	Time	A time of day.
Date & time	Created time	When the record was created (automatic).
Date & time	Last modified time	When the record was last changed (automatic).
Selection	Checkbox	A yes/no toggle.
Selection	Single select	One option from a list.
Selection	Multiple select	Any number of options from a list.
Selection	Rating	A star rating.
Media	Attachment	Files of any allowed type.
Media	Image	Image files, with previews.
Advanced	Formula	A value computed from other fields. See Formulas.
Advanced	Auto number	An incrementing number (automatic).
Advanced	Unique ID	A generated unique identifier (automatic).
Advanced	Created by	Who created the record (automatic).
Advanced	Last modified by	Who last changed the record (automatic).
Advanced	Linked record	Links to records in another table. See Linked records.
Advanced	Lookup	Shows a field from linked records.
Advanced	Rollup	Summarises linked records.

Automatic fields (created/modified time and by, auto number, unique ID) fill themselves in and can’t be edited by hand.

Still need help? Contact support or email support@formclick.io.