Save Files Attachment

  • 15 March 2017
  • 3 replies
  • 12 views

Is there an example how to add multiple files attachment in the viewand save those attachments into the database.

And when I retreat them back how do I display them in the list (listview, grid ...) as a hyperlink so that the user can click to view it.

 

Thanks for your help.

TTN


3 replies

Badge +9

http://www.velocity-it.com/how-to-upload-multiple-files-with-k2-smartforms/

 

Badge +8

Hello,

 It is pretty easy to have a multiple attachment view. Start by creating your table. Make sure your table has a column to store a process ID. This is going to me the ID from the main form. An example.

 

CREATE TABLE [dbo].[MULTIPLE_ATTACHMENTS](
[id] [int] IDENTITY(1,1) NOT NULL,
[PROCESS_ID] [int] NULL,
[Attachments] [nvarchar](max) NULL,

 

After the smartobject has been created you will need to update it in designer. The attachments field type will need to be changed from "Memo" to "File".

 

 

 

I hope this helps. Good Luck.

 

Thanks,

Bryan Peters

Hi Bryant,

When you execute the "Create" rule. K2 is automatically save the file (data) back to the database?

 

Reply