Create and edit records
Create, edit, copy the ID of and delete records, and what the record form and its tabs show.
Add a record, change it later, and delete it. These steps are the same for every record type in every app.
Before you start: You need the Business records permission. Can add & edit lets you create and edit records. Deleting needs Full control. If your role hides some fields, you do not see them on the form.
Create a record
- Open the app and click the record type in the Records group of the left rail, for example Customer.
- Click New customer (the button uses the type's name).

- Fill in the fields. Required fields have a
*after the label. A line of help under a field explains what goes in it. - Click Create, or press
Ctrl + Enter(⌘ Enteron a Mac).

You see Customer created and the record appears at the top of the list.
If the list is empty you see "No customers yet" and a New customer button.
What the form shows
- Built-in fields first, laid out in two columns. Long fields (long text, multi-pick lists) take a full row.
- Your own custom fields underneath. When the type also has built-in fields they sit in a section called Additional properties.
- Fields with an auto-numbering pattern or a formula are not on the New form. On an existing record they show greyed out. Formula fields have a
ƒbefore the label. - A field's description shows as help text under it.
- Default values you set on a field are filled in already. A required date-and-time field starts at the current time.
- Types with line items show a Line items section. See Links and line items.
Edit a record
- In the list, click the row. You can also use the ⋯ button at the end of the row, or right-click the row, and choose Edit.
- The dialog is titled "Edit customer". Change what you need on the Details tab.
- Click Save, or press
Ctrl + Enter(⌘ Enteron a Mac) from any field. You seeCustomer saved.
An emptied optional field is cleared on the record. A required field cannot be emptied. See Field rules.
Closing a form you have changed
If you press Esc, click outside the dialog or click the X after typing something, AxisIQ asks Discard unsaved changes? — "What you entered in this form will be lost." Click Keep editing to go back to the form, or Discard to close it without saving. Leaving or reloading the page while the form has changes also asks your browser to confirm.
Tabs on an existing record
| Tab | What it shows |
|---|---|
| Details | The form |
| Documents | PDF documents made for this record |
| Messages | Emails, SMS and WhatsApp messages sent about this record |
| Events | Calendar events linked to this record |
| Activity | Who changed what and when. See Record activity. |
The speech icon at the top right (Ask Axis about this record) closes the form and opens Ask Axis with this record as context.
Edit right in the list
The list works like a spreadsheet:
- Use the arrow keys,
HomeandEndto move between cells. - Press
EnterorF2, or double-click, to edit the cell. (A click selects a cell; a second click edits it.) - Press
Enterto save —Ctrl + Enter(⌘ Enteron a Mac) in a long-text cell — orEscto cancel. A yes/no or choice cell saves as soon as you pick. - Press
Shift + Enterto open the whole record in its form.
Each change is saved like an edit in the form, with the same rules and the same activity history. Some cells can only be changed in the form: links, multiple choice, files, hidden fields, computed and auto-numbered fields, and write-once fields that already hold a value.
Row menu
Right-click a row, or click ⋯:
- Edit
- Duplicate — opens a new record filled with this one's values. Unique, auto-numbered, computed and hidden fields are left empty, and line items are not copied. Check it and click Save.
- Copy link — a link that opens this record for anyone who can read it.
- Copy ID — copies the record's unique ID and shows
ID copied. You need the ID to put a link in a CSV file. - Delete
Delete a record
- Open the row menu and choose Delete.
- In Move this customer to the trash?, read "It is removed from every list. You can restore it from the trash for 30 days."
- Click Move to trash. You see
Customer moved to the trashwith an Undo button.
Click Undo straight away to bring the record back. Later, restore it from the type's trash. See Trash and restore. To delete many records at once, see Edit or delete many records.
The list
- The title shows the number of records in a badge.
- Columns are the type's first six fields plus Created (the date). Click Columns above the list to pick and order them. See Saved views and columns.
- Each page shows 50 records, newest first. Use the pager at the bottom.
- Tick the box at the start of a row to select it for a bulk change. See Edit or delete many records.
- To narrow or reorder the list see Find records.
Troubleshooting
<key>: required field missing or another message under the form
The form shows the first message the server refused with. Fix the field it names and click the button again. See Field rules.
a unique field already holds this value
Another record already uses that value in a unique field.
Delete failed You may not have permission to delete this record, or it was already deleted.
Records could not be loaded The list failed to load. Click Retry.
Not found — This record type doesn't exist The type was renamed or removed. Click Back to overview.