Smart Columns

Updated April 30, 2026
Build Your System

In a regular spreadsheet, every cell is the same, a blank box waiting for someone to type something in. Smart Columns are different. Each column type understands the kind of data it holds and does something useful with it: validating entries, enforcing rules, connecting to other records, triggering workflows, or running entire business processes. Choose the right column type for the job and it handles the rest.

Smart Columns are organized into three categories based on what they do. Standard columns store and organize your core data. Interactive columns let users take action directly from a row. App columns embed complete business processes like payments or approvals into a single cell.

Types of Smart Columns

Standard Columns

The foundation of any dataset. Use these to capture, organize, and relate the everyday data your business runs on: names, numbers, dates, files, and people. Get these right and everything else builds on top of them.

Text

Free-form text for names and labels. Set a character limit to keep entries consistent, and enable multiline display for longer content.

Number

Stores numeric values — prices, quantities, scores, measurements. Set a minimum and maximum to prevent out-of-range entries.

Image

Upload one or more images. Set a size limit, restrict formats, and optionally show a thumbnail preview directly in the grid.

Team members

Assign people from your organization to a row. Filter by all org members or a custom list. Allow multiple assignees and choose how they appear — show a name, email, department, or combine fields. Display assignees as chips for a cleaner look.

Look-up

Reference records from another dataset in your current one. For example, bring in a Customer Name from your Customers dataset into your Orders dataset — keeping your data connected without duplication. Allow multiple references per row, add new records within the lookup, choose which columns to display, and control how the referenced values appear.

Email

Stores an email address with built-in format validation. Optionally display an email icon next to the value.

Options

A list of choices like a status, category, or tag. Select one or multiple values, displayed as colored chips or plain text. Keep the list static or pull options live from another dataset, and use filter logic to show or hide options based on other row values.

Date

Store a date or date range for deadlines, schedules, and timelines. Restrict selectable dates to a fixed calendar range (absolute) or a rolling window offset from a reference point like start or end date — for example, 3 days ahead or behind (relative). Choose your preferred date format.

DateTime (with timezone)

Store a date and time together for events, timestamps, and scheduling across regions. Restrict selectable dates to a fixed calendar range (absolute) or a rolling window offset from a reference point like start or end date — for example, 3 days ahead or behind (relative). Includes full timezone support — set a default timezone, apply it across all rows, or use your organization's timezone. Customize how the date and time are formatted.

Time

Store a time value with or without AM/PM. Enable time boundaries to restrict which times can be selected useful for business hours or booking windows.

URL

Store a web link. Make it clickable and choose how it opens in a dialog, same tab or a new tab. Display it as a plain URL, an embedded page, or a button.

ID

Auto-generates a unique identifier for every row. Choose alphanumeric or numeric, add a prefix like INV- or ORD-, and set the length between 6 and 32 characters.

Boolean

A simple on/off toggle. Rename the true and false labels to fit your context — "Paid / Unpaid", "Active / Inactive", or anything else.

Phone number

Stores a phone number with country code support. Set a default country so users don't have to select it every time.

Created At

Automatically records the date and time a row was created. Add multiple columns to display the same timestamp in different formats.

Created By

Automatically records who created the row. Display the creator's name or email, and show them as a chip for a cleaner look.

Color

Store a color value per row. Choose from organization colors, neutral, preset, or custom palettes. Set the default color format (RGB, HEX, HSL) and optionally show opacity.

State

Track where a record is in your workflow. Define states like Draft, Sent, or Approved, and control which transitions are allowed — so users can only move a record forward in the right order. Set a default state when a row is created, define start and end states, and add logic to each transition to conditionally show or hide options.

Interactive Columns

Interactive columns let users take action directly from a row. Trigger automations, track time, annotate with a whiteboard, or subscribe to updates — without leaving your dataset.

Available Interactive Columns:

Time Tracker

Track time spent on a row. Start and stop the timer directly from the table — each session is recorded with a timestamp. Enable multiple row tracking to run timers across different rows at the same time.

Button

A clickable button that triggers an automation when pressed. Customize the button label, connect it to an automation and use conditional state to enable or disable the button based on row values

Whiteboard

An interactive whiteboard for each row. Click the pen icon to open a full Excalidraw canvas — sketch, diagram, or annotate directly within the row.

Markdown

A rich text editor for long-form notes and documentation. Use headings, quotes, media and more to structure your content. Type / to access formatting blocks quickly.

Watch

Let users subscribe to a row and get notified by email when anything changes. Click Watch to start following a record or Watching to manage and unsubscribe. Filter who can watch across all organization members or a custom list, and optionally allow users to add other watchers.

Lock

Lock a row to prevent edits. Define who can lock and unlock, choose which columns remain editable even when locked, and set conditions to control when the lock button is active. Optionally allow the person who locked the row to unlock it themselves.

