Here is a small tip (some of you might already know it): the GETURL together with the HYPERLINK can be used to run objects in NAV 2013 (even tables 🙂 ).

I am working on a tool to delete records from a database (to ‘clean’ a company from transactional data for example). Part of this tool is a function to view the data in the tables, and for this I needed a way to run a table from the NAV 2013 windows client (not the development environment). This turned out to be quite easy using the GETURL and HYPERLINK functions.

Here is an example of how it can be applied;

This record deletion tool will consist of a list of tables where a user can check the Delete Records checkbox for the tables where all data should be deleted. To assist the user in determining if records should be deleted or not a function to run the table to show the data will be in the ribbon of the page. The function will run the table of the line that is highlighted based on the Table Id field.

The code for this is as follows.

The GETURL is used to build the link to the table and the HYPERLINK is used to open the link.

Now when the user clicks View Records Dynamics NAV will open the table and show all records just like if the table was run from the object designer.

Nice isn’t it!? 🙂

The tool itself to delete records might be something I publish here on my blog later.

Probably one of my shortest blog posts, I got a bit tired of writing about subcontracting so I thought it was time for a short more technical post in-between. 🙂