build apps by user

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
basically a db worksheet is divided into 3 components.
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.
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.
each worksheet is ready with single and multiple occurrence fields.
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:
enter multi line of data in multiple value cells.

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”:
change the field captions of the worksheet
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.
change caption in the field setting page
change caption in the field setting of customer

Entering Pictures and Files

Apart from entering text data, you could also enter picture or file in a cell:
displaying picture in the worksheet
Just change the Input Box in Cell Setting Screen to “File“:
change input box of cell setting
change input box of cell setting
After that, you can select file in the cell. Press the “” button to pop out a file selection screen to choose the picture file:
select file in a cell
select pic file in a cell
You could pop out the picture from the Info Pane by pressing the “^” button.
pop out the picicture
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.
select and open the document file including Excel

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.