QuickBase Performance
Thursday, June 10th, 2010 |
So, for maximum weekday performance, it seems that you’d be best off fitting your work in when you’d ordinarily be eating breakfast or dinner.
 |
Archive for the ‘Articles’ Category
More QuickBase Best Practices
Thursday, June 10th, 2010
But the list of users has only two fields - the user name and role. In many cases, you need to keep track of more information about your users - like what location they work at, what team they are on, or what projects they are working on. When Quickbase has information like that, then it can be told what data the user is authorized to see, and what data should be on the user’s dashboard.
If all the users from any role in your application see the same data all the time, then you don’t need a table of users — the QuickBase list of users will do you fine.
But if you need to slice permissions a little more finely, a table of users is where you need to start. The way you use this table to set up permissions and dashboards will depend on your specific needs. But here is a simple example:
Don’t Mess with Key Fields
In QuickBase, the key field starts out being the Record ID#, and it is usually best not to change it.
Why? Well, let’s say you have a table of Basketball Teams, and you set the key field to the Team Name. Why not? you think. Every team name is unique. But then the Washington Bullets change their name to the Washington Wizards. Because of the way relationships work in QuickBase, all the players who were listed as on the Bullets are not on your team anymore!
Names can always change, but Record IDs do not, so unless you know what you’re doing, don’t change the key field!
(PS - one exception to this is with the Users table above — in that case, the User field in that table is a good key field.)
Happy clicking —
QuickBase Best Practices, Part I
Sunday, January 24th, 2010So as a public service, we’d like to give you a few guidelines for putting together your QuickBase. If you can put these into practice, then when the time comes to work with a consultant, we promise you’ll hear some nice comments on the other end of the phone - “Nice job, you really know what you’re doing!”
I know you’re busy so we will keep this brief — a few here and then a few more next issue.
Most of a database’s power, and most of its complexity, is in the relationships between tables. If your application has one table in it, that is a clear sign that you are missing out on the jelly in the QuickBase doughnut. Relationships are important!
You need to learn how QuickBase deals with relationships, but even before that, you need to see why relationships are important. A good starting point is the article here. This is specifically about MS Access, but the article is still good for QuickBase users and it is way easier to understand than the Wikipedia article!
In most cases, it’s best to keep your company’s work in a single QuickBase application. That’s because tables often relate to each other. For example, if you have one application for Order Entry and another for Customer Satisfaction, they are both going to use your Customer List, your Employee List, and probably other tables too. You don’t want to have two Customer lists so that means that one application will need to hold the Customer list, and the other will have to use a cross-application relationship to see it. Cross-application relationships are OK, but they have some limits. Better to keep it all in one application.
Of course, there are exceptions to this. If your applications are owned by different people, or they just get big and un-manageable, it’s best to separate them. But don’t do it unless you have a good reason.
3. Know what you’re doing with Proxy Fields
Almost every time you set up a relationship in QuickBase, a “proxy field” is created. That’s so when you pick a parent record, you see a dropdown that is meaningful to you.
For example, if you have a relationship between Projects and Customers (one Customer to many Projects), the real relationship is between the Project and the Customer’s Number. But a Customer Number (1,2,3) is probably meaningless to you. What you really want to see is the Customer Name. So in a case like this, you want the Customer Name to be a proxy field in the relationship.
The Infamous Proxy Field - Should it be banned?
At Data Collaborative, our general practice is not to use Proxy Fields. But we are QuickBase geeks - we eat and breathe this stuff. Our advice to you is this: pick one strategy and stick with it. If you use Proxy Fields, be careful about mixing a Proxy Field and a Lookup Field on the same form. If you don’t use Proxy Fields, learn how to use Record Picker fields to make the lookup dropdown have meaningful values.
QuickBase November 2009 Release
Tuesday, December 8th, 2009We were planning on a second issue of QuickBase best practices, but that will have to wait - QuickBase surprised us with a November release so let’s all get up to date on the new features!
These insert/delete icons appear when you float your mouse over filter lines during report setup.
Â
Free File Storage for QuickBase
Monday, October 26th, 2009Files are getting bigger and online storage space is becoming more abundant, so it’s no surprise that many QuickBase users have sought alternatives to the fees incurred when you store more than QuickBase’s 100MB limit. For those users who have maxed out their storage space, QuickBase Nation is offering a new service that provides an expanded 500MB of free file storage for QuickBase.
If you need more than 500 megs, stay tuned for QuickBaseNation’s Preferred Membership — available in November.
Â
Setting It Up
Â
Configuring QuickBase Nation’s file storage service is easy. QuickBase Nation piggybacks off of your QuickBase account, so the first step is to log into QuickBase. Then, in a new browser window, navigate to QuickBaseNation.com and sign into your free QuickBase Nation account. Once logged in, click the Free File Storage link.
Â
The file storage utility currently allows you to add expanded file sharing capabilities to one table. From the list of tables, select the one to which you want to add the expanded file storage, and come up with a name for your files (it should be a singular noun; for instance, correspondence or photo).
 QuickBase Nation will then add a set of three fields to your table: upload, download, and delete. These will allow you to manage your attached files through a simple interface. Add the three fields to your forms and reports to fully integrate the new file storage capabilities into your application.
A Note on Storage
Â
QuickBase Nation utilizes Rackspace file storage for hosting your files. If you are curious about the specifics of the hosting configuration, visit their website at Rackspace.com. And if you need help setting up or using the file storage utility, please contact QuickBase Nation at help@quickbasenation.com.
