fields

Syndicate content

Yes you can! You can create a formula text field that will display the value you want to see on the calendar as well as being a colored. In other words, if you want to see the Status of a record in red on your calendar, you could create a formula text field that displays the value from the field Status and is colored red.

June 25th, 2009 - 2:06 PM

Append fields can become quite large and contain too much text to display in a report easily. You can use a formula text field to display only the most recent value from your append field and then display the formula text field in your reports instead of the append field.

June 2nd, 2009 - 5:06 PM

If you find yourself in a situation where you constantly have to add new fields to a table in order to keep up with future dates there is a much easier way to manage this. You may have imported your data from excel and each column represented a different day in your spreadsheet, as a result you have countless numbers of check box or text fields for all past and future dates in QuickBase.

February 5th, 2009 - 6:02 PM

To accomplish this, you'd design your report with a custom formula field that combines values in all three contact fields and then (though they won't know it) let users search that field.

February 5th, 2009 - 6:02 PM

To maintain rapid application response time, QuickBase does not allow an import of more than 10,000 records containing a User field. (If you're unfamiliar with User fields, please review this help topic.)

The 10,000 record import limit only applies to records containing a User field.

February 5th, 2009 - 6:02 PM

You can limit the number of characters end users can enter or store in a field. Use this feature to help avoid data-entry mistakes in text fields. Carriage returns count as one character. To learn how, please see our Set Maximum Length for Entries in a Text Field help topic.

February 5th, 2009 - 6:02 PM

QuickBase formulas can be used within a record to compute and return a value. Generally formulas can only be used within a single record and can not span across multiple records in a table. For instance, in an employee table with a field Salary, the Salary for individuals can not be computed as a percentage against all other employees' salaries.

February 5th, 2009 - 6:02 PM

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

The field name:

~New IPAD3 - Asset Tag#~

is actually output by MS Word as:

~New IPAD3 – Asset Tag#~

MS Word has a feature called AutoCorrect that does 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

© 1997-2014 Intuit Inc. All Rights Reserved.

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