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 ...
Forum Discussion
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.
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.