Discussions

Expand all | Collapse all

Save As Spreadsheet Not Showing All Data

  • 1.  Save As Spreadsheet Not Showing All Data

    Posted 08-03-2020 15:49
    When trying to save as a spreadsheet some fields are not saving any data.  The data is in the table but not in the csv file generated by Quick Base.  Please help.

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Save As Spreadsheet Not Showing All Data

    Posted 08-04-2020 09:58
    Hi Paul,

    If you are still having an issue with the data not showing up in your CSV I would suggest connecting with the Quick Base Care team. You can do that when you are signed into Quick Base by clicking the question mark icon that appears in the upper right hand corner and selecting "Manage Support Cases" or here in Community when signed in by clicking support where it appears in the upper right hand corner and creating a case there. Either will connect you with our Care team and they can take a closer look at the issue you are having. If the report that you are on is displaying data and when you select save as spreadsheet on your report and see nothing in the CSV that is very unusual and they can get an invite in your app and take a look at it if you let them know the table and report. Absolutely let me know if you have any trouble connecting with the team or creating a case.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------



  • 3.  RE: Save As Spreadsheet Not Showing All Data

    Posted 08-04-2020 12:03
    Thank you, Support Case created.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 4.  RE: Save As Spreadsheet Not Showing All Data

    Posted 08-04-2020 13:46
    The plot thickens.  The data actually is in the csv file, but text is white.  Why would that happen?

    ------------------------------
    Paul Peterson
    ------------------------------



  • 5.  RE: Save As Spreadsheet Not Showing All Data

    Posted 08-04-2020 14:06
    That is very weird, is it rich text formula fields by chance you are downloading and was this data imported in or hand entered? The only thing I can think of is it came in with a style tag or something that Quick Base ignores but Excel doesn't.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------



  • 6.  RE: Save As Spreadsheet Not Showing All Data

    Posted 08-04-2020 14:20
    They're plain text fields. At this point they are most likely manually entered.

    ------------------------------
    Paul Peterson
    ------------------------------



  • 7.  RE: Save As Spreadsheet Not Showing All Data

    Posted 08-04-2020 15:39
    That is unusual, the team might be able to shed more light on what is going on there. That is a new one on me at this point.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------



  • 8.  RE: Save As Spreadsheet Not Showing All Data

    Posted 08-04-2020 16:43
    Mystery solved!  The problem was created by the user pressing enter while in the field in Grid Edit.  This caused the data in the csv file to appear on two lines.  Since the row height was only showing the second row, it appeared that the data was missing.  I re-opened one of the earlier files that appeared to be missing data, increased the row height and saw the data that appeared to be missing.

    ------------------------------
    Paul Peterson
    ------------------------------