I am editor for an academic journal and routinely download a manuscript file and a cover letter file. I would like Hazel (or some other automated process) to rename and move each file to a folder containing the manuscript ID which is contained in the manuscript file. Currently, Hazel recognizes the manuscript file, renames it, creates a folder, and moves the manuscript file to the newly created folder (see link below to the screenshot of the Hazel rule that works for the Manuscript file but, not for the cover letter file). However, the cover letter does not contain the same information as the manuscript file. Thus, I am unsure how to get Hazel to rename and move the cover letter file based on information in the manuscript file.
Example of Problem:
Cover Letter (corresponding to the manuscript above)
Manuscript File is searched, renamed, and moved to a subfolder based on its attributes
Cover Letter is downloaded and triggered based on its attributes and needs to be moved to the same folder as Manuscript File (but this folder is different and depends on the attributes of File A)
See original rule for the manuscript file at this link (this rule does not incorporate File B but needs to):
I have a bit of knowledge with AppleScript, own Keyboard Maestro, and TextExpander. Thus, I am happy to use any (or combination) of these tools to get the job done.
Any guidance on this problem is greatly appreciated.