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 showing a color. 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 - 1: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 - 4: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 - 5: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 - 5: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 - 5: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 - 5: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 - 5: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 - 5: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 - 5:02 PM

Adding extra fields does take up space even if the fields are empty. To be precise each text field takes up a minimum of 4 bytes, so if you have 10,000 records and you add 50 new, but blank, text fields, you've bumped up your database size by 4 bytes per blank text field times 10000 fields times 50 text fields which is 2 megabytes. For more information on the space take

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