I have an SC Action that executes file upload and database insert action.
I followed the tutorial on the doc site. . The file is uploaded fine but the name is not inserted in the DB. A form is a Boostrap5 form generated. I believe I have done everything right but after the 15th time, it’s time to come for help. Please see the screenshots below. What am I doing wrong?
Upload Setup
DB Insert Setup
Form Generator
Most probably your POST var is not defined as file, as the expression in the insert step is wrong.
You need insert the path property from the upload step (not the file’s name)
If it’s only one file being expected/uploaded make sure the POST variable isn’t set up for ‘multiple’
a million applauds. But this should be mentioned in the docs so newbies like me can follow. Thanks a million.
My follow-up question is, If the form has more than one upload field going into separate columns in the DB, do I need multiple file upload actions or selecting the various upload fields in Upload Field will suffice?
Yes
