Skip to content
Bitta Apps

Chapter 2 of 4

Workbooks

Create workbooks, insert live data from Business Central, and keep them refreshed.

In this chapter

  1. 01Workbooks and live dataCreate workbooks in Business Central or import them from Excel, organize them in folders, then insert live data tables, reports and charts and refresh them.
  2. 02Live table editingPut a Business Central table in a sheet, type changes in the pencil columns, check them with Business Central validation, then apply them with an audit log.
  3. 03Bulk changes with a formulaChange many Business Central records at once: fill one formula down a data table, let Business Central check every row, then apply the changes that pass.
  4. 04Spreadsheet essentialsFormat, sort, filter, find and replace in a Bitta Sheets workbook, with Business Central number formats, frozen headers, zoom, full screen and shortcuts.
  5. 05Pivot tables on live dataSummarize any Business Central table in a pivot table: rows, columns and values with totals, quarters, top N with Others, and a drill-down on every number.
  6. 06Charts and KPI cardsAdd charts and KPI cards to a Business Central workbook: chart live data or cells, click a column to drill down, and show a KPI as progress to its target.
  7. 07Cell controls and input rulesAdd checkboxes, drop-down lists and date pickers to a Business Central sheet, set rules for what people type, and highlight values with conditional formatting.
  8. 08Document and journal linesEdit the lines of Business Central sales and purchase documents and general journals in a sheet: change, add and delete lines, checked like the page.
  9. 09Organize workbooks and sheetsOrganize Business Central workbooks in Bitta Sheets with folders, views, favorites and properties, and insert, rename, color, hide or delete sheets.
  10. 10BC functions and filtersBuild a Business Central month-end pack in Bitta Sheets with live BC functions, one month filter, a data table that follows it, and a refresh.
  11. 11Series, queries and report dataBring more Business Central data into a sheet with Bitta Sheets: date and FlowField series, a query result, and a report dataset with its request page.
  12. 12Connected tables and SQLJoin related Business Central tables in a sheet without SQL, run SELECT queries with cell parameters, and put SQL and AL formulas in a single cell.

next step

Want help rolling out Bitta Sheets?