Power Tables App Overview

Power Tables

1. What it is

Power Tables lets you create typed data tables that scale to millions of rows. Each table you create is a real database table with defined column types, so sorting, filtering, and reporting run at database speed rather than in the browser. You can import data from CSV files or external URLs, set up automations that fire on row changes or on a schedule, and connect tables to Live Boards for dashboards and signage.

• Enablement: Power Tables is a pay-as-you-go app billed per 1,000 rows stored. An admin enables it from the Apps Marketplace — no separate licence decision is required.
• What it is not: Power Tables is the data layer. It does not chart or visualize data on its own — that is Live Boards’ job. A saved view in Power Tables defines which rows and columns to show; a Live Board binds to that view to render tiles, gauges, and leaderboards.

2. Standing it up

1. Go to Admin → Apps Marketplace, find Power Tables, and enable it.
2. Open Power Tables → Tables. Create your first table — give it a name, then add typed columns (Text, Number, Date, Currency, Select, and others). You can also use Create with AI: describe what you want to track and AI proposes columns for you to review before creating.
3. Grant access. By default every user who can reach the app can see every table. To restrict a table to specific people or groups, open the table’s Sharing page and switch the access mode to Restricted, then add grants. Grant levels are Viewer (read rows), Contributor (also add and edit rows), and Manager (also change columns, settings, and sharing).
4. Confirm it worked: your users should see Power Tables in the app launcher and be able to open the tables they have access to. On mobile, employees see a read-only grid at /m/power-tables.

3. How it fits together

Tables and columns — A table has a name, a description, and a set of typed columns. Each column has a type that determines what values it accepts and which filter operators are available. The twelve column types are: Text, Long text, Number, Currency, Boolean, Date, Date/time, Select (dropdown), Email, URL, User (a reference to an employee), and Attachment (a file on a row). An admin chooses one column as the display column — the value from that column names each row wherever it is referenced (notifications, boards). If none is chosen, the first text column is used automatically.

Saved views — A view is a named combination of filters, sorts, and visible columns over a table. Views come in two kinds: shared views belong to the table and are visible to everyone; personal views belong to one user and are visible only to them. Live Boards can only bind to shared views. Every new table starts with an “All rows” shared view.

Access modes — A table is either Everyone (the default — anyone with app access can see it) or Restricted (only admins plus people or groups with an explicit grant). Grants can raise a plain member to Contributor or Manager on one table without changing their app-wide role. Admins always have full access regardless of grants.

Automations — Rules that fire actions when something happens. Two trigger types exist: row events (a row is created, updated, or deleted) and schedules (daily, weekly, or at a fixed interval). A scheduled rule binds to a shared view whose filters select the rows it acts on. Available actions include sending notifications, calling webhooks, sending external emails, and requesting approvals. Rules that fail five consecutive times pause themselves automatically and notify their owner.

Forms integration — A Forms template can point at a Power Tables table. When someone submits the form, the answers land as a new row. This is one-directional and append-only — editing a submission later does not change the row.

Live Boards — Boards bind to a Power Tables saved view to render tiles, leaderboards, gauges, and grids on dashboards and Digital Signage. A board reads a view, never a raw table, so the view’s filters control what the board shows.

4. Running it

Creating and populating a table

1. Go to Power Tables → Tables and click New Table.
2. Name the table, add columns, and choose types. You can set validation rules per column (required, min/max for numbers and dates, a regex pattern for text).
3. Add rows manually from the table grid, or import from CSV. During import you map CSV columns to table columns; the app remembers the mapping for future imports.

Importing data on a schedule

1. Open a table’s Setup page and create an Import schedule.
2. Provide an HTTPS URL or connect an SFTP source through a configured integration.
3. Choose the mode: Replace (clears existing rows first — the URL is the system of record) or Append (adds rows each run).
4. Enable the schedule. It runs nightly. Status and errors appear on the Analytics page.

Exporting data on a schedule

1. On the table’s Setup page, create an Export schedule.
2. Select an SFTP connection (configured under Admin → Integrations) and a remote path.
3. Choose the format: CSV or XLSX.
4. Enable the schedule. Each run writes the table’s current rows to the destination.

Setting up automations

1. Open a table and go to the Automations tab.
2. Create a rule: pick a trigger (row event or schedule), add conditions, then add actions.
3. For a scheduled rule, bind it to a shared view — the view’s filters select which rows the rule acts on. The view must not use personal filters (the “@me” sentinel never matches for a scheduled run).

Recovering deleted rows

When rows are deleted, they are held in a recovery bin for 30 days. Open the table’s Deleted rows page to see batches grouped by the action that deleted them (single delete, bulk delete, or import replace). Restore a batch to re-insert the rows as new rows.

Reviewing activity

Each table has an Activity log showing who created, updated, or deleted rows. The app-level Analytics page shows cross-table activity, schedule health, automation health, quota usage, and inventory flags (empty tables, tables with no writes in 30 days, archived tables awaiting purge).

5. Settings

All settings are at Power Tables → Settings (admin only).

Limits

Each limit shows current usage and a utilization bar. A limit cannot be set below what is already in use.

Setting	Default	What it changes
Max tables	5	How many active tables the business can have
Max rows per table	1,000,000	Row cap per table — import and manual entry both check this
Max columns per table	25	Active columns per table
Max indexed columns per table	4	Columns with a database index for faster filtering
Max shared views per table	25	Shared saved views per table (personal views have a separate per-user cap)
Max automation rules per table	25	Automation rules per table

Limits can be raised up to a self-serve ceiling. Past that ceiling, contact MangoApps support. If MangoApps staff have raised a limit for your account, the settings page shows a note.

AI

Setting	Default	What it changes
Enable the Power Tables AI agent in Ask AI	Off	Lets Ask AI answer questions about your tables and create tables, views, and indexes on an admin’s behalf with confirmation
Enable Create-with-AI for new tables	On	Adds a “Create with AI” panel to the New Table drawer — describe what to track and AI proposes typed columns

Currency

Setting	Default	What it changes
Default currency for money columns	USD	The currency unit shown on Currency columns that don’t declare their own — appears in the grid, row form, and on Live Boards. Individual columns can override this; stored amounts are never converted.

Sample data

The settings page also offers Load Sample Data and Remove Sample Data. Sample data creates several tables with rows, saved views, Live Boards, access grants, schedules, and view alerts so every surface has something to show. Sample import and export schedules are seeded paused — nothing runs on its own.

6. More help

• Power Tables FAQ — specific setup and operating questions
• Ask AI — the assistant answers questions about Power Tables from these articles.