A table defines the fields available on each record. Appaca creates tables from what you request in an app chat.
How a table gets created
-
Describe one record
Say what one row represents, such as one expense claim or one customer request.
-
Name the fields
Include each value you need and whether it is text, a number, a yes-or-no value, a list, or a fixed set of choices.
-
Review the table
Open Data, select the table, and confirm its columns before relying on it for live work.
The six field types
| Type | Use it for |
|---|---|
string | Names, labels, identifiers, text, email addresses, and dates |
number | Quantities, amounts, and counts |
boolean | A true-or-false value |
enum | One value from a fixed set |
array | A list of values |
object | A structured group of values |
There is no dedicated date field type. Tell Appaca which date format you want and use it consistently.
Getting the table you want
Be specific about the values you need:
Track expense claims. Each row is one claim with a description, an amount in dollars, the submitting employee’s email, a submitted date, a status of Draft, Submitted, Approved, or Rejected, and a flag for whether it has been reimbursed.
This makes the amount a number, the status a fixed set of choices, and reimbursed a yes-or-no value.
Changing fields later
Schema changes can add fields. Existing fields cannot be renamed, removed, or changed to another type. If a field is wrong, ask the app to add the correct field or create a new table.
Adding a field does not fill it on existing records. Decide what the new field should contain for older rows.
What a record looks like
The Data page shows your fields alongside ID, Created, and Updated. Appaca manages these three values automatically.