Dynamically read value from a table and update the URL in the other table.

Question

Hi All,

I had a query regarding updating URLs. The URL has multiple IDs and I want the ID to be taken from a reference table and replace the ID in URL such that i get multiple URLs with distinct ID.

For example:

URL:

https://api.trello.com/1/boards/ID?fields=name,url&key=a18abc08254680a5912e208a1418e6ac&cards=all

I want the 'ID' to be replaced from reference table.

Note that there are multiple IDs and I need to multiple URL at the out put.

Please find your attachment and help me resolve this issue.

Thanks

Harsh

Book1.xlsx

Kenda · Accepted Answer

Hey @harsha384! If the outside URL will always be the same, simply input your list of IDs and add a Formula with the following expression:

"https://api.trello.com/1/boards/" + [IDs] + "?fields=name,url&key=a18abc08254680a5912e208a1418e6ac&cards=all"

This should create the list of URLs you are looking for. Hope this helps!