Hi
Has anyone had any luck inserting a product URL as a clickable link in a quote details document?
Obviously there's a merge field called <<line/url>> and a template variable called {qlur} which gives the URL itself, but what I'm looking for is to insert it a as a clickable link, preferably by displaying it as a clickable PDF icon. Alternatively, a "Click here" text would also work.
I was hoping I could right click the PDF image icon -> Link -> inserting {qlur} as the address, but after saving it, it becomes %7bqlur%7d and no URL is inserted in the quote.
All Replies (5)
I solved it! It's really finicky to do, but it works. Only caveat is that it seems it's not possible to insert the link icon only when the product actually has an URL. This is because hyperlinks can't be put inside a field code IF statement, which some Googling confirms. So if the URL field is empty, the icon will be there and clickable but the URL will be invalid.
I'll post the solution here in case someone else is interested:
1. Click the position in the document where you want to insert your link, and press Ctrl+F9 to open a Field Code.
2. Right click the field code -> Edit Field --> On the list on the left side, choose Hyperlink. Then click OK.
3. Press Alt+F9 to open up all Field Codes
4. Insert "" Right after HYPERLINK. In between the "", click Ctrl+F9 again. Right click the new field code -> Edit Field -> choose Merge Field on the left side. Input "line/url" as the Field name and click OK. It should look like this:
5. Click Alt+F9 again to close the field codes.
6. This part is very important, not to mention annoying: You need to insert your image of choice, but for some reason Word absolutely needs to include the text that says "Error! ". To solve this, you must hide that part of the text. Highlight "Error! " (including the space after the !). On the toolbar, go the Home tab and right click the little arrow in the corner of the Font section. Click Hidden and OK. If you want, you can also go to your Word settings and choose to display hidden text to make it easier to see what you have done.
7. Right after the hidden text, insert your picture. Remove the rest of the text.
If you have chosen to see hidden text in word, it should look like this:
8. Save the document.
End result:
If anyone knows a better way, or knows how to mute the icon when a URL is not present, I'd love to know..
Hey everyone
My product line URL workaround broke after the latest SuperOffice Online update. Actually we had two different customers today who had sudden issues with their quote templates, so I imagine the underlying Aspose engine was updated or something similiar?
Anyways, does anyone have a good solution for displaying a product line URL as a clickable link in the quote? Could either be as a clickable text or icon!
Any help is appreciated.
Solved it again! After the recent update this has to be done in a slighty different manner, with an extra step where you insert a bookmark.
Here's how to do it:
- Click the position in your product table where you want to insert your URL
- Press Ctrl + F9. This will create a Field Code.
- Right click the Field Code and click Edit field
- Choose Hyperlink from the left hand list and click OK
- Press Alt + F9 to display all Field Codes in the document
The field should look like this now: { HYPERLINK \* MERGEFORMAT }
- Right after the text “HYPERLINK”, press Ctrl + F9 to insert another Field Code.
- Right click the new Field Code and click Edit field
- Choose Merge Field from the left hand list and type “line/url” as the Field name. Click OK.
The field should look like this now: { HYPERLINK{ MERGEFIELD line/url \* MERGEFORMAT} \* MERGEFORMAT } - For some reason, we have to circumvent Word thinking the URL from the Merge field is a local file. Inserting a bookmark works as a workaround for this (no idea why). We have to insert a bookmark immediately after the Mergefield: Click so that your cursor is placed right after the line/url Merge field, between the } and \*.
- Go to the Insert tab in you Word window and click Bookmark.
- Insert anything you want as the bookmark name. I wrote "link". I also checked Hidden bookmarks, not sure if it matters. Click Add.
- Press Alt + F9 again to close the Field Codes
The field should look like this now: Error! Hyperlink reference not valid. - Click anywhere inside the “Hyperlink reference not valid” text, and insert your wanted image icon (or text if you prefer). Remove all the other text around your icon.
- Save the quote document
End result:
If anyone knows of an easier way to do this, I would love to know!
Hi Espen. You must have spent hours and hours testing and solving this. Thanks for sharing!