by Ash Nallawalla
SPM had a total of 18 "containers" to store its data. At first glance it would seem convenient to give the 15 small ones to the teams and keep the 3 big ones for SPM-wide needs. It turned out to be a little more complicated.
For instance, each team would probably want one of the Team Project Tracker templates. That left only three big containers for SPM management and, therefore, some useful templates would have nowhere to go. See the table below to visualise the offerings:
We need to ask these questions:
Minimising training, design and maintenance will be necessary, given the transient, inherent nature of SPM's volunteers. Sharing one database template among many teams is one way towards this end.
The three large databases appear to have likely homes (subject to agreement by Directors) but the remaining 15 represent a scarce resource. Only three templates for them have been identified. Close examination of the needs of teams may well refine this recommendation; for example, there might be teams with similar characteristics and needs, so they could share one 500 kB DB and others might share a different one. This may tie up one or two more DBs but it avoids building one template with dozens of fields covering everybody's needs, but most rows would have lots of blank fields, which will exhaust the 500 kB limit quickly and inefficiently.
Groups make it easy to set database access permissions for several different users at one time. After you create a group, you can use it to give many people access to a database by referring to them with one group name instead of typing each user's screen name or e-mail address.
Provisioning allows you to create QuickBase user accounts for people who have never registered with QuickBase. All you need to do is to specify the e-mail addresses of the people for whom you want to create QuickBase user accounts. These new user accounts will automatically be members of this Workgroup.
The Team Project Tracker has the following roles:
->Go back to Part 1: Executive Summary
QuickBase Part 1
QuickBase Part 2
QuickBase Part 3