Download file

Probably in the wrong forum here, but I'm trying to use the download file behavior.
I have a data base that has file names-title of the file and the actual file somthing.pdf in the uploads folder. I tried applying download file but I guess I don't understand the triggers here like form submit and such, I want to force download when click on link to the dynamic pdf file from database rather than opening or saying "right click and save as" I want to force download. is this extention able to do that or do I need a bit of custom code?

create a record set to return the file name.

add a table to the page with 1 row and 2 columns.

in the column on the left, use the bindings panel and drag the binding for the file s title.

in the column on the right, add a form, a hidden form element and a submit button. for the hidden form element, set the initial value to use the file name column from the recordset.

now, in the tag selector at the bottom of the screen, select the TR tag for the table row. go to the server behaviors panel, click the plus button and select repeat region, select your recordset and set it to display all rows..

at run time, this will create a row in the table for each file in the database with a download button for each one.

now add the download file behavior. Use the Submit button pressed trigger.

for the file name, click the lightning bolt and select the hidden form element.

for the file folder, select the folder the files are stored in.

the forms submit button will now trigger the download behavior, and the download behavior will the name of the file to download from the hidden element.

Could this be worked from my link to auto download from click or set the submit buton to a link.
Or is it better to do it this way which will for sure work I would rather they just click the link and download or supply a "download" link instead of a button as would fit in my layout best

go to the bindings panel and click the plus button, select URL variable and set the name to "file"

create the link as:
<a hef="downloadpage.php?file=<?php echo $row_recordsetname['filenameColumn']; ?>">Download</a>

where downloadpage.php is the name of the page with the download behavior and behavior on it, recordsetname is the name of the recordset and filenameColumn is the name of the file name column in the database.

in the download behavior, clickthe lightning bolt icon next to trigger and filename and select the file querystring binding.

Thanks, perfect as always!

Sorry one more quick question, This is in a footer that will be on every page this is the link now:
<a href="uploads/<?php echo $row_rsforms['form_file']; ?>"><?php echo $row_rsforms['form_name']; ?></a>

Is there a way to have it just refresh to it self to pass the param when clicked without specifiying a page per say..

not really, that would mean having to add the download behavior to every page as well as the footer.

Alright, I might just try your solution, with the form and buttons in the repeat region.
Thanks for all your help!