build apps by user

General Properties of a Worksheet

A worksheet is the basic working unit in BAU DB. It includes an input form of record entry and views for listing of entries. Below are the general properties of a worksheet.
general properties of a worksheet

Name of a Worksheet

The first thing is to define the name of a worksheet. There are 2 names for a worksheet – internal and external name, and both names are unique in a database.
  Worksheet No.
The unique identifier of a worksheet in worksheet settings.
 Caption (Menu Page)
The display name in Menu Page. It’s also unique in the database, no 2 worksheets can use the same caption.

Let’s define the row and column position of a worksheet in Menu Page.
 Row (Menu Page)
The row position in Menu Page. It starts from zero : 0, 1, 2, …
 Column (Menu Page)
The column position in Menu Page. It starts from zero : 0, 1, 2, …
For example, a worksheet in the first row and first column in Menu Page – Row : 0, Column : 0.

Editing Mode of a Worksheet

 Form Mode
After creating a worksheet, you can release it to user for different purposes. You can let user to edit the data of a worksheet, or read the data only. You can let user to change cell’s properties or block them from doing so.
Form Mode Description
Input / Design Input means user can add/update/delete record entry in a worksheet. Design means user can change cell properties in a worksheet by clicking the top right button in a cell.
Input Only User can input data in a worksheet. There is no button in the top right of a cell, so that user cannot change the cell properties.
Read / Design Read means user can only read data in a worksheet. The  Save  button is disabled and therefore user cannot edit the data. However, user can change the cell properties.
Read Only User can only read the data in a worksheet, and cannot change the properties of cells.
Title When this option is selected, it is not a real worksheet. It’s only a display title in Menu Page. You can use titles to divide worksheets into different categories in Menu Page.

Unique Identifier of an Entry

In BAU DB, each record entry is associated with an unique identifier, likes customer must has an unique customer number, or an invoice must has an unique invoice number. Therefore, each worksheet must has a key cell that holds the unique identifier (i.e. Doc No) of record entry. The key cell is related to a key table field. Let’s define some properties about the entry identifier of a worksheet.
 Key Table.Field (Doc No)
The key table and field in the physical database for storing the Doc No. of an entry. The input format is table.field, for example in customer worksheet it can be tblCust.CustNo, with tblCust as the key table and CustNo as the key field in the table.
 Main Index
The name of an index to be created on the key table and field that help sorting the table records. Currently, the index name must be “idx”+[key field name]. For example, in customer worksheet the index is idxCustNo, and the content of index includes the key field CustNo. The index is created automatically when you press  Update DB Tables   button.
 Auto Doc No
The formula for generating a new Doc No. automatically when user saves a new entry. It is used in parallel with the keyword “AutoNumber” as default value in the key cell. Usually, automatic doc no. involves a sequence number that makes it unique. This pattern “@000@” used in the formula means the unique identifier includes a sequential number that has 3 digits. If no automatic Doc No. is needed, just leave this cell blank.

Some Visual Properties

Let’s define some visual properties of a worksheet.
 Pane Size
The default display proportion of list view (browse pane), record form (input pane) and info pane. V defines how large the list view, and H defines how large the info pane with values from 0 to 1. For example, if you want to display by default the input pane only without list view, you can define V:0;H:0.2. You can always click the top left  List/Form   button, or drag and drop the border to change the pane sizes.
Define the overall font size and font style used in the worksheet. Size defines font size, and Name defines font style. For example: Size:15;Name:Comic Sans MS. If this cell is blank, the default font and size is Calibri 11.

Document Printing

You can create Excel template files for printing the content of a worksheet. This property is related with the printing file.
 Print File
Define the prefix of template files of a worksheet. When you press the  Print  button, only the template files with the defined prefix will be shown in the file selection box. With this feature, you can separate the template files of different worksheets by using different file prefixes.

Synchronization Over the Cloud

You can share the content of a worksheet with your colleagues in different locations with the feature of synchronization. This is a feature of BAU DB Pro.
Yes means sharing the content of this worksheet; No means no sharing.

Define Use Cases of a Worksheet

This feature allows you to change the cell widths for different use cases. You can use this feature to hide some cells in different use cases. For example, you can create simple/full versions of an entry; or create different versions of an entry according to the different use cases.
 Basic/Extended Description
Define the caption of different use cases separated by slash “/”. For example, “Simple/Extended” defines 2 use cases and the captions are displayed in the top right corner in Input Pane.
 Extended Widths
It is used together with  Basic/Extended Description . It defines the cell widths of a cell from the second use cases and so on, because the cell width of the first use case is defined in  Width . Use a slash “/” to separate different widths when there are 3 or more use cases, for example “1000/0“. When it is blank, the cell width does not change in different use cases.