chronoforms fileupload link in tables connected view

I have searched the forum and found many questions and posts regarding file uploads and links to files in emails, links in templates for chrono-connectivity but nothing about links in the table view from within chronoforms.

I thought for sure I have done this in the past. perhaps not.

I have a custom form. not created with the wizard.

I have everything working, files upload, all information sent, and saving in the database. Now the only way I know of to list and view entries in the db with chronoforms (Without chrono-connectivity) is by clicking on the table link in the forms manager for that form. you can set which fields will show in the list view, and then you can drill down to a full view.

now how do we get a link to the file from this full view?

when creating the table, I did not see any special type to use for the file upload field. Did I miss something?

I just would like a link in the admin so the user can download, view. etc from within the table view of choronoforms..

thanks fo all your help!!

Hi leeburstroghm,

First the column type for a file upload is a VARCHAR of suitable length. ChronoForms stores just the name of the file in the table, not the file itself.

To get a link to the file from the admin view you'd probably need to add code in the OnSubmit Befeor Email box to build a link like <a href='some_path/file_name.xxx'>File ref</a> and either save this instead of the file name - or, probably better, in an extra column in the table.

I've never tried this but I think it should work OK.

Bob

Hi Greyhead,

I think my doubt is related to this one. All I want to do is to make a link to the file just uploaded in Events --> OnSubmit --> Email --> Template.

Using the debug feature, I can see an array like this:

[_PLUGINS_] => Array
(
[upload_files] => Array
(
[file_upload] => Array
(
[name] => 20120613083148_readme.txt
[path] => /home/xxx/htdocs/components/com_chronoforms/uploads/yyy/20120613083148_readme.txt
[size] => 37
[link] => http://www.xxx.com/components/com_chronoforms/uploads/yyy/20120613083148_readme.txt
)

)

)

)

So I want to use something like {file_upload[link]}. But chronoforms interprets this as a literal string, not the result of an array.

What is the correct syntax to achieve the value, or the best way to get this?

Thank you,

Marcelo

My question about link in the email template is answered in http://www.chronoengine.com/forums/viewtopic.php?f=5&t=81760