In the next major release of QuickBase, currently scheduled for late Spring or early Summer, we'll be introducing a feature we call Dynamic Forms. This posting will give you a few details about this new feature but keep in mind that many of the details might be different by the time we actually release it.
We're making forms dynamic by allowing each form to have an associated set of "rules". Here are a few examples of the kind of rules that will be allowed:
Every rule has 3 sections: a When section, an Additional Conditions section and an Action section.
In the When section you specify When the rule applies. Currently we anticipate the choices here being:
In the Additional Conditions section, you'll be able to specify one or more conditions that must also be true in order for the rule to apply. The choices here will probably be:
The Actions section will, of course, be the action to take when a rule applies. Here the choices will include
It's important for the application designer to understand that these rules will run in the end-user's browser. Suppose you have the following rule:
A user who brings up an edit record form and changes the Status field to Done will actually see the Date Addressed field change to today's date. But nothing is saved until the end-user saves the record. It's just the same as if he/she had typed today's date into the Date Addressed field.
Live Formulas and Lookups
Besides form rules, there's one additional new feature that will be part of dynamic forms. Any lookup or formula fields that are included on an edit form will automatically recalculate on the form when any of the fields that they depend on are changed. Today you probably don't include formula and lookup fields on your edit record forms because of the likelihood that they will show stale information.
For instance, suppose you have a formula field for Full Name which is a concatention of First Name and Last Name. If you have a form with all three fields on it, then when an end-user changes First Name or Last Name, Full Name will update. What the end-user will actually see upon changing say, First Name, is that the text for the Full Name field will appear with a strike-thru. This happens client-side (in the browser). Then the browser sends a background request to the QuickBase server, to get the updated value. When the value is received, the screen is updated and the strike-thru goes away.
Live formulas and lookup fields will just work - you won't have to do anything to enable them.
A couple of things we most likely are not doing for this release:
Let us know what you think. While we can't promise that we'll be able to incorporate every suggestion into version 1, your comments are very important for helping us determine the direction we go with this powerful new extension to QuickBase functionality.