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:
Adding New Columns:
PowerTable allows you to add and work with columns with the following data types:
Database Columns
Number
The number field type is intended to hold numerical values such as the number of stocks available, employee salaries, and so on.
Text
The text field type can hold variable-length string of characters, including letters, numbers, and special symbols. Examples include product or employee names, their details or descriptions, etc.
Options - Single select
A single select field is ideal when you want to be able to select a single option from a preset list of options.
Checkbox
A checkbox field is useful to indicate true/false values or a toggle within a record.
Image
An image field allows you to store a single image URL for each record and display a miniature of the image in each cell.
Person
A Person field type allows you to store a single user's email address in each cell, either as the person's name or email ID. When you click on this type of cell, you will see a drop-down list of all users in your organization's Microsoft Entra ID.
URL
A URL field is intended to store a single URL in each cell. Clicking on a URL takes you to that URL.
An email field is intended to store a single email address in each cell.
Phone number
A phone number field allows you to save phone numbers for each record. A leading +, spaces, parentheses, and numbers 0–9 up to 15 digits are supported.
Currency
A currency field is a specific type of number field that formats the number as a currency amount. When you select 'Currency' as the input type for the number field and 'US Dollar' as the currency type, 3000.5 will be formatted as $3,000.5. All global currencies are supported.
Rating
The rating field is a number-type field that can be used for whole numbers (INT). It allows you to assign ratings to your records for ranking or quality assessment purposes. Three different style formats are available for indicating ratings.
Multiple select
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.
Button
The button field adds interactivity to your record, such as opening a URL or executing an automation. Create clickable buttons to open a URL or execute a defined action.
Date & Time
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.
Formula
Formulas allow you to compute a value in each record based on other cells in that same record.
Lookup
A lookup field allows you to look up a specific field in a linked record.
Percent
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%.
Decimal
Date Time
Date
Image
Person
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.
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