The field containing red values is a multiple-choice field. The red values are "orphaned" values. An orphaned value is an choice that was removed from the list, but still appears in some records. By showing that entry in red, QuickBase is alerting you to this disconnect. If you add that entry back to the multiple-choice list, those values will appear in black again.

Let's assume that you have a District table, a Contacts table and an Orders table. The District table is the master table to the Contacts table and the Contacts table is the master table to the Orders table.

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.

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.

1. In the table bar on any application page, click the table containing the field. Within the menu that appears, select Customize --tablename-- table > Fields.

2. Click the field's name that you want to modify.

3. In the "Choices" text box, select the choices that you no longer want included in the list, press the DELETE key, and then click "Apply Changes".

The easiest way to find places where the same value is used in the same field across multiple records is to use a summary report. To do this, click the name of the table you are interested in finding duplicate field values for and select Create a new Report. Within the Report type section, select Summary. Now set the view properties to the following:

In order to show a portion of a particular field's data on a report and/or form, you need to take these two steps:

1) Create a new formula field that will hold the subset of the original field's data, and

2) Add the new formula field to the forms and reports where you want the condensed field showing.

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.

1In the table bar on any application page, click the table containing the field. Within the menu that appears, select Customize --tablename-- table > Fields.

2. Click the field's name that you want to modify.

3. Select the "Allow users to create new choices" check box, and click "Apply Changes".

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: