Bitta Sheets · Part 20 · 2:25 · YouTube
Business Central Data Entry: Drop-Downs, Checkboxes, Validation
What this video covers
Add checkboxes, drop-down lists and date pickers to a Business Central sheet, set input rules, and highlight what matters.
In this tutorial you add an Approved checkbox, a Status drop-down and an Effective date picker to a chair price sheet, make the Change % column accept only numbers between 0 and 20, and use conditional formatting to flag low profit, show data bars and color scales.
Transcript
Monday's approvals need clean input: a tick, a status and a date. Here's how to add checkboxes, drop-down lists, date pickers, input rules and highlights to a Business Central sheet.
Add a control to each cell. Set a rule for what's allowed. Then let color point out what matters. On the Insert tab, Cell Controls adds a checkbox to every selected cell.
One click ticks it, and a ticked box stores 1. Drop-down List opens the rule panel. Type the choices: Approved, Review and Rejected. Advance options set how the list looks, and whether a wrong entry is only
flagged or rejected. Now every cell has its own list. Pick a status from the list. Date Picker adds a calendar.
Double-click a cell, pick the day, and OK writes it in. On the Data tab, Data Validation holds the same controls, plus rules of your own. New Rule: Change % must be a number between 0 and 20.
Under Advance options, Reject input refuses anything else. Done, and the panel lists every rule on this sheet. Type 30, and the sheet says no. The old value stays.
On the Home tab, Conditional Formatting colors cells by their values. Highlight Cells Rules: a profit below 26 percent stands out. Data Bars show each price at a glance, and Color Scales shade each change by its size.
Top/Bottom Rules and Icon Sets work the same way, and Manage Rules lists every rule, ready to edit or clear. Use them wherever people type into a shared sheet: approvals, price reviews or order requests.
To stop others from changing a workbook, share it with View access. That's tutorial 17. Next, journal and document lines. The steps are in the Bitta Sheets guide.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping