I have a form with a collection that allows a file upload. HR will use this form to upload documents for multiple employees. When saving the attachments to the repository I want to be able to associate the employee number for an individual record in the collection as metadata for that record's uploaded file. I've tried this:
{/dataset/MyCollection/Employee_Number}
but it stores all employee numbers from the collection into each record's uploaded document. I've also tried this:
{/dataset/MyCollection/Employee_Number[Row(0)]}
but it stores nothing in the metadata.
Is there a way to do this?
Thanks!