Skip to content
Bitta Apps

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

Next step

See Bitta Sheets on your own data