I have a simple task to accomplish but am wondering the best way to go about it.
Solution Details / Problem Space
- In the solution there is a table for "Projects" which has a field "ProjectNumber" that generates a unique number for each project
- We have a network file server that is used for these Projects to store documents that we don't want in container fields (like uploading 1000's of photos at a time, much easier in windows to drag and drop)
- Currently these folders are manually created and the sub-folders within those are touched by so many hands that the naming structure is very inconsistent
My goal is to write a script (hopefully in python or powershell or another language) that will grab the value of ProjectNumber and create a folder in the file server with a standard set of sub-folders when the user clicks on the project number field in the FMP app. It will create the folder if it doesn't exist first, if it does already exist it will open the folder so the user can browse through it.
I have built this before using batch scripts, but it's clunky and has it's limitations. It also required the users have the batch script on their local machine in order to call it. I'm wondering if the same functionality is possible with PowerShell or Python. I'd prefer Python but either will be fine if possible.
Thank you for your time and hopefully the answer to my little problem