Documentation

Overview

Understand how Appaca stores structured records in workspace tables and how to browse them.

Data holds structured records used by your apps, such as requests, assets, vendors, inventory, or content. Every table belongs to one workspace.

A table defines the available fields. A record is one row in that table.

Create a table

Tables are created through an app chat, not on the Data page. Describe what one record represents, the fields it needs, and any fixed choices such as status values.

The Data page is read-only. Use it to check records, fields, and which apps use a table. Change records through an app or coworker.

Field types

Appaca supports six field types: string, number, boolean, array, object, and enum.

  • Use string for names, labels, identifiers, free text, and dates.
  • Use number for quantities and values you will sort or calculate with.
  • Use boolean for true-or-false state.
  • Use enum for one value from a fixed set, such as a request status. An enum field also stores its allowed values.
  • Use array for a list of values in one field.
  • Use object for a structured nested value.

Prefer the simplest type that captures the rule. A status should be an enum rather than a free-form string, and a quantity should be a number rather than a string, or the app cannot sort or total it reliably.

Browse records

  1. Open Data

    Owners and admins can open Data from the account menu.

  2. Find a table

    Use Search data to search table names, or choose Load more to continue through the list.

  3. Review its records

    Select a table to see its fields and records. Use Used by N apps to see which apps have access.

The record list includes your table fields plus:

  • ID, the last eight characters of the record’s identifier
  • Created and Updated, formatted for your locale

Records load 50 at a time, newest first. Choose Load more to continue. The page does not provide record search, sorting, editing, deletion, bulk actions, import, or export.

Who can open Data

Data is available to workspace owners and admins. Members do not see the Data link and are redirected if they navigate to it directly, though they can still use apps that read and write those records.

Tables and fields Describe table fields and fixed choices. How apps use your data Understand table access and what happens when an app is deleted. Creating an app Create an app that stores and uses workspace Data.