Forum Discussion

MichaelFrishman's avatar
MichaelFrishman
Qrew Cadet
8 years ago

Button to export CSV from parent record

I'm trying to have the user click on a button in a parent record form, which will then download the detail records from a child table related to that parent, in CSV format. I know I can easily create a button that downloads a specific report to CSV using the URL of the report, but when I try this it downloads the whole report, not just the records related to the parent.

How can I accomplish this? Thanks in advance.
APIs and custom code
App builders
Data import and export
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Low tech is to use the "More .." button on the blue bar at the top of the embedded child table.
  • MichaelFrishman's avatar
    MichaelFrishman
    Qrew Cadet
    8 years ago
    True, but I'm trying to make it idiot-proof for my users. A big button that screams CLICK ME TO DOWNLOAD goes far.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Ya, its doable.
    I will outline the steps and and let me  known if you need more detail.

    Make an <ask the user> report on the child with your export columns.  The <ask the user> is for [Related Parent]. Set the report at the very bottom to be in CSV format.
    Run the report manually and observe that it works and observe the URL - we need to mimic that URL in a button.

    URL formual

    urlroot() & "db/" & [_DBID_of my child table] & "?a=q&qid=xx&nv=1&v0=" & [Record ID#]

    that says:
    Run the report on the Child  table with the report ID =xx (which you will fill in) 
    and it will have 1 question (nv = number of variables = 1) and the zeroth variable is [Record ID#]

    It starts counting at zero.