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.

What you can do
- Understand how data is organised — record types, apps and menu groups. Record types and apps
- Add your own kind of record — and rename or delete it later. Create a record type
- Choose the right field type — text, numbers, dates, currency, choices, links to other records. Field types
- Add and shape fields — labels, keys, defaults, required, unique, and GSTIN / PAN / IFSC / PIN code formats. Add a field · Field rules · Edit, describe and delete fields
- Show a value from a linked record, or total the linked records — a customer's city on every order, a customer's total sales. Lookup and rollup fields
- Number records automatically — INV/2026/0001 style numbers. Auto-numbering
- Calculate a value from other fields — profit, totals, flags. Computed fields · Formula reference
- Find and merge duplicates — fold the same customer entered twice into one record, and choose which fields count as the same. Find and merge duplicates · Duplicate rules
- Create, edit and delete records — in the form or right in the list, duplicate them, copy a link; including line items and links. Create and edit records · Links and line items
- Change many records at once — set a field, generate PDFs or delete a selection. Edit or delete many records
- Get deleted records back — 30 days in the trash, with Undo. Trash and restore
- Find records — filters (with and / or), linked-record and multiple-choice filters, and sorting. Find records
- Keep the list the way you like it — columns and saved views, personal or shared. Saved views and columns
- See records as a board, gallery or calendar — drag cards between stages, or see them by date. Board, gallery and calendar
- Keep your own shortcuts — pin records to your home page and see what you opened lately. Your dashboard
- Move data in and out — Import records from CSV or Excel · Export records to CSV · Edit records in Sheets
- Discuss a record — comments, @mentions, attachments and following. Comments and mentions
- See who changed what — Record activity · and who changed a type's fields: Field history
- Check old data against today's rules — by hand or every day or week — Data quality
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. |
Related
- Ask Axis can create record types and fields for you.
- Team and permissions explains roles.
- Notifications can tell your team when records change.