Skip to Navigation

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I stop my append-only fields from being truncated when exporting to Excel?

'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. If you change the Append Only field to "Show the name and date on the same line as the entry" under Log Entries, it does not put leading dashes and solves the problem going forward. To fix existing data, you need to uncheck "Log edits to this field", manually remove the leading dashes from each record, then turn logging back on, choosing the "Show the name and date on the same line as the entry" setting. There is some risk that a user may enter data while the Append Only is turned off which you need to be aware of.


Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

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