The list of an entity

Everyone who opens an entity sees the same list: the same columns, in the same order, sorted the same way. The list's design decides it.

Open the entity, choose Design, then the List tab. Designing lists needs the administration permission Design forms and share views or Add and change entities and fields.

Drafts and publishing

Changes to the list are kept as a draft. People keep seeing the published list until you choose Publish; Discard changes throws the draft away. While you work, Preview shows the list with a few real records.

Columns

Columns shown, in order holds the columns of the list; Hidden holds the fields that are not shown. Drag columns between the two and into order, or use the arrow keys, Home and End.

The heading field opens the record when someone selects it. When the heading is hidden, the first column does.

The built-in columns (ID, Created, Created by, Last changed, Last changed by) can be shown like any other field.

Default sort

Default sort decides the order of the records:

• Newest first, the default;
• Created, newest or oldest first;
• Last changed first;
• a field, ascending or descending. Short text, email, web address, phone, number, money, automatic number, date and date and time fields can sort a list, unless they are sensitive.

Large lists

Lists are built to stay quick with many records: an entity with a hundred thousand records opens in a fraction of a second on ordinary shared hosting. Qorekit shows the list a page at a time, so the size of the table matters little.