Pulling in an existing table to use in App Engine Studio

[Will Dollinger]

We have an existing table that I want to use in an application but under Data to use existing table it only shows ServiceNow tables. I don’t want to rebuild the table and can’t see any way to add it to the application.

[Community Alums]

Hi @Will Dollinger ,

Create a table from an existing table

Add a data table to your application by extending a table that you or someone else previously created.

About this task

There are several tables that your organization is already using in other applications. For example, your organization may be using the Incident [incident] table for its Incident Management application. You can create a table for your application by extending any of these existing tables.

Table extension means enabling a table to share fields and records with a parent table. You would extend a table if you expect users to fill in similar fields as an existing table. For example, to create a ticketing type of table, you would extend the Task [task] table. The Task table includes fields that are standard for most work tickets, such as Number and Assigned to.

After extending an existing table, you can further customize the new table by adding more columns.

For more information on extending tables, see Table extension and classes.

Procedure

1. From the My Apps page, open your application.
2. In your application, next to Data, select the add icon 
3. Select Create from an existing table, and then select Continue.
4. Select a table to extend, and then select Continue.
5. On the form, fill in the fields and then select Continue.

   Field	Description
   Table label	Unique label to identify the table.
   Table name	Database name for the table. A table name is created automatically after you enter a table label. You can edit the name if needed.
   Make extensible	Option to allow other tables to share data from this table. For more information on table extension, see Table extension and classes.
   Auto number	Option to track table records with a unique number. If you select this option, define the Prefix, Starting number, and Number of digits.
   Prefix	Abbreviated name of the table to append to the beginning of the record number. For example, if you are creating a "Laptop" table, then your prefix may be "LPTP" or "LT."
   Starting number	Number to identify the first record created for your table.
   Number of digits	Maximum number of digits to allow in the record number. This value determines the highest possible record number. For example, if you enter 7, then the highest possible number is 9999999.

6. To review the columns that were added to your table, select Edit table.
7. In the new tab that opens, review the table columns.

   Each table column appears as a row in Table Builder.

   A lock icon 

   appears next to columns from the extended table. You can't modify these columns

8. Customize your table by adding table columns.
   1. In Table Builder, select + Add new field.
   2. On the blank row, fill in the fields.

      Field	Description
      Column label	Unique label for the column.
      Column name	Database name for the column.
      Type	Type of information that the column contains. For example, to contain plain text in the column, select String. Depending on the type that you select, fill in the additional fields to further define the table column. For example, if you select String, define the character limit of the string input. Or, if you select Choice, define the choices that users can choose from.
      Reference	Table that is associated with the column. This field applies only if the column type is Reference.
      Max length	Maximum number of characters that users can enter in the field.
      Default value	Value that populates the field automatically after a new record is created.
      Display	Option to set the column as the display value for the table. A reference field shows the display value of the table to which it is referring. For example, the Opened by column of the task table refers to the user table. Because the display value of the user table is the user name, the Opened by field shows something like Beth Anglin or Joe Employee. When you select a display value, choose the table column that would act as an appropriate title for individual records. Only one column can act as the display value for a table.

[Will Dollinger]

I don't need any of that information as my question is about custom tables, not ServiceNow tables such as Incident. As I mention in my question, I can add ServiceNow tables, but I don't see any of my custom tables under existing tables list. 

[Flavio4]

Hello Will,

you should make your existing table visible in the new application where you want to use it.
The following (for San Diego) could help:

https://docs.servicenow.com/bundle/sandiego-application-development/page/build/applications/task/set...

Cheers
Flavio