Skip to content

Setting up tiles

Search Dynamic FactBoxes to see every tile. FactBox Pages (an action on the list and the card) shows each page that has the FactBox and how many tiles it shows; pick a page and choose Tiles to work page by page.

Admins can also go straight from a FactBox to its setup: … → Set Up This FactBox.

  1. On Dynamic FactBoxes, choose New.

  2. General: Code, Description (the tile caption), Enabled and Sort Order.

  3. Show On: add one or more pages, for example Customer Card and Customer List. The lookup lists every page that has the FactBox.

  4. Measure: pick one, or choose New Measure. A new measure is created as Per Record, with its Record Table set to the table of the first Show On page, and opens so you can finish it:

    • set the Source Table and Aggregation;
    • write a filter using {Rec.FieldName} for the record on screen, for example Document Type=Order;Sell-to Customer No.={Rec.No.}.

    The lookup offers just the measures that suit the tile’s pages, so the right choice is always easy.

  5. Presentation: Decimal Places, Prefix, Suffix, Multiplier, Color and Tile Width.

  6. Change Colour (optional): Change Colour When Value Is, Threshold and Condition Color. For example, Above 0 in red turns an Overdue tile red whenever the customer has an overdue balance.

  7. Audience: Everyone, or Specific users.

  8. Check it with Preview Value and Show Records. Both use the first record of the first Show On page’s table.

  • A Per Record measure must suit every page the tile is on. Customer Card and Customer List both show customers, so one measure works on both.
  • A Standard measure works on any page, but shows the same value on every record. That’s useful for something like My overdue tasks in the corner of every page.
Page Source Table (Record Table) Aggregation Filter
Customer Card Sales Header (Customer) Count Document Type=Order;Sell-to Customer No.={Rec.No.}
Customer Card Cust. Ledger Entry (Customer) Sum of Remaining Amount Customer No.={Rec.No.};Open=Yes;Due Date=..{TODAY-1D}
Item Card Purchase Line (Item) Sum of Outstanding Quantity Type=Item;No.={Rec.No.}
Sales Order Sales Header (Sales Header) Count Document Type=Order;Sell-to Customer No.={Rec.Sell-to Customer No.};No.=<>{Rec.No.}
Vendor Card Purch. Inv. Header (Vendor) Count Buy-from Vendor No.={Rec.No.};Posting Date={TODAY-1Y}..{TODAY}

If a tile’s value can’t be worked out, for example because the user has no access to that data, the tile shows a grey - instead of interrupting their work. Clicking it explains why.

Values are refreshed as the user moves between records. Counts and totals run as a single database query, so tiles keep up even on busy pages with large ledgers behind them.

Use Set Up Dynamic FactBoxes. See Copying setup between companies.