Linking custom Grid to Order Entry

This is my first real attempt at Application Studio, so apologies is this is basic. I made a dashboard and layer from a uBAQ in app studio. Ideally, end users would be able to click on the order number which would take them directly to the Sales Order entry page with that SO loaded.
I have the column set as a link and made an OnClick event. It does launch SO Entry, but it errors.




You mentioned you’re using a BAQ.

If you’re including the OrderDtl table in your dashboard via rest call, what you have seems correct. But if the results of the your query are being stored in a custom dataview, and that’s what you’re trying to use as the source…

I would assume your BAQ may contain the OrderDtl.OrderNum column?

If so, I think your JSON “valueIn” would be set to
"{YourDataView.OrderDtl_OrderNum}"

2 Likes

Thanks for the response dcamlin! I tested today and it works fine.
Do you happen to know how to open it up in a different company than the one you’re in? BAQ is accessible to multiple companies in the system, but this valuein will only work for Orders in the current company

Unfortunately, there’s no easy/clean way in App Studio to switch companies (yet?).

This thread has some work arounds that might be worth exploring if this is crucial for you:

1 Like

Here’s another one I just saw mentioned:

https://www.epiusers.help/t/kinetic-company-site-switcher-extension/129795