Skip to content
Bitta Apps

Chapter 2 of 4Page 2 of 12

Workbooks

Live table editing

Put 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.

updated: applies-to: 1.0.0.0

Change Business Central records the way you change a spreadsheet: put a table in a sheet, type your changes, check them with Business Central's own validation, then apply them. Every change is logged.

Put a table in a sheet

  1. In a workbook, open the Insert tab and choose Data table.
  2. Choose the table, for example Customer, and pick only the columns you need.
  3. Under Filters, add a filter in Business Central syntax, for example No. 10000..50000, so the sheet fetches just those records.
  4. Select Allow changes to be written back to Business Central (after a review), then choose Insert.
Insert data table dialog on the Customer table with a No. filter and Allow changes to be written back selected

The records arrive live from Business Central. Columns you can change show a pencil in the header, and the table's title bar shows Writes back.

NOTE

Write-back also needs Allow Write-Back in Studio Setup, Edit access to the workbook, the same company as the data, and permission to modify the table. Key fields, FlowFields and columns from related tables stay read-only.

Type your changes

Type a new value, paste one, or enter a formula in a pencil column, and fill it down a column as in any spreadsheet. The result of a formula is what gets written. Each edit is held as a pending change, and Business Central is not touched yet.

Review and check

  1. On the Home tab, choose Review changes. The panel lists every change with the old value and the new one. Undo this change removes one.
  2. Choose Check changes. Each record runs Business Central's own validation and is then rolled back, so nothing is saved. The panel shows how Business Central stores each value and what else would change with it.
Customer data table with four pending changes and the Review changes panel after Check changes, 4 ok and 0 with errors

Apply the changes

Choose Apply. Bitta Sheets writes one record at a time and the table refreshes from Business Central. A record that fails is rolled back on its own, and the rest are still written.

If someone changed a value after you loaded it, that change is refused with "Changed by someone else". Refresh the data table and type it again.

Every change is logged

Each apply is one entry in the Studio Audit Log, with the action type Sheet Write-Back. Field Changes shows the table, the record, the field, the old value, the new value, when it changed and who changed it.

Studio Audit Field Changes listing the old and new credit limits and payment terms written from the sheet

Protected tables refuse write-back unless you have GodMode in Bitta Apps Studio.

When to use it

Use it when records need a change today: credit limits, payment terms, prices or contact details. To change hundreds of rows at once, type a formula once and fill it down: see Bulk changes with a formula.

What's next

Change many records at once with a formula.

Next step

Ready to try Bitta Sheets?