I have an interesting challenge I’m hoping someone can help me with.
I have a list of [Certificate number]s generated from an EnumList. The output appears like this:
2974611 , 1416837 , M19-0461 on a google sheet (pdf) report sent to the client. Each [Certificate number] matches a pdf file stored on our server.and I’d like to provide a link to the matching pdf for each number. for Example:
Clicking on 2974611 links to http://mywebsite/certificates/2974611.pdf
Clicking on 1416837 links to http://mywebsite/certificates/1416837.pdf
I am able to generate a HYPERLINK() in a virtual column using a bunch of SUBSTITUTES(), but then the entire link also displays on the report rather than just the certificate numbers.
if I embed HYPERLINK() on the form I can only have one link instead of three.
Looking forward to hearing the solution.