How to create a hyperlink from an item of a table

1

Hello!

I am looking for a solution to create a hyperlink from an item within a table. I want to create a link which has a standard first part and a variable at the end which is exactly one if the item from my table.

It would look like: www.standard.com/itemfrommylist

I would like to find the formula where I can give the standard part and insert the variable from a table column/row.

Thanks!

2

:wave: Hey there!

Try out the format() formula → Link to Formula Reference

In your specific use case, you could do:

format("www.standard.com/{1}" , thisRow.Item)

More explanation into how the formula works is in the linked reference above

1 Like
3

Dear Scott,

Thank you so much. This was the missing puzzle. However when I do the more complex part it gives me back the error message: Attempting to open an unsafe url… So I don’t know if it is some kind of protection from CODA or my formula is wrong.

So I have a drop-down list and based on the selection I want to create a button which opens a URL, which is created with the Format formula you suggested. The items of the dropdown list is

  • Tempus - E+
  • Tempus - ESC
  • Other NA - E+
  • EACEA
OpenWindow(SwitchIf(
thisRow.Donor=
"Tempus - E+",Format("https://ec.europa.eu/programmes/erasmus-plus/projects/eplus-project-details/#project/{1}",thisRow.[Project reference number],
thisRow.Donor=
"Tempus - ESC",Format("https://europa.eu//youth/solidarity/projects/details/{1}",
thisRow.[Project reference number],
thisRow.Donor=
"Other NA - E+", Format("https://ec.europa.eu/programmes/erasmus-plus/projects/eplus-project-details/#project/{1}",thisRow.[Project reference number],
thisRow.Donor=
"EACEA", Format("https://ec.europa.eu/programmes/erasmus-plus/projects/eplus-project-details/#project/{1}",thisRow.[Project reference number]))))))

So if the drop down item is:

What am I missing? :slight_smile:
Thanks a lot!

4

Dear Scott,

Thank very much for your help, this was a missing puzzle! I managed what I wanted! :slight_smile:

1 Like