csv export report without field names on first row of data

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered

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

Photo of David

David

  • 60 Points

Posted 5 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
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.
Photo of Ryan Stanford

Ryan Stanford

  • 1,358 Points 1k badge 2x thumb
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?
(Edited)