Skip to Navigation


Syndicate content

'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 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 - 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

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.

There are two possible causes.

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

© 2016 QuickBase, Inc. All Rights Reserved.

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