HTML link to External site Using Values in Table

Reply
Highlighted
Yellow Belt

HTML link to External site Using Values in Table

Aloha All:

 

I am trying to create a hyperlink from the values in a html table.

 

This is what I have so far:

 

CONCAT('<a href= https://www.research.net/r/',`column header name`,'_',`column header name1`,'_',`column header name2`,'?c='`column header name4`,'&PFC='`column header name5`,','`column header name6`,'&PCN='`column header name7`,'target = new> name of link on card </a>')

 

However, I have a syntax error but can't seem to find it.

 

Any suggestions?  I know I am missing something?  Does anyone know if there is a limit on the amount of columns that can be concat for a hyperlink.

 

Any assistance would be greatly appreciated.

 

SPM

 

 

 

 


Accepted Solutions
Highlighted
Major Brown Belt

Hi @Hulachic5 

You're missing a few commas. Try this:

CONCAT('<a href= https://www.research.net/r/',`column header name`,'_',`column header name1`,'_',`column header name2`,'?c=',`column header name4`,'&PFC=',`column header name5`,',',`column header name6`,'&PCN=',`column header name7`,'target = new> name of link on card </a>')


**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**

View solution in original post

Highlighted
Major Brown Belt

Your link should be enclosed in double quotes and the target needs a space before it

 

try this. 

CONCAT('<a href="https://www.research.net/r/',`Survey Collector - Current`,'?c=',`Ops Sup Region`,'&PFC=',`PFC Name - Survey Link`,'&PCN=',`PCN`,'" target="new"> Activity Link </a>')



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**

View solution in original post

Yellow Belt

@GrantSmith 

 

I was able to figure it out.

 

For the URL information only  my beast mode is:

CONCAT('base url',`column header1`,'some text',`column header2`,'some text',`column header3`,'some text',`column header4`)

 

I couldn't have done it without your assistance.

 

Thanks again.

View solution in original post


All Replies
Highlighted
Major Brown Belt

Hi @Hulachic5 

You're missing a few commas. Try this:

CONCAT('<a href= https://www.research.net/r/',`column header name`,'_',`column header name1`,'_',`column header name2`,'?c=',`column header name4`,'&PFC=',`column header name5`,',',`column header name6`,'&PCN=',`column header name7`,'target = new> name of link on card </a>')


**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**

View solution in original post

Highlighted
Yellow Belt

Thanks @GrantSmith.  That worked like a charm.

 

A follow on question -- I get the following results:

 

 - no hyperlink, but displays everything between the parenthesis (Example below)
<a href= https://www.research.net/r/Ansbach_GE_USA?c=3&PFC=B.Vallejo&PCN=RAAAnGEatarget = new> Activ...

[However, the orange font above is the actual hyperlink that I am trying to create in the beast mode. It should read "Activity Link", but it doesn't.]

 

My Beast Mode is:
CONCAT('<a href= https://www.research.net/r/',`Survey Collector - Current`,'?c=',`Ops Sup Region`,'&PFC=',`PFC Name - Survey Link`,'&PCN=',`PCN`,'target = new> Activity Link </a>')

 

Any thoughts?

Do you know if spaces in the column values plays a part? (i.e. Survey Collector - Current = Mount Rushmore, etc.)

 

 

Highlighted
Major Brown Belt

Your link should be enclosed in double quotes and the target needs a space before it

 

try this. 

CONCAT('<a href="https://www.research.net/r/',`Survey Collector - Current`,'?c=',`Ops Sup Region`,'&PFC=',`PFC Name - Survey Link`,'&PCN=',`PCN`,'" target="new"> Activity Link </a>')



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**

View solution in original post

Highlighted
Yellow Belt

@GrantSmith  - You are a true LIFESAVER.  Worked like a charm.

 

How can I show the entire URL without it being hyperlinked? I would like to have it in the next column...as a QC in case, the link doesn't work.

 

Do I use the same beast mode, just remove the "https://"?

 

Truly appreciate your assistance.

 

 

Yellow Belt

@GrantSmith 

 

I was able to figure it out.

 

For the URL information only  my beast mode is:

CONCAT('base url',`column header1`,'some text',`column header2`,'some text',`column header3`,'some text',`column header4`)

 

I couldn't have done it without your assistance.

 

Thanks again.

View solution in original post

Announcements
Stand out in the Dojo: Choose your own recognizable username and add a unique profile photo in your profile settings.