Okay, I hate to admit how long I have been struggling with this!! It seems soooooo simple but we are talking YEARS people.
I am trying to format a "route entry to folder" path. We have an existing folder structure. It begins with Personnel\File Room\Active\ THEN there are folders for the alphabet, then folders for each employee (full name plus some numbers that will need to be "ignored"), then folders for each doc type. So, for me if I submitted this particular form it would file to Personnel\File Room\Active\R\Rogers, Cindy ####\Monthly Timesheet - Okay, now, MOST of these folders are already there for me with the possible exception of Montly Timesheet BUT not always so I have to set it to create if not there. As things are going now the doc files but it isn't filing correctly. I have messed with the path so often I can't really keep track any more. Mostly it will go to the Personnel\File Room\Active and then create a whole new folder that just says "Rogers", then another folder that says "Cindy", then another folder that says "Monthly Timesheet". Arghh..... As I have said, I have messed with this so much but this is the path I am looking at right now:
\PERSONNEL\FILE ROOM\Active\%(Fields.Last#<.>#)\%(Fields.Last)\%(Fields.First)\%(RetrieveFieldValuesforTimesheet_Document Type - PERS)
Can anyone help with this???? Thanks!