We have an application outside of Acumatica that has a page that accepts an order number in the URL. I want to create an Acumatica report that has a row for each filtered order and a column with a clickable link that will open this external dashboard in a new window, passing the order number in the URL.
I've gotten as far as creating a column in the Results Grid with a formula:
=Concat( 'DASHBOARD_URL', [SOOrder.OrderNbr])
How could I make this field into a clickable link? Or is there a better approach to this?