Insert filename into database on upload

I posted this question in Universal Email as well. Anyway, I have a form with text and thumbnails. It works and a new record is inserted into my database. The thumbnails are also correctly uploaded. Problem is, I need a way to store the name of the uploaded file in the database as well, so I can display all thumbs associated with a particular record.

How do I pass the filename the user chooses to the corresponding variable in the recordset so I can store the filename? Do I need to create a hidden form element and somehow set it's value to the thumbnail name?

OK, I figured it out after much head scratching. First you use DataAssist to build your insert record page. Then you create the upload file behavior in file manipulation for the form field of your choice. Then you go to server behavior, click add, and select insert from the DataAssist section (not the first insert behavior). From there, you specify your database info and session variable (which is filled in for you). On the next screen, you select the form field you want to use to store the thumbnail image text/file name. Click on the lightening bolt icon and from within the dynamic form part, double click on simple file name. Don't forget to add .jpg or whatever your image extension is as the file upload breaks up the name. For trigger, I selected "any successful upload". That way, once my first thumbnail was uploaded, this behavior would have the file name ready to insert into the record. It works like a charm, but took forever to figure out!

I hope this helps anyone else who might have the same problem.

Instead of using a separate Insert record Server behavior, you can edit the one that DataAssist adds to the page.


Also instead of using the simple file name from the form collection, Expand the Uploaded Files collection in the Dynamic Data Bindings and use the Server File name.

There is also a tutorial availabel to help with this available on the Universal Email support page:
universal-email/

look in the how to section for the how to titled "Applying File Upload to DataAssist Insert and Update pages"