Insert a hyperlink into an existing set of data then display in a grid
Here is my scenario. I have an array of data, this data represents all of the purchase orders which an individual has to approve. These are presented to the user in a data grid within a web form. The user then selects each of the po's they would like to approve, clicks the button on the form and the po number for each selected po is passed to a custom component which performs the appropriate action in the database, this part is working.
The following is the functionality I would like to add to this process.
Each of these po's has a corresponding PDF file stored on the server. I would like the user to be able to pull up each PDF, by clicking on a hyperlink which will also be displayed in the grid as well, this is the part I am looking for help on.
The file path to the PDF file is comprised of a fixed path which then needs to be combined with the JobNumber and PoNumber variable from my existing data stream to combine for a completed clickable file path, displayed in the data grid, which is unique to each record.
the path would need to look like.......
\documents\jobnumber\jobnumber_ponumber.pdf (where JobNumber and PoNumber are the variables pulled from withing the existing set of data)
I do have existing data fields in my data array which are not used, so I do have the option to be able to "hijack" one of these existing fields, strip out any data it may contain and insert my newly created file path hyperlink as opposed to inserting a new data field into the existing array. But any option would be acceptable.
I am using workflow 7.5
thanks in advance for the help on this.