“Add Data to Table" Tool

This tool can be found in our PowerClick Essentials, available FREE to the ServiceNow Community.

As a ServiceNow practitioner, you know that sometimes, there is a need to insert a small number of basic records into a table. Doing this manually can be time-consuming and tedious, particularly when there are several entries to input. While utilizing an import set is an alternative, it can sometimes take even longer than the manual method.

That’s where Altorra's Add Data to Table tool comes in handy. 

You access the tool by selecting the Add Data to Table (ASI) Context Menu by right-clicking the list header, or clicking the vertical ellipsis (⋮). 

A popup window appears with 4 sections:  Table name, Column name, How is the data separated and Data.  The table and field names should be auto populated for you, based on the list view you were looking at and that table's display value column. 

Fill in the values as needed and click on the Add button.  The records will be added to the table.

NOTE:  Leading and trailing spaces are stripped before inserting the data.

The tool has some built-in checks and data validation before committing any changes to your table.  Some informational or error messages may appear on screen to update you on what actions the tool undertook.

In this example, 3 records were successfully inserted into the table, but one (1455 Main Street) was skipped because the tool deemed that it already existed and prevented a duplicate from being created.

The tool will also create an entry in the System Logs:

The tool uses UI Messages now for any message visible to users, to make it easier to localize the tools.

If you still have any questions, comments, or need any support, please reach out to us, by visiting https://www.altorra.com/support

Be sure to also explore the other powerful tools in the PowerClick Essentials, along with our other exceptional products, designed to streamline your daily tasks, boost efficiency, and save you valuable time.