Discussions

Expand all | Collapse all

export to excel; one field to multiple rows

  • 1.  export to excel; one field to multiple rows

    Posted 21 days ago
    Hello,

    When I attempt to export a report the result is it has the correct column names and initial data but one of the fields for a few records is getting put at the bottom in the first column under the other data in the report (this is happening when users put in a lot of text). The field type is a text-multi-line and I've tried putting a large number on the Max Character but that is not helping.

    Has anyone experienced this? Is this an issue with Quickbase or Excel?

    ------------------------------
    MATTHEW STOGNER
    ------------------------------


  • 2.  RE: export to excel; one field to multiple rows

    Posted 21 days ago
    Most likely, it's a problem with the text being inserted and how Excel is interpreting the CSV data - namely the column delimiters. I'm guessing your weird column break issue occurs when the user has entered a comma into the text field. Unfortunately, I don't know of a reliable way to fix that except to strip any commas from the text using a formula and then downloading from a report that uses the formula instead of the original text.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------