## Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

## Knowledge Base Articles

• right("000" & floor([octet1]), 3) & "." &
right("000" & floor([octet2]), 3) & "." &
right("000" & floor([octet3]), 3) & "." &
right("000" & floor([octet4]), 3)

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#] &
"&dfid=11"

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
Tags:
• 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
• You can easily do this in QuickBase. You'll need to create a few new fields in both your customer and quotes tables, relate these tables and then set up a special field to capture this combination number. To do so:

1. In your Customer table, create a Numeric field called "Customer Number".

February 5th, 2009 - 6:02 PM
• I have values for four fields representing a quarterly balance in an account. They are filled in successively over time, so at any given time they may not all be filled in.
---

This is a good place to use the Nz() function. It allows you to use a value if it is not null, but if it is null use an alternate value instead. You can cascade them to successively check each field.

February 5th, 2009 - 6:02 PM
• This can happen because the field property for [num1] called "Treat blank as zero in calculations" is checked. This is checked by default, so you can do things like add and subtract lists of values which contain some blanks.

February 5th, 2009 - 6:02 PM
Tags:
• That field must appear more than once on your form. When that's the case, QuickBase must choose which value to enter in the field. To break the tie, QuickBase always takes the value from the last instance of the field, which in your case is the one you're leaving blank.

If the duplicate field is a mistake, just delete the double from your form. The field will then save values as you expect.

February 5th, 2009 - 6:02 PM
Tags:
• If you can no longer see detail records in a report that you've embedded on a master form, someone has changed the Filtering (matching criteria) for that report.

February 5th, 2009 - 6:02 PM
• If you want to restrict the number of characters in a text field, please see our Set Maximum Length for Entries in a Text Field help topic.

February 5th, 2009 - 6:02 PM
• Here is an example of a formula that returns a different price for each of several kinds of fruit. The data type of the result is Number.

case ([Fruit Name], "Apples", .5, "Pears", 1, "Berries", 4)

If the [Fruit Name] doesn't match any of the cases, null is returned. To return a default value when there is no match, add one more Number argument to the end.

February 5th, 2009 - 6:02 PM
Tags: