Create An Application in A Click – Part 2
What’s inside a Ready-to-use Worksheet
Each new worksheet is ready with the basic components of a database application, and let you start works immediately. These components includes:
- a searchable List View (or Browse Pane) for displaying multiple record entries
- a Record Form (or Input Pane) for displaying and entering the data content of a record entry
- an Info Pane for displaying input selection list or information related to a specific cell
Key Cell
Each entry has a Key Cell in the worksheet, which acts as the identifier of a record entry. Each value of Key Cell must be unique. As an example, in an Invoice worksheet, Invoice Number is the key value of an Invoice entry, while Customer Number is the key value in an Customer worksheet. In the record form of a default worksheet, the top left cell “DocNo” is the key cell of the entry.
Each entry has a Key Cell in the worksheet, which acts as the identifier of a record entry. Each value of Key Cell must be unique. As an example, in an Invoice worksheet, Invoice Number is the key value of an Invoice entry, while Customer Number is the key value in an Customer worksheet. In the record form of a default worksheet, the top left cell “DocNo” is the key cell of the entry.
Single/Multiple Value Cells
An record form is also ready with single occurrence cells (or fields) and multiple occurrence cells. In the example of invoice worksheet, there is only one customer in an invoice entry and therefore customer name and telephone number etc are single occurrence cells; while there are multiple product or service items in an invoice entry and therefore item name, item price and quantity etc are multiple occurrence cells.
An record form is also ready with single occurrence cells (or fields) and multiple occurrence cells. In the example of invoice worksheet, there is only one customer in an invoice entry and therefore customer name and telephone number etc are single occurrence cells; while there are multiple product or service items in an invoice entry and therefore item name, item price and quantity etc are multiple occurrence cells.
You can enter more than one row of data in multiple occurrence cells. Use the buttons on the right hand side to insert or remove row:
Change the Cell Captions, That’s It
In many use cases, what you have to do is to organize lists of data records. Simply adding cell titles of the data that you want to manage, and that’s what you need to do before entering data of your work. In the below picture, since “Invoice No.” is the key of the entry, it is placed in the key cell “DocNo”:
To change a cell caption, mouse over a cell and a small button “..” pops out. Click the button to pop out the Cell Setting Screen, change the cell caption and click “Save” button.
Entering Pictures and Files
Apart from entering text data, you could also enter picture or file in a cell:
Just change the Input Box in Cell Setting Screen to “File“:
After that, you can select file in the cell. Press the “：” button to pop out a file selection screen to choose the picture file:
You could pop out the picture from the Info Pane by pressing the “^” button.
BAU DB only saves the path of the file. You could also enter any type of document file in the cell, and press the “^” button to open the file in its own program.
The above examples demonstrated that BAU DB allows you to go into data work immediately without the need to build anything. It is always convenient to get yourself running first, and add what you need on the go later.