Discussions

Expand all | Collapse all

csv export report without field names on first row of data

  • 1.  csv export report without field names on first row of data

    Posted 06-18-2014 12:47

    Hi,

    I'm trying to create a simple report which produces CSV output, but I do not want the field names included.

    Rather than forcing my users to manually delete the first row of data each time, is there some kind of hidden parameter I can user in the URL (or maybe generate the CSV via an API call?)

    Thanks

    David



  • 2.  RE: csv export report without field names on first row of data

    Posted 06-18-2014 14:49
    Tested in Chrome and Firefox:

    Pastie Database

    https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=295


    Just substitute your dbid, qid and filename and paste into the JavaScript console (press F12 to expose) to test. The script (1) converts you query from a normal query to a csv query, (2) removes the header line and (3) saves it to the specified file automatically! The script can easily be integrated into your application in a number of exciting ways.

    See Screenshot attached.


  • 3.  RE: csv export report without field names on first row of data

    Posted 02-15-2019 18:02
    I know this is an old post... but how can I implement this in the case of say an embedded report, which the report settings are "show all" but I really need it filtered depending on a Related Record ID?