I have a document library (Purchase Request System) that has a custom excel template tied to New Item.
The excel file has Macro button that saves back to that document library.
This all works fine, but AP Dept has asked me to add the ability to attach invoice and or Approved PO to the document list item.
As a workaround, someone has suggested to create a Hyperlink field and add the document url in the field. We can store the documents in another document library. This sounds great, but I need to automate this.
Is there a way to make a button or Link that displays in the original Document library A Edit Form linking back to Document library B ? ootb or code?