I have a data table and, for the sake of making this understandable, it has several fields, but the first field is the "name". The "name" in this situation is the name of an application. I want to create the data table so that when the user clicks the "name" in the data table it takes them to a link that displays the application in a different software platform. The catch, however, is that the link to the other software platform doesn't reference the name, it references the "local_id" (which is also a field I have in the index).
So my question is this, is it possible to change the name field to a URL, BUT to make it reference the value of another field? In other words if I have
name = Application 1
Local_ID = 44456
URL to the application is: https://something.org/local_id/44456
I know that I can create a URL template and reference the value of the field using the {{brackets}} but from what I can tell the only thing I can reference is the field that I'm working in. In other words is it possible in the name field to change it to a URL and create a URL template that says:
https://something.org/local_id/{{VALUE OF LOCAL_ID}?
FWIW as a workaround I created the name field in the data table and then created the local ID as the second field and simply created a label that says --> and then labeled the field as "CLICK HERE" so at the top it says "click here" and then I have a funny looking arrow that is linking to the right spot - but I'd prefer to just make it the name field and do away with that.