This update introduces an interesting function – on screen setting of date selection list.
How to Access the Feature
You can easily call out the field setting screen by pressing the small button in the top right corner of each field cell. Inside the field setting screen, you can define a formula in the box of “Lookup Formula”, to display a list of data items in the display pane, for cell entry selection or just to display relevant data for reference purpose. And one of the most common feature that will be used is to define a calendar date list for entry selection when the entry cell is a date field.
This New Update
This update added the very convenient feature of on-screen setting of formula for displaying date list, instead of creating it from scratch. Press the “Date List >” button just under the label “Lookup Formula”, and you can find the screen for setting date list formula.
In the simplest form, just press the “Apply” button, and then press “Save” button in the field setting screen. You can now find a list of date values shown in the display pane.
You can always customize the content of the date list by changing the settings on the screen.
Use Case 1
In some applications, you may like to limit the starting date value, you can set the Smallest date values to, for example, Today + [-2] days so that the date list always starts by date value of 2 days before.
Use Case 2
In some applications, you may want to select a date value for every 7 days later, so you change the increment between date values :  days, and the displayed date list is like this:
Use Case 3
In some applications, you may want to choose the dates backward and you would like to reverse the date value order. Okay, in this case just select “Descending” for display order. Please note that in descending order, the limit of the starting value is the Largest date value, not the Smallest date value.
As a reminder, always turn Input Box to “TextCmb” for selection list. And in many cases, it will be useful to set Initial Value to “Today” for entry cell which is a date field.
After all, apart from changing the on-screen settings, you can directly edit the formula in the formula box to custom for your own need. So, do you like it? This on-screen setting demonstrates that BAU DB is very easy and simple to use as an instant database solution. You can always provide flexibility to your applications, while keeping the setting up works to be as simple as possible.
How do I Update
Simply download from the download page and install it on top of your current installation.