Which field types are available
Admin-level account permissions are required to assign field types in a table.
When creating a new field, it's essential to understand and assign the correct field type. Once a field is saved and added to a table, its field type cannot be changed. Before editing fields, it's best practice to export the current table to preserve records and references that might be altered or deleted.
Please find all available field type options below:
 | Single-line Text: Short single-line text |
 | Number: Number with possible decimal |
 | Yes/No: Binary yes/no value |
 | Multi-line Text: Long multi-line text (can store clickable URLs) |
 | Dropdown: Picklist of up to 1,000 predefined choices (limited to one selection) |
 | Dropdown Multiple: Picklist of up to 1,000 predefined choices (multiple selections available) |
 | Date: Date in the format MM/DD/YYYY |
 | Currency: Currency amount with symbol |
 | Attachment: Any type of file attachment, including images |
| *See below for additional guidance on storing images and file types |
 | Reference: Creates a relationship/link to one record in another table |
 | Reference Multiple: Creates a relationship/link to multiple records in another table |
 | Lookup: Read-only subfield pulled from a referenced table |
 | Created At: Displays creation date and time |
 | Updated At: Displays date and time of last update |
 | Formula: Calculates values based on predefined logic |
 | Rollup: Calculates values based on an aggregate formula between the main table and a source table/source field |
*Attachments continued: Logos are stored using this field type. Acceptable image file types for the Elements App include .svg, .gif, .png, .jpeg, .webp, .psd, .bmp, and .tif. Images exceeding 3300px by 3300px will be automatically scaled when exported to retain the integrity of high-density images.
Please note: Attachment files should not exceed 1GB per file when stored in a single record. This limit applies to all attachment types, i.e. images and/or documents.
Auto-Increments: This applies to number field types only. To have records automatically generate a unique and sequential number when the value for this field is empty, toggle the Auto-Increment switch. When applied, the next number in the sequence will auto-populate for new records added to a table. This will not alter existing number values. As a default, the number will start at 1 but can be updated to any desired number. When creating a new table from scratch, the auto-increment feature is a great way to generate unique ID's.
We’d love to hear from you. If you have any feedback on product enhancements or additional questions, email the team at PitchlySupport@pitchly.com.