Records

How AxisIQ stores your business data: record types, fields, lists, filters, CSV import and export, history and data quality.

Records are the business data you keep in AxisIQ: customers, orders, products, students, invoices, or whatever your workspace tracks. Every kind of record has its own list, its own form, and its own set of fields. You work with them the same way in every app.

A record list with the Ask Axis about these, More and New buttons above the filters

What you can do

Before you start

  • Who can use it: the Business records permission on the Roles page. Can view reads records; Can add & edit also creates, updates, imports and exports; Full control also deletes and restores records, creates record types, changes fields and runs data quality checks. A role can be limited to specific record types.
  • Records are part of every workspace. They cannot be switched off in Settings → Apps.
  • Record types come from a template or Ask Axis, or you create them yourself with New record type. Nothing needs to be set up first.

Where to find it

Open the app that owns the data from the app launcher. In the app's left rail:

  • Overview — a count for each record type and the newest records.
  • Records group — one entry per record type. Click one to open its list. The list's top bar has Ask Axis about these, More (Edit in Sheets, Import, Export, Find duplicates, Trash) and New …; above the list sit the Table / Board / Gallery / Calendar switch, the view picker and Columns. When an app holds many record types, the Records heading shows how many and can be collapsed, and a filter box appears past ten.
  • Settings — the app's data model: one tab per record type (its fields) plus a Data quality tab (problems and duplicate rules).

Key ideas

Term What it means
Record type A kind of record, such as Customer or Invoice. It has a list and a set of fields.
Record One row of a record type, such as one customer.
Field One piece of information on a record, such as Email or Total.
Base field A field that comes with a built-in record type. You can use it but not delete it.
Custom field A field your workspace added.
App A menu entry that groups record types, such as Sales or Academics.

In this section

  • Add a field — Add a custom field to a record type from the app's Settings: label, key, type, options, defaults and flags.
  • Auto-numbering — Generate invoice-style numbers on save with patterns like INV/{yyyy}/{seq:4:yearly}, with daily, monthly or yearly resets.
  • Board, gallery and calendar — Show a record list as a board grouped by stage, a gallery of cards, or a month calendar by date.
  • Edit or delete many records — Select records in a list and set one field on all of them, assign them to someone, or move them to the trash in one go.
  • Comments and mentions — Discuss a record with your team on its Comments tab: @mention teammates, attach up to 5 files, and follow the record to hear about replies.
  • Computed fields — Calculate a field from other fields with a spreadsheet-style formula that updates on every save.
  • Create a record type — Add a new kind of record — such as Vehicles or Fee invoices — from an app's settings or the launcher, then rename or delete custom record types.
  • Create and edit records — Create, edit, copy the ID of and delete records, and what the record form and its tabs show.
  • Data quality — Re-check existing records against your field rules, see which records break them, fix them one by one or in bulk in Sheets.
  • Set duplicate rules — Decide which fields make two records the same, see every duplicate in an app, and merge them in one step.
  • Edit, describe and delete fields — Read a field's settings, add a description for teammates and Ask Axis, and delete a field you no longer need.
  • Edit records in Sheets — Turn a record list into a spreadsheet, edit in bulk and push the changes back to your records.
  • Export records to CSV — Download a record type as a CSV file: columns, value formats and the 10,000-row limit.
  • Field rules — Required, unique, immutable, options, pattern, min and max, currency unit and defaults — and the messages you see when a value breaks a rule.
  • Field types — All 14 field types in AxisIQ, what each accepts, how it looks on forms and in lists.
  • Find and merge duplicate records — Spot customers, vendors or items entered twice — same email, phone, GSTIN or name — and merge them into one record without losing their links or comments.
  • Find records — Filter record lists by field, combine conditions and sort by columns. Lists the operators available for each field type.
  • Formula reference — Operators and functions available in computed fields, with examples and what is not supported.
  • Import records — Import a CSV or Excel file of up to 10,000 rows: map columns to fields, check every row before saving, add or update records and download failed rows.
  • Links and line items — Link records to each other with search-as-you-type pickers and add line items to orders and similar records.
  • Lookup and rollup fields — Show a value from a linked record, like a customer's city on every order, or count and total linked records, like a customer's orders and sales.
  • Record activity — See who created, changed or deleted a record and a before-and-after view of each field.
  • Record types and apps — What a record type is, how types are grouped into apps and launcher categories, and what you see when you open an app.
  • Saved views and columns — Choose which columns a record list shows and in what order, and save filters, sort and columns as a view for yourself or your whole team.
  • Trash and restore records — Deleted records go to a trash for 30 days. Undo a delete, restore records from the trash, or delete them forever.