How to upload a file from a form and save to database

Question

I want to upload the file and save it into the database in integer form. How can I do it?

p2005 · Answer

Hi shrutij9485 , 
 Please try below code. It will save the document in documents folder and document ID to database table 
 a!formLayout(
 label: "Form",
 contents: {
 a!cardLayout(
 contents: {
 a!fileUploadField(
 label: "File Upload",
 labelPosition: "ABOVE",
 target: cons!PDS_DOCUMENT_FOLDER,
 value: ri!Document.documentId,
 saveInto: a!save(ri!Document.documentId, save!value),
 validations: {}
 )
 },
 height: "AUTO",
 style: "NONE",
 marginBelow: "STANDARD"
 )
 },
 buttons: a!buttonLayout(
 primaryButtons: {
 a!buttonWidgetSubmit(
 label: "Submit",
 saveInto: a!writeToDataStoreEntity(cons!PDS_DATASTORE_DOCUMENT_CONSTANTS,
 ri!Document,
 "Success",
 ""),
 submit: true,
 style: "PRIMARY"
 )
 }
 )
)

viratyogi · Answer

Hi Shruti, 
 File_Upload_Component 
 Please go through the documentation to see how you can upload a file, once you upload it you will get a document Id in the variable which you have passed into the saveInto parameter, you can save it in a CDT field which can be used to write into the database table. 
 Below is the link of 'how you can write values to the database' 
 Write_to_Data_Store_Entity_Smart_Service 
 Hope it helps, happy to discuss further.

shukurs0001 · Answer

Yeah, You can upload multiple docs at a time. You have to make sure that your variable must be a list of number integer array. And check maxSelection parameter value which shouldn't be 1, If it is 1 then you can just select only one file not multiple files.

How to upload a file from a form and save to database

Top Replies