hyperlink with empty tag

[PT Gunawan Dianjaya Steel Tbk]

hi, I have a problem with hyperlink when the tag is empty in cell

merged results remains appears its tag like picture below

and here is example cell from my sheet

I hope that when cell link is empty (no contains any link in cell), the tags of hyperlink in autocrat not appears in results.
please any advice for that.

thank you

[Joseph Schmidt]

I don't know of a solution .

You could use a link that points to a dummy file.

The file could indicate that there is no data.

Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/3c57fc68-f065-437a-b39f-12e0f5a2f517n%40googlegroups.com.

[thiago lobato rodrigues]

Does it show the link when is populated with The hyperlinks?

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTORmmiB%3DfF%3DfJSrRq8T7EOYrJznNw82aKuQKQNaHUGkeNA%40mail.gmail.com.

[design.tl...@gmail.com]

Hi,

I've experimented with the following, and was able to create a merge result that omits <<Link>>  when hyperlink is empty on the source cell. 

• Create a new column [Link Rewrite] which is populated with 1) a copy of the link if [Link] cell contains a link, or 2) a space if [Link] cell is empty. 
  • Note that in the above scenario of 2), be sure to write a space " ", and not "". 
  • Formula I used in my experiment is =Arrayformula(if(isblank(B2:B)," ",B2:B))
• In the template Google Doc, replace <<link>> with <<Link Rewrite>>
• When mapping source data to template in Autocrat launch page, set <<Link Rewrite>> as Hyperlink, and leave the link label blank.
• When the source sheet line has no hyperlink, then the merged document will only show a visible "NO" and nothing after that; however, if you hover over the space after "NO", then a little popup "invalid link" shows up. 

If you are just wanting to avoid seeing the <<link>> on the merged page, and if you are not bothered by the "invalid link" popup when you happened to hover over a blank space, then I think the above steps would be sufficient for your needs. 

Here are the links to my experiment files:

• Data source sheet
• Template doc
• Merged doc with link
• Merged doc without link

Regards,

Yoshiko Egan

Design.TL...@gmail.com