Skip to Navigation


Syndicate content

While QuickBase tables come with the key field set to Record ID#, you can use one of your own fields as the key instead. (To learn how to change the key field, please see this help topic). But what’s the difference? Is it worth making the change?


July 17th, 2014 - 10:07 AM

Yes you can! You can create a formula text field that will display the value you want to see on the calendar as well as showing a color. In other words, if you want to see the Status of a record in red on your calendar, you could create a formula text field that displays the value from the field Status and is colored red.

June 25th, 2009 - 2:06 PM

This can be accomplished by adding a new table to your application and using the snapshot property of a date field.

February 5th, 2009 - 6:02 PM

1. Choose a table from the Table bar.
2. Click REPORTS & CHARTS to open the reports panel, then click + New.
3. In the dialog, select Table and click Create.
4. In the Columns section, choose Custom columns and click and drag each column you want to include under Report columns.
5. Check Define a calculated column.

February 5th, 2009 - 6:02 PM

During the import process, if you import your resources, or contacts, by name into a user field (such as Assigned To), QuickBase may not recognize the names as users (To learn more about User fields, please see our Manage Users in an Application help topic.).

February 5th, 2009 - 6:02 PM

The total value at the bottom of a column is the total of all values above it in the report. The same is true of the average value at the bottom of a report. The average value is the average of all the values in the column above it.

February 5th, 2009 - 6:02 PM

Let's assume the text field is called "Notes". Create a formula text field with the following formula:

Left([Notes], 100) &
" " & URLRoot() & "db/" &
dbid() &
"?a=dr&rid=" &
[Record ID#] &

where the number eleven above is the identifier of the custom form that displays only the field "Notes". To determine the dfid of your custom form please read:

February 5th, 2009 - 6:02 PM

'Append Only' fields that have the "Show the name and date on their own line" setting turned on do not export to Excel correctly because they contain the leading dashes. Data gets cut off because Excel sees the leading dash and reads it as a numeric field which has a limited size.

February 5th, 2009 - 6:02 PM

The best way to do this is to flip the problem around on its head.

1) Instead of making the date field a formula field, make it a plain date field.

2) Then remove the choice of "Complete" from your multiple choice "Status" field.

3) Create a formula text field called "Computed Status".

4) Put the following formula into the formula property of the "Computed Status" field.

February 5th, 2009 - 6:02 PM

There are two techniques. The first technique is to convert the field from what ever type (i.e. numeric, text, date) it is to a formula field of the same type (i.e. formula-numeric, formula-text, formula-date). Then convert it back to the type it was. This erases the contents of the field.

February 5th, 2009 - 6:02 PM

© 2016 QuickBase, Inc. All Rights Reserved.

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