Uploading a file to a folder using a table ID

I’m trying to upload files to my server, and I want to place them into a folder that is named based on the ID from a table insert.

I’ve set up the Server Connect to insert data into the table, upload the file, then resize the file and save to a file/folder. The insert into the database, and file upload are working file, but the resize and save based on the database ID don’t seem to work, even though the action is reporting success.

I’ve a couple of specific questions as well.

  1. In the template entry, is this best left as {name}.{ext} and it will pick the name and extension I set above (as seen in the image below).
  2. Is the {{insert1.identity}} parameter the id field from my insert (I assume so, but just to confirm).

Any further thoughts anyone has on this would be appreciated.

Try the Template without the full stop, e.g. {name}{ext}

Edit: Or leave blank for the original name and extension.

Thanks (again) @ben. I managed to get it working by setting my static filename directly in the template field.

1 Like