Forum Discussion

StooHoo's avatar
StooHoo
New Member
6 years ago
Solved

How to add a dynamic URL to a table

I have a table with over 6,000 individual items in it and what I'd like to do is create a hyperlink for each item so that when a user selects one it takes them to a specific report for that item.   ...
Need Help
Tutorial Requests
  • StooHoo's avatar
    StooHoo
    6 years ago

    So I was finally able to solve the issue by creating an additional column within the data I was working from and creating a formula for that column that was the URL I was looking to send users to with the dynamic variable the item number from another column within the table.

StooHoo's avatar
StooHoo
New Member
6 years ago

So I was finally able to solve the issue by creating an additional column within the data I was working from and creating a formula for that column that was the URL I was looking to send users to with the dynamic variable the item number from another column within the table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    StooHoo how did you solve this issue?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello,


    I wrote an answer, but I've got an error.

     

    I recommend using Measures as much as possible. Avoid calculated columns. Basically follow this Youtube video for help: https://www.youtube.com/watch?v=Wz2aD0XvkUk 

    I'd write the measure in this way, tho:

    urlMeasure =
    var slct = max (you're table[you're column]) // selected value
    return
    "https://www.google.com/search?q=" & slct // put you're URL instead of google

    BR,
    Anton