Hi all, I have a tricky dynamo question which I cannot get my head around. I have created a script that reads all my issued pdf drawings from the issue folder and then populates my drawing register with a hyperlink to the drawings. My problem is:
The script will only work a new excel sheet and does not create a hyperlink in my drawing register (please see attached). Maybe there is something wrong with how I have created my Drawing register excel sheet.
When I place new drawings in the issued folder, I want the script to place the new drawing hyperlinks to the bottom of the excel sheet in numerical order. At present, when I issue new drawings and run the script, the new drawings appear at the top of the list in excel sheet. So somehow, I want to be able to refresh the link.
I have created some dummy pdfs to give an idea of what the drawing numbers in my issued folder would look like and what happens when you run the script.
Thank you for your time.
New Excel Hyperlink.dyn (13.7 KB)
Drawing Register Out.xlsx (21.2 KB)
0000-SWA-00-XX-DR-S-100.pdf (8.6 KB)
0000-SWA-00-XX-DR-S-101.pdf (8.6 KB)
0000-SWA-00-XX-DR-S-102.pdf (8.6 KB)
0000-SWA-00-XX-DR-S-103.pdf (8.6 KB)