Articles

Articles of interest to QuickBase folks

How QuickBase Views and Reports Relate to Queries

In the QuickBase UI, retrieved records are displayed in rows in a table, with the field data layed out in separate columns. This layout of record data is called a view.

Why do we call it a view, and not just record data? Because a view seldom contains all or even most of the data fields in a table record. Suppose you wanted to populate a picklist with names from the Customer table. You would not construct a view that contained every field--you would only want to get and show the customer name field. So your view would have only one column (customer name) in it.

Another way to think about this is having multiple views of the same table each of which is accessed through a separate role. An employee table could have one view containing only employee name and contact information, one view with payroll information, and another view with human resource notes. You could access one of these views only if you belonged to a role that allowed such access.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit