Lists and columns
Copy for AI
Every module opens on a list — accounts, quotations, invoices and the rest. Use this page to find records in any of them; the lists all work the same way, as part of the workspace.
Before you start
Section titled “Before you start”You need List on the module to see its list and to open List Column Setting. Setting up columns just for yourself needs nothing more. Changing them For everyone also needs System Edit.
- Search. Type in the search box above the list; the list narrows as you type.
- Filter. Select Filters, choose the conditions — a status, a date range, a person — and select Apply filters. Each condition shows as a tag above the list; remove one with its ×, or select Clear filters to remove them all (it empties the search box too). On a computer, some lists also show up to three filters directly in the toolbar; those apply as soon as you change them.
- Sort. Select a column heading to sort by it; select it again to reverse the order.
- Page. Use the page controls under the list, and choose 20, 50, 100 or 200 rows a page.
- Set up the columns. Select the List Column Setting button — the icon at the far right of the toolbar above the list — to open the List Column Setting drawer. It is not offered on a phone.
- Choose Just me or For everyone at the top.
- On Columns, tick the columns to show under Available; they move to Your columns, and Always shown lists the columns that stay. Use the arrows to reorder, type a new heading, and choose a width: Auto, Narrow, Medium or Wide. Tick Keep the first column visible when scrolling sideways if you want it.
- On Filters, where the list has the tab, choose what the Filters box asks for.
- Select Done when you have finished.
What happens next
Section titled “What happens next”Every change is saved as you make it, and the list behind the drawer shows it at once; Done only closes the drawer, so there is no Save changes button. Just me changes only your own view — Only you see this list this way. Your company’s settings are left as they are. For everyone changes the company’s default — Everyone in your company sees this list this way, unless they have set up their own. — and anyone who has set up their own view keeps it. To undo, select Reset to the company default under Just me, or Reset to the standard columns under For everyone.
Rules to know
Section titled “Rules to know”- When nothing matches, the list says whether your search or your filter excluded everything, and offers Clear search or Clear filters.
- Column setup is on the Accounts, Contacts, Quotations, Invoices, Credit notes, Opportunities, Products and User accounts lists. The Filters tab appears only on lists whose filters you can choose; the last four have a Columns tab only. Purchase orders has them too. Leads and Delivery orders have fixed columns.
- Someone without System Edit sees no Just me / For everyone choice, only These settings apply to you only.
- While the window is narrower than 1100 pixels, the Invoices list hides its optional columns, even ticked ones; they come back when the window is wider.
- Many lists let you tick rows and act on them together. On Accounts, Contacts, Opportunities, Quotations and Products, ticked records can have their owner changed or be deleted together — see Export and bulk actions. On Invoices, tick several invoices and select Record payment to record one receipt for them — see Record a payment. On Delivery orders, ticked orders can be marked delivered or turned into one invoice — see Delivery orders.
- Accounts, Contacts, Opportunities, Quotations, Invoices, Credit notes and Products have Export to Excel in the ··· menu, for roles with Export lists to Excel — see Export and bulk actions. Invoices also offers Payment differences (CSV) and the Bad-debt register, which has Download CSV, to roles with Invoice View at All records, and Export for accounting software…, which opens Accounting export.
Why it works this way
Section titled “Why it works this way”Two layers keep the company’s default steady. An administrator sets the columns everyone starts with; your own Just me view changes nothing for colleagues, and a later change to the company default does not overwrite the view you built for yourself.
Changes save as you make them. You see the effect on the list behind the drawer straight away, and there is no forgotten Save to lose a careful set-up.
The whole list is searched, not just the page you see. Search, filters and sorting run on every record your role may list, and only the page you are looking at is loaded. A list of thousands of invoices opens as quickly as a list of twenty, and the first row after sorting really is the first.
A list shows only what your role allows. With Own records only, a list holds just your own records, so its rows and totals are yours, never a colleague’s — see Ownership and visibility.
Work faster
Section titled “Work faster”- Use a date preset. A date-range filter offers This month, Last month, This quarter, This year and Last 30 days, so a month-end review needs no typing.
- Make your own fields searchable. In System settings → Custom fields, tick Searchable or Filterable on a field to reach it from the list’s search box or Filters. See Custom fields.
- Open records in new tabs. Ctrl-click (⌘-click on a Mac) or middle-click a record’s name to open it in a new browser tab and keep your place in the list.
- Review in bigger pages. Choose 200 rows a page when you check a long list, and the column headings stay at the top as you scroll down.
- Keep the first column in view. Keep the first column visible when scrolling sideways holds the record’s number or name on screen while you read across a wide list.
- Act on several records at once. Tick rows to change their owner or delete them together, or on Invoices to record one payment for several. See Export and bulk actions and Record a payment.
Examples
Section titled “Examples”Chasing last month’s invoices. On 3 November Daniel Lim opens Invoices on his computer. The status filter in the toolbar already shows Unpaid and Partial Paid. He selects Filters, picks Last month for the due date and selects Apply filters, and a tag for the due date appears above the list. He sorts by the due date, oldest first, and works down the list; when he is done he removes the tag with its ×. See Get paid faster.
A view of her own. Mei Tan wants to see who prepared each quotation. On Quotations she opens List Column Setting, keeps Just me, ticks Sales Name and Created Date, and sets Sales Name to Narrow. The list changes behind the drawer as she works; she selects Done. Her colleagues’ lists are unchanged.
A company default. Daniel, who has System Edit, opens List Column Setting on Contacts, chooses For everyone and ticks Mobile, so the team can call a contact straight from the list. Everyone who has not set up their own view of Contacts now sees the column; anyone with their own Just me view keeps it as they left it.
Common questions
Section titled “Common questions”- How do I export a list to Excel? Open the list, set its filters and columns, and select ··· → Export to Excel. Your role needs Export lists to Excel — see Export and bulk actions.
- Can I save my columns and filters? Your columns, their order, headings and widths, and the conditions the Filters box offers, are saved as you change them in List Column Setting. Use Just me for yourself, or For everyone with System Edit.
- Why don’t I see For everyone? Changing the company’s view needs System Edit. Without it, your changes apply to you only.
- How do I put a list back to how it was? In List Column Setting, select Reset to the company default under Just me, or Reset to the standard columns under For everyone.
- Why are some invoice columns missing on my laptop? The Invoices list hides its optional columns while the window is narrower than 1100 pixels. Widen the window to 1100 pixels or more.
- Can I select several records and update them together? On Accounts, Contacts, Opportunities, Quotations and Products you can change the owner of, or delete, up to 200 ticked records. On Invoices you can record one payment for several invoices, and on Delivery orders you can mark several delivered or invoice them together.
- Why can’t my search find a value I typed into a custom field? The field is not switched on for search. An administrator can tick Searchable on it under System settings → Custom fields.