So I am trying to simplify a process I have currently and being able to do everything in a Collection would be a dream. I've seen the [ROW()] info but it doesn't seem to actually work where I need it to.
[ROW()] works flawlessly on the name of the File Upload but just descends into madness on the File Upload path. If I try to do it with tokens for each section I end up getting folders named after every item in the field, if I have a workflow build the path and add it as a field in the collection it breaks and then suddenly I have a folder path that has each individual word as it's own folder with the next word nestled inside.
I would love some help on this because I keep looking it up and just keep finding "Use [ROW()] !" but it doesn't seem to work for me.
Below are examples of what's happening. The first is using \{/dataset/Are_we_testing_this_process_}\HR\Northern Valley Indian Health Employee Files\{/dataset/Where_should_these_Employee_Files_be_stored_} Files\{/dataset/Full_Name}\{/dataset/Documents_Import_Section/Catagories[ROW()]}\{/dataset/Documents_Import_Section/Document_Type[ROW()]}\ in the File Upload Path and the second when I used a token passed to the form from Workflow, \{/dataset/Are_we_testing_this_process_}\{/dataset/Documents_Import_Section/File_Location[ROW()]}