Fields

Syndicate content

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.

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

This operation cannot be performed in batch via one click of the button. But you can speed your work by building a report that returns the records for which you want to delete file attachments. Then, edit the first record in that report and remove the file attachment from the record. You can then use the Save & Next button that will bring you to the next record in the report.

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

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.

February 5th, 2009 - 5:02 PM

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 create one, you can:

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 Summary and click Create.

Now set the view properties to the following:

February 5th, 2009 - 5:02 PM

1. Open the table containing the field, and click Settings.

2. Select Fields.

3. Click the name of the field that you want to modify.

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

This works whether or not users can create new choices.

February 5th, 2009 - 5:02 PM

1. Open the table containing the multiple-choice field and click Settings.
2. Choose Fields.
3. Click the field's name that you want to modify.
4. Check "Allow users to create new choices".
5. Click Save to finish.

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

© 1997-2014 Intuit Inc. All Rights Reserved.

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