Promotions and EasyImport: Choosing Table Columns and Saved Views

Choose a table's fields, filter, group and sort it, save the layout as a named view, switch views, and set a default view for your whole team.

Table of contents

One table layout everywhere

The lists in Promotions and EasyImport use the same table as Products and Reports: the promotion planner, customers and stores, products, the price list, templates, exports, form requests, action items, budgets, ranging groups, store visits, the Superfood store database, converters, upload formats, converter runs and the orders desk. The title, the view and its tools sit in one toolbar, the page's main action is the button at its end, and imports and exports are in the ··· menu beside it.

Choosing fields

Fields lists every column the table offers. Tick a field to show it, drag to reorder, and drag a column edge in the table to resize it. Some useful fields ship turned off so the standard table stays clean. For example, the customers table offers Price tier, Phone and Address; the products table offers Barcode, Size and Tier 1 RRP; the price list offers Category, APN, Unit cost and a GP% column for each tier.

Views that remember everything

The Views rail on the left lists the built-in views a table ships with (such as Open stores, Missing a price, Overdue, By retailer) beside the views you save, each with the number of rows it shows. A view remembers its filter conditions, grouping, sort, visible fields, column widths, row height and whether rows are coloured by status.

  • The toolbar buttons say what is set: Filtered by Status, Grouped by 1 field, 3 hidden fields.

  • Filter opens a condition builder. Pick a field, choose "is any of" or "is none of", then click the value box. A list opens with a search box and a tick beside each value, in the same order as the rows in the table, with how many rows each value would keep. Tick as many as you need: they show as chips in the value box, and the table only changes when you press Apply. Cancel, Escape or clicking away leaves the filter as it was. Selected only narrows the list to what you ticked, and Select all and Clear work on the values listed. On a phone the list opens as a sheet from the bottom of the screen.

  • Group gathers the rows under a heading for each value, such as retailer, rep or category.

  • Any change shows an Unsaved changes bar. Save view keeps it, Save as new makes a copy, Discard goes back. Column widths save on their own.

  • Saving changes to a built-in view makes your own copy of it; deleting that copy brings the built-in back.

  • Share gives a link that opens the table on that view.

  • On a laptop the tool buttons show an icon with a count; hover for the wording. On a phone each row becomes a card.

Saving a view

  1. Set the table up the way you want it: fields, filters, grouping and sort.

  2. Choose Save as new in the Unsaved changes bar and name it ("Buying view", "Codes only").

  3. Optionally make it your default from the view's options.

A view you save is yours: only you see it, and anyone who can open the table can save their own. Your views are listed under My views. An administrator can open a view's options and choose Share with the company, which moves it to Company views for everyone to switch to, or Make private to take it back. Company views are changed, renamed and deleted by administrators only; if you change one, Save as new keeps your own copy.

How the default works

  • One view per table can be the company default, marked with a Default badge. It applies automatically for anyone opening the table fresh.

  • You can also make one of your own views your default. It opens for you only, and wins over the company default.

  • A person's own last choice on their device wins over the default, so nobody's setup is overridden by someone else saving a view.

Views saved on the old tables

A column view saved from the old Columns menu still opens on the new table, with the same fields showing. The old dropdown filters above each list are now filter conditions and built-in views, so a filter you used to pick from a dropdown is one click in the Views rail or the Filter popover.

v13.84