I have a bunch of dynamic values Im attempting to load files for,
However I can’t see how to get the File->ID of the upload once it is saved to the database (which is working correctly) and I can save statically to a particular column if desired.
Currently Im loading the UploadField to the form dynamically which uploads to the File table, but is there an event (After upload) or similar I can use to assign the uploaded files ID to a project (based on the uploadfield being named in a key base structure for reference).
OR alternatively are associative entities possible to model in the silver-stripe data extensions - if so where is a good reference for a relationship
[File]->ID - Zero One or Many
[Project_File]->FileID/ProjectID - Zero One or Many