Field types

Each field has a type, which decides what it holds, how it is entered and shown, and which database column stores it. Settings marked (default …) are filled in for you.

Text

Short text

One line of text, up to 255 characters: names, titles, codes.

Setting	What it does
Maximum length	1 to 255 characters (default 100)
Format	Checks the value: none, an IPv4 address, an IBAN, or your own regular expression
Pattern	The regular expression, for the format regular expression
Input mask	Guides typing, such as (999) 999 99 99. 9 is a digit, a a letter, * a letter or digit; anything else is typed for you
Own mask characters	Extra mask characters, one per line, such as h=[A-Fa-f0-9]
Sensitive	Shows the value masked; see sensitive values
Show as	Text, a barcode or a QR code

Long text

Several lines of plain text: notes, descriptions, addresses.

Setting	What it does
Maximum length	(default 5000)
Lines shown	How tall the box is in forms, 2 to 30 (default 4)

Rich text

Formatted text with bold, italic, bulleted and numbered lists. Whatever is pasted in, Qorekit keeps only safe formatting: scripts, styles and anything that could run in a browser are removed.

Email

An email address. It is checked, and stored in lower case, so that Ada@Example.com and ada@example.com count as the same address in a unique field.

Web address

An http or https address. Other kinds of links are refused, so a web address can never run a script.

Show as	What people see
Link (default)	A link that opens in a new tab
Video	A player for YouTube and Vimeo (through their privacy-friendly embeds) or a video file
Audio	A player for an audio file
Embedded page	The page itself, inside the record. Only for sites an administrator has allowed

Players load only when someone presses play, so opening a record sends nothing to another site.

Phone

A phone number, stored in international form (+905321234567) however it was typed.

Setting	What it does
Default country code	Added to numbers typed without one, such as 90

Numbers

Whole number

A number without decimals, positive or negative.

Setting	What it does
Minimum value, maximum value	Limits for the value
Text before the number, text after the number	Such as ₺ or kg, up to 10 characters
Show as	The number (default), or a progress bar from the minimum to the maximum (0 to 100 when they are not set)

Decimal number

An exact decimal number; no rounding errors, which matters for quantities and rates.

Setting	What it does
Digits after the point	0 to 8 (default 2)
Minimum value, maximum value	Limits for the value
Show as a percentage	Shows 0.25 as 25%
Text before the number, text after the number	As for whole numbers
Show as	As for whole numbers

Money

An amount in one currency, set per field.

Setting	What it does
Currency	A three-letter code, such as EUR, USD or TRY (default USD)
Digits after the point	0 to 4 (default 2)
Minimum value, maximum value	Limits for the amount

Numbers are written in the installation's number format, such as 1,234.56 or 1.234,56. The stored value does not change with it.

Automatic number

A number or code that Qorekit gives each new record, such as INV-2026-0042. It cannot be typed or changed.

Setting	What it does
Pattern	The text of the number (default {0000})
Start counting again	Never, every year or every month
Show as	Text, a barcode or a QR code

The pattern holds exactly one of:

• a counter: {0000} counts up, with at least as many digits as zeros;
• a random code: {RANDOM:6} is six letters and digits, leaving out look-alikes such as 0 and O.

It may also hold {YYYY}, {YY}, {MM} and {DD} from the date the record was created. To start again every year, the pattern needs the year; every month, the year and the month. For example, TCK-{YY}{MM}-{000} gives TCK-2611-001.

Dates

Date

A day, without a time.

Setting	What it does
Calendar	The calendar of the date picker: Gregorian (default), Islamic, Islamic (Umm al-Qura), Persian, Hebrew, Buddhist or Japanese

Date and time

A moment, stored in UTC and shown in each person's time zone.

Setting	What it does
Minute steps in the picker	1, 5, 10, 15, 30 or 60 (default 5)
Calendar	As for dates

Choices

Yes or no

A switch.

Setting	What it does
Label for yes, label for no	Words to show instead of Yes and No, such as Paid and Unpaid

Single choice

One item from a choice list.

Setting	What it does
Choice list	The list whose items are offered
Show as	A drop-down (default), radio buttons, or stages: the items in a row, as steps

New records get the list's default item, if it has one.

Multiple choice

Any number of items from a choice list.

Setting	What it does
Choice list	The list whose items are offered
Fewest choices, most choices	How many items must and may be chosen
Show as	A drop-down (default) or checkboxes

Links

Related record

A link to a record of another entity, or of the same one: the company of a contact, the parent of a task. In forms, you find the record by typing part of its heading.

Setting	What it does
Related entity	Where the linked records come from
Allow several records	Links to any number of records instead of one

The link survives renaming either entity.

User

A link to one of the people who use Qorekit: an owner, an assignee.

Setting	What it does
Allow several users	Links to any number of users instead of one

Files

File

Uploaded files of any kind except programs.

Setting	What it does
Most files	1 to 20 (default 5)
Largest file (KB)	(default 10240, that is 10 MB)
Allowed extensions	Such as pdf, docx, xlsx; empty allows every kind except programs

Program files (.php, .exe, .sh, .bat and the like) are never accepted, whatever the setting says. The server's own upload limit also applies; your hosting provider sets it.

Image

Uploaded images: JPEG, PNG, GIF or WebP. SVG is not accepted, because it can carry scripts.

Setting	What it does
Most files	1 to 20 (default 1)
Largest file (KB)	(default 5120, that is 5 MB)