Skip to main content

How do I Find a Table Name Using the Table ID for Docuref and Attachments? - Knowledgebase / Lasernet FO Connector / Lasernet FO Connector FAQs - Formpipe Support Portal

How do I Find a Table Name Using the Table ID for Docuref and Attachments?

Authors list

The purpose of this article is to provide a guide to finding a table's name when you only have the Table ID in Dynamics 365. This is a process that can be used when an attachment is added in Dynamics 365 but the name of the table is needed for the Lasernet Connector attachments setup or when using the Docuref table which uses RefTableID. Alternatively, this can be used to find the table ID when you have the table name.

Steps

Please follow these steps:

1. Use SysTableBrowser to open the SysTableIdView and find your table name with the table ID. On the browser, add this to your URL:

&mi=SysTableBrowser&TableName=SysTableIdView

This will open the table which contains the ID column and Name column. 

2. Here, you can click on the ID column and search for the table ID using the standard Dynamics 365 filtering options.


Example

You have added an attachment, in this case an image, to an area in Dynamics 365 and want to add this as an attachment on a Lasernet report. Follow these steps:

1. Click on the paper clip icon to open the attachments for the record.

2. Right-click anywhere on the form and select Form information > Form name.
A form information dialog will come up. 

3. Scroll down to the Administration fast tab and get the RefTableId number from the Query Statement.

4. Use SysTableBrowser to open the SysTableIdView and find your table name with the table ID and add this to your URL:

 &mi=SysTableBrowser&TableName=SysTableIdView.


5. Now that you have the table name, you can open your query report's Query wizard, add the needed table and configure the attachments.

 

Helpful Unhelpful

3 of 3 people found this page helpful

Add a comment

Please log in or register to submit a comment.

Need a password reminder?

Share