Open LINKTOROW in new browser tab

[eddie61]

I'm using the LINKTOROW formula to access a record in another app. This works fine, but loads the new app in the same tab, making it distracting for our users, as they would like to keep the first app running / open. 

Is it possible that LINKTOROW opens the linked app in a new tab, or better, if both apps are open in the browser, it just switches the tab and opens the corresponding record?

Formula:

LINKTOROW([_THISROW], "Ticket Übersicht", "TicketSystem-396133")

Hope this is understandable.

Thanks in advance.

Adrian

[Steve · Accepted solution]

You could try using an action of type External: go to a website. You'll need to construct the full URL--you can't just use the output of LINKTOROW() directly.

[eddie61]

That works perfect, thank you @Steve 

The code I used to make this work:

CONCATENATE(
  "https://www.appsheet.com/start/95b19b11-c64e-406c-8835-da230450c8a5#appName=",
  ENCODEURL("TicketSystem-396133"),
  "&page=dashboard&table=Tickets&view=",
  ENCODEURL("Ticket Übersicht"),
  "&row=",
  ENCODEURL([_THISROW])
)