Forum Discussion

DavidDavid7's avatar
DavidDavid7
Qrew Trainee
11 years ago

csv export report without field names on first row of data

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

APIs and custom code
Data import and export
reports and charts
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    11 years ago
    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.
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    7 years ago
    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?