Yes you can!

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.

1. Create a formula text field. The following link explains how to create a field.

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.

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.

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

https://www.quickbase.com/help/about_local_users.html

The 1000 record import limit only applies to records containing a user field.

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 more and for instructions how to implement this feature, please review this help topic.

https://www.quickbase.com/help/set_max_length.html

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.

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.

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:

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.