HTML link to External site Using Values in Table

Hulachic5

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

 

 

 

 

GrantSmith

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>')

GrantSmith

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>')

Hulachic5

@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.

GrantSmith

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>')

Hulachic5

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> Activity Link </a>

[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.)

 

 

GrantSmith

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>')

Hulachic5

@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.

 

 

Hulachic5

@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.