Column Setup
This section guides you on how to add new columns to your table and configure column properties such as the input type, constraints, default values, lookup values, display name, and other column attributes, such as column width and access control. Explore them below:
PowerTable allows you to add columns with the following data types:
Field type name
Data type
Description
Support article
Button
button object
The button field adds interactivity to your record such as opening a URL.
Checkbox
boolean
A checkbox field is useful for true/false values within a record.
Count
number
A count field lets you count the number of linked records in a record link column.
Currency
number
A currency field is a specific type of number field that formats the number as a currency amount.
Date & Time
string (ISO 8601 formatted date)
A date field allows you to easily enter a date and optionally a time into a cell. When editing a date time, you will be presented with a calendar widget that makes it easy to select a specific date.
string
An email field is intended to store a single email address in each cell. Clicking on an email address within an email field will open up your computer's native email client with the To: field addressed to the email you just clicked on.
N/A
Formula
varied outputs (depending on the formula)
Formulas allow you to compute a value in each record based on other cells in that same record.
Last modified by
collaborator object
The last modified by field displays which collaborator made the most recent change to a record.
Last modified time
string (ISO 8601 formatted date)
The last modified time field type returns the most recent date and time that a record was modified by a user in a non-computed field
Linked record (Link to another record)
array of record IDs (strings)
A linked record field allows you to represent the relationships between related records by creating links between them. This is particularly helpful when you have multiple tables of related items or concepts—for example, if you have a table of contacts and a table of companies, you can use a linked record field to link each contact to the company that they work for.
Long text (With or without rich text formatting enabled)
string
A long text field is great when you need to keep notes or multiple lines of text in each record. You can enter new lines into a long text field, and even @mention a collaborator inside the text. If you need more styling options, you can enable rich text for the field.
N/A
Lookup
array of numbers, strings, booleans, or objects
A lookup field allows you to look up a specific field in a linked record.
Multiple select
array of strings
A multiple select field is similar to a single select field; it allows you to select predetermined options from a list. Unlike a single select field, however, you can select as many options as you'd like per cell.
Number
number
The number field type is a field type designed to hold numbers. The number field type is a general-purpose field type for most numerical values, like the number of chairs of a particular type your furniture business has in stock, or the distance in kilometers from one city to another city.
Percent
number
The percent field type is a field type designed to hold numerical values formatted as percents. The values in a percent field are all represented as fractions of 100 with the percent sign; e.g. the number .75 in a percent field is represented as 75%.
Phone number
string
A phone number field will format a 10-digit string of numbers as a US/Canada phone number, in the form (XXX) XXX-XXXX.
N/A
Rating
number
The rating field allows you to rate your records for the purposes of ranking or quality assessment.
Single select
string
A single select field is ideal when you want to be able to select a single option from a preset list of options.
N/A
URL
string
A URL field is intended to store a single URL in each cell. Clicking on a URL will bring you to that URL.
N/A
Number
Decimal
Text
Date Time
Date
Single Select
Check Box
Image
Person
URL
Email
The number column type can also be customized to have ratings in the form of icons and stars, as seen on common e-commerce sites. Similarly, the text type column
Further, you can configure additional properties based on the selected input type—such as constraints, scaling, etc., which are covered in the upcoming sections.
Last updated