Field Types

Syndicate content

The reference field (aka record-picker field) in the details table when displayed read-only always displays the value of the key field in the corresponding master record. The key field in the case you cite above is the Record ID#.

February 5th, 2009 - 5:02 PM

The best way to create a user hierarchy in QuickBase is to have a table of users. The key field in this table should be a user field. For each level of the management hiearchy you add another user field to this table. So for example the first user field in this table would be called Sales Rep. If each sales rep has a manager then you would create another user field called Manager.

February 5th, 2009 - 5: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 - 5: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 - 5: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 - 5:02 PM

Issue:
You reduce or increase file attachments and the change in size is reflected under the application properties but not in the account management application tab.

Explanation:
There are two possible causes.

February 5th, 2009 - 5:02 PM

For a multiple-choice field, you cannot enter a blank line as a choice in the list of options. If you do, the blank line gets removed when you apply your changes. However, you can leave the "Default Value" option blank. If you leave the default value blank, then the Add Record and Edit Record forms will have blank selected in the drop-down list.

February 5th, 2009 - 5:02 PM

Create either a view with a "Custom Column" of type text that has the following formula:

Int(ToHours([Date Created]-ToTimestamp(ToDate([Date Created])))) & ":" & Int(Mod(ToMinutes([Date Created]-ToTimestamp(ToDate([Date Created]))), 60))

or a formula text field with the same formula.

The formula for "Date Modified" would be:

February 5th, 2009 - 5:02 PM

If the key field for your master table that contains the actual file attachment field is the built-in Record ID# field then you can put the following on your Exact Form:

~="<img src='/up/dbidofmastertable/a/r" + fid["11"] + "/e17'>"~

you'll need to replace "dbidofmastertable" with the dbid of the table that contains the pictures. To learn how to discover dbids please read:

February 5th, 2009 - 5:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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