Creating a progress bar
In this section, you will learn how you can use the formula property to roll up a rollup property and how you can use various formula options to create a variety of outputs using the nested formula and property substitution techniques.
When using the rollup property in a database, it can do calculations on any property type except a rollup property itself. This means that if you want to roll up a rollup property, you need to have a dynamic copy of that rollup property so that when the information is changed, it changes the calculation automatically.
Three-database setup
The example given in Figure 9.6 shows three databases: a Tasks database, a Projects database, and a Person database.
Figure 9.6 – A three-database setup with a roll up of a rollup being done in the Person database
The Tasks database has a Done property, which is checked when a task is completed. The Task 1 and Task 2 pages are related to the appropriate...
