Clickable link in Calculation field?

Comments

24 comments

  • Hamid

    Hi Martin,
    Can you guive more details !
    why you want use a calculation for this ?
    you can use a text field and tape your link with http:// or www. in it when you create a new item and it will be automatically clickable.

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi Martin,

    yes, that's possible with markdown syntax

    "To see my link [click here](https://support.zendesk.com/hc/en-us/articles/203691016-Formatting-text-with-Markdown#topic_xqx_mvc_43__row_fs1_zln_1n)"
    

    will be shown as: To see my link click here

    The [alt text] and the (url) can also be variables like

     "[" + @text+ "](" + @link ")" 
    

    Rainer

    3
    Comment actions Permalink
  • Martin Boonzaayer

    Thank you so much for the help! Due to your response regarding "Markdown", I was able to find this very handy "cheat sheet" that may help others as well: https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet

    0
    Comment actions Permalink
  • William Willman

    can you also make the link open in a new tab/window instead of opening in the same window?

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi William,

    no not possible. 

    Rainer

    0
    Comment actions Permalink
  • Carson Young - Red Cliff Labs

    I am looking for a similar solution...but instead of a clickable link I want a viewable video thumbnail.

    Basically I want to post a video in the calculation field and have it appear as an embedded video inline (just like what happens if you post a youtube link in a Link Field format)

    I need this in a calculation field so that it can be copied to multiple workspaces. If I use a link field I would have to go to each app in the new workspaces and paste in the correct links over and over again.

    0
    Comment actions Permalink
  • Tim

    Hello Carson, 

    Maybe this will help you > here

    See section about you tube videos.

    0
    Comment actions Permalink
  • Tim

    I could not get

     "[" + @text+ "](" + @link ")" 

    to work, so ended up using:

    @Organisation + ' >  ' + @Page URL

    It's not pretty, or what I wanted, but does some of the job.

    0
    Comment actions Permalink
  • Carson Young - Red Cliff Labs

    Hey Tim,

    Thanks for that suggestion. The Globiflow article on Markdown - Rich Text in Podio looks like it's headed the right direction, but unfortunately I still haven't achieved the desired outcome yet. 

    Primarily in this case because I'm actually trying to use a video from the Wistia platform not YouTube and I couldn't get the syntax right to be accepted in a Podio calculation field. (honestly I tried with just a random YouTube video too and failed....my coding skills are zero, so it might be beyond me unfortunately)

    If anyone knows how this might work with a Wistia video link it would be super helpful, but otherwise I've found a work around solution for now. 

    0
    Comment actions Permalink
  • Lennie

    Is it also possible to add markdown syntax or something inside a help texts?

    Am trying to have my help text as:

    ---------------

    To see sample, click here: www.samplewebsite.com (clickable)

    Instructions:

    1.  Lorem ipsum dolor sit amet.
    2.  Lorem ipsum dolor sit amet.
    3.  Lorem ipsum dolor sit amet.

    ---------------

    Currently what I'm getting is just like:

    ---------------

    To see sample, click here: www.samplewebsite.com (not clickable) Instructions: 1.  Lorem ipsum dolor sit amet. 2.  Lorem ipsum dolor sit amet. 3.  Lorem ipsum dolor sit amet.

    ---------------

    I've tried adding some before but to no avail, it just posted every word as it is and didn't actually read it.

    This one's actually using a webform and with that format, it doesn't seem to be all that appealing with a link not being able to click and an instruction in a paragraph form. Ekkkk

     

    Thanks

    0
    Comment actions Permalink
  • Rainer Grabowski

    Not possible.

    0
    Comment actions Permalink
  • Jarrett A. Smith

    I have a similar question, is it possible to have a category field display a phrase that contains a "clickable link"? For example: "To see my link click here". Where "click here" has the underline and is clickable?

    0
    Comment actions Permalink
  • Randy Bantigue

    No, not possible in a category field, only in calculation or text fields.

    0
    Comment actions Permalink
  • Simon Midtgaard Guldberg
    Why does this not work?
    "[Click here](" + "file://" + @TextFieldwithNetworkFilePath+ ")"
    - where
    TextFieldwithNetworkFilePath is exactly that, like N:/Branding/file.pdf

    It creates a link, but clicking it does nothing...
    0
    Comment actions Permalink
  • Krisjanis Berzins

    Simon, I believe it should be file:/// not file://

    0
    Comment actions Permalink
  • Chris Edis

    Can anyone show me how to convert a webform link into a hyperlink in a calculation field? The hyperlink is added to an SMS using Globiflow but comes out as...

    Take our survey here "https://podio.com/webforms/21555944/1499965?fields[title]="+@Unique ID+"&"+"fields[description-2]"+"="+@DESCRIPTION »»».replace(/ /g, '%20')+"&"+"fields[seekar-id]"+"="+@Call Owner+"&"+"fields[customer-id]"+"="+@All of Seekee ID with nulls

    I'd like it to be just the words "Take our survey here" as a clickable link.

    Thanks

    0
    Comment actions Permalink
  • Rainer Grabowski

    Алексей,

    sure, that's possible:

    var text = @whatever field;
    "To see my link [click here](https://google.com '" + text + "')"

    Rainer

    1
    Comment actions Permalink
  • Kevin Oechsel

    @rainer what would the script look like to create a clickable link to an item, with custom text (As pictured), that jumps directly to a field's location within an item. Does it have to do with tying in the field's external id? (also pictured)

    I apologize if you've already covered this somewhere else!

    Thanks for your time. 

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi Kevin,

    that's not possible, you can't jump directly to a field in another item, it's only possible in the item itself. You can create direct links to a field in the same item: "[field xyz](#external-id)". The external id you find in the developers section of the app. 

    Rainer

    0
    Comment actions Permalink
  • Maitrey Shah

    Hi Rainer, 

     

    Would it be possible to show up the value of the calculation field as we are filling the form before we save the webform? If we can then it will solve all our and many other people's problem. 

     

    I will look forward to hearing from you very soon. 

    Regards, 
    Maitrey

    0
    Comment actions Permalink
  • Anna Paparizou

    Hi

    can someone help me succed this: 

     "[" + @text+ "](" + @link ")" 
    

    Actually I only want the link to be a field and I don't mind about the text. 

    0
    Comment actions Permalink
  • Susan Warren-Moy

    I'm struggling to get a link to work in this way. I want to set up a field which takes the URL for the item (which was added to the item via Globiflow as I couldn't work out how else to do this), and shows the title of the item for the text.

    This is to be used in a Globiflow process which emails people with a link to the item - I can of course set up the email to just show the URL link but I would far prefer to show the Title of the item as the text to click on. I can't see how to do this in Globiflow so thought if I could set up the field in Podio (and then hide it) I can use that in the flow.

    In Podio I have the Title field (text) and URL field (text), then a calculation field:

    "[@Title](@URL)"

    However this then displays:

    [field_83606101](field_208751746)

    On the item

    What am I missing? Am I not able to use @URL in this way?

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi Susan,

    it's: 

    "[" + @Title +"](" + @URL+ ")"

    [ and ( are text - and text must always be wrapped in ", field tokens/variables like @Title should never be wrapped in ". Text and variables must be concatenated by + 

    Rainer

    0
    Comment actions Permalink
  • Susan Warren-Moy

    As an update for this - to aid anyone else who might need help on this one.

    Having got my URL field populated (I used a script in Globiflow as I'm going to need it populating on any future items in the app), the code to use in the calculation field is this:

    "[" + @Title + "](" + @URL + ")"

    All spaces and quotes need to be exactly as above for the script to work. The hyperlink is now a field which I can access in Globiflow as a token to insert to an email.

    2
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk