Skip to main content

I found that I can use a formula like =@'My URL' to populate a web link but trying a more complex formula does not seem to work. This allows my to provide a clickable link without showing the URL as text on the graphic. I want to use a formula like



=CONCATENATE("https://google.com/?q="@Name)



When I apply this into the web link text box it simply shows me the raw formula (@Name is not expanded) in my email editor when I click  the link.



Any thoughts or suggestions?

Hi Ron thanks for posting in the community! Just to be sure we're on the same page is there any particular reason you are using formulas instead of actions? Actions allow you to apply links to shapes or text without showing the URL as text on the graphic. Let me know if this functionality does not work for your use case and I'd be happy to continue assisting!


Abigail


Sorry I was not clear. I am indeed using actions. When I bring up the action dialog for one of my nodes I want to enter a formula in the web link section of the action dialog for the action to use instead of a hard-coded or static URL. My issue is that the CONCATENATE formula is not working as expected when put into that web link. The LEFT and RIGHT formulas do work though. 


Regards Ron


Abigail - Any update or work around on this issue?


Regards Ron


Hi Ron thanks for following up! I was able to get this formula working using the following text in the Actions URL field:


 


=CONCATENATE("https://google.com/?q=" this.Name)

 


This will populate the data in the shape's Name field to appear in Google:


 



 



 


Hope this helps let me know if you have any questions!


 


For anyone else working with formulas please check out our Formulas in Lucidchart Help Center article for a quick intro and our Formulas Developer Documentation for a more in-depth outline.


@Abigail M Does this still work?  When I paste that formula into the Actions URL field, I just get a link with the formula text in it

 


Hi @PatrickRadoszewski

Thank you for the reply! It looks like you are entering this link by using the Actions button. To use this formula, you will add the formula to the shape. To add a formula to a shape add a “=” to the shape, in the box that pops up type the formula: =CONCATENATE("https://google.com/?q=", this.Name

To do this, also be sure to add a field to your shape labeled “Name.” 

 


Reply