AI Prompt

Run an AI prompt for each row and display the output directly in your table. Choose the output type, select your AI provider and model, reference column values in your prompt using @, and use your own API key or Proma's free credits.

App Columns

App columns embed complete business processes into a single cell. Handle payments, approvals, bookings, inventory, and more — no external tools or custom development needed.

Available App Columns:

Approval

A built-in approve and reject button lets designated approvers act with a single click, with status, approver, and timestamp all tracked automatically. Define who can approve across all organization members or a custom list, and set conditions that must be met before the buttons become active. Add multiple approval columns for multi-step sign-offs, where each stage unlocks only after the previous one is approved.

Payment

Initiate and track payments directly from a row. Choose to receive or send money, connect your payment provider, set the payment mode, and configure the amount, currency, and currency format using static values or column values from the row. Control when the payment button becomes active using conditions. Learn more about Payment column settings here.

Cart

An interactive shopping cart for each row, letting you select items and quantities from a linked product dataset. Map the name, price, image, and description columns, add variants and dimensions, apply discounts per item or on the entire cart, limit quantities, allow restocking and back orders, and control what's visible. Learn more about Cart column settings here.

File

Attach files to a row. Set a size limit in MB, choose which file formats are accepted, and allow multiple uploads per row.

Task List

A checklist of tasks within a row. Add multiple tasks, each with its own status. Keep track of to-dos without needing a separate table.

Checklist

A fixed checklist of items shared across rows. Track completion as a percentage or fraction, and optionally show a progress bar. Use the same checklist for all rows or customize per row.

Minisheet

An embedded spreadsheet within a row. Build custom tables, run formulas, and calculate freely without pre-defining columns for cost breakdowns, estimates, or any freeform tabular data

API

Fetch and display data from an external API directly within a row. Configure the request method, URL, authentication, and parameters, reference column values to make each call dynamic. Map the response fields you want to display as columns in your table, keeping external data in sync without leaving your dataset.

Keys

Securely reference API keys and credentials stored in your organization settings directly from a row. Select the provider and choose which key to use, keeping sensitive credentials out of your dataset while making them available for automations and integrations.

PDF generation

Generate a PDF directly from a row. Build your template using the built-in editor, type / to access formatting blocks, pull in column values using @, and preview before generating. Or use a custom card design template for more advanced layouts, learn more about Designer. Once generated, open, download, or regenerate the PDF anytime.

Address

Store a full address with autocomplete. Start typing and select from suggestions without manual entry. Choose which fields to display (address lines, city, state, postal code, country) and how the address appears, as comma separated values or split across different columns.

Booking

Schedule and manage appointments directly from a row. Set resources, slot duration, and button labels for booking, completion, and cancellation. Once booked, an appointment summary is generated with the date, time, and assigned resource — with options to add to Google, Apple, or other calendars, and change or cancel anytime.

Grid Booking

Book specific cells on a grid layout — ideal for seating, floor plans, or any space-based reservations. Define grid dimensions, label rows and columns, set the booking mode, and manage the grid layout. Button labels for booking, completion, and cancellation are fully customizable.

Inventory

Track stock levels for each row. Add, remove, or log incoming stock, and view quantities across available, on hand, reserved, allocated, and incoming states. Full transaction history included. Learn more about Inventory column settings here.

Common Settings

Required — make the field mandatory on all new records.

Set Ongoing Validation Logic — runs a validation rule every time the value changes.

Set Insert Validation Logic — runs a validation rule only when a new record is created.

Calculate Value — define a formula that auto-populates this field based on other columns.

Action Logics — attach logic that triggers when this column's value changes.

Enable Column Value Tracking — logs a history of every change made to this field.

Show QR Code / Barcode — display the value as a scannable QR code or barcode.

5-Minute Quick Start

Try This Now Transform your dataset in under 5 minutes with these three Smart Columns:

  1. Add an Options column named "Status"

    • Set options: Not Started (gray), In Progress (yellow), Complete (green)

    • Scan your board in seconds and know exactly where everything stands.

  2. Add a Team Members column named "Owner"

    • Enable "Required" to prevent orphaned tasks

    • See workload distribution at a glance

  3. Add a Date/Time column named "Due Date"

    • Set deadlines and track what's coming up.

    • Never miss a deadline again

Result: You've just built a basic task management system that's more powerful than most dedicated tools!

Next Steps

Master Proma's complete feature set by exploring these related capabilities:

  • Automation Engine - Connect column changes to complex multi-step workflows that orchestrate your entire business process

  • Logic Builder - Create sophisticated conditional logic and calculations that power Smart Columns' intelligent behavior

  • Interfaces - Transform your column data into kanban boards, calendars, galleries, and custom visualizations

Have questions? Our team is ready to help at support@proma.ai