Solved

Remove links from Dashboard table data element.

  • 26 January 2023
  • 2 replies
  • 68 views

Userlevel 4
Badge
  • Freshman I
  • 39 replies

Is there a way to remove the hyperlink from a column in a Dashboard Table.

The Default Navigation is unchecked in the underlying GI but some columns still have active hyperlinks An example; we have a Dashboard with a table called “Canceled Retail Orders - Today”, this table shows any Retail order that was canceled for the current day, the columns in this table are Order Date, Last Modified On, Status, Order Nbr, Customer Order Nbr, Customer, Ship Via, and Last modified By. 

There are four columns that have active links, Order Nbr, Customer Order Nbr, which we want to have links, and Ship Via and Last Modified By which we don’t want to have active links. 

In the Generic Inquiry that feeds this table the Default Navigation box in the is unchecked for the Ship Via and Last Modified By but the data in these columns still show they are linked and if the user clicks on the data element, they are taken to the screen that shows the details for that column.

As an example: If I click on any of the data element in the Ship Via column the Ship Via Codes screen opens. What makes this bad is depending on the current login they user could be allowed to make changes.

Thank you!

icon

Best answer by yisroel39 3 February 2023, 04:55

View original

2 replies

Userlevel 3
Badge

Hi Del,

I tested what you wrote, and you are right. The dashboard relinks the field despite having "Default Navigation" unchecked.

The trick I found to get around this is to add the field through the schema formula (e.g. =[SOOrder.ShipVia]). Just make sure to put in a caption for the column.

 

 

 

 

You will also have to put the new column into your dashboard table.

I hope this helps!

Userlevel 4
Badge

yisroel39

Thank you for the quick reply. I will give you work around a try.

Thanks again for your help!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved