Hi. I have a datapage that will allow users to create a PDF treatment sheet for patients enrolled on cancer studies. There are multiple studies and each treatment sheets looks quite different, so I have created unique treatment sheets in Caspio's document templates.
The datapage that is a tabular report that filters data based on my pre-defined criteria. I allow inline insert at the top as a means for users to add records. All records in the results are ALWAYS associate with one study.
When the user completes the fields in the inline insert, a record is generated. I would like the results in this record to show the Generated PDF link for the appropriate study.
I cannot figure out how to do this. Since the generated pdf link doesn't show up as a field, I cannot use a calculated field to show the PDF that I want.
So I tried creating all of the links to the PDFs...
Below I passed a study parameter [@studyid] so the only records displayed are for the one particular study. But all tx sheets column's are there I cannot figure out how to hide the columns conditionally.
What I would like to do is pass a parameter [@studyid] and have that study's tx sheet be the only thing displayed. One treatments sheet template for each record.
Any guidance would be truly appreciated.