Populate Document ID Field oninsert

[Ken83]

Hello All,

        I know this particular topic has been discussed quite a bit around the community and every document I've read has been more or less dancing around what my particular issue is. So here we go. I have created a document_id field on a custom table("Approval Base") . This approval base table is the parent table for a couple of other tables. So, my current functionality is that, on any of the extended tables(Table B or Table C), when I create a record, it will generate a new record on the approval base table where the document_id field is.

What I want to happen, is for that document_id field to get populated with the record and table name of the record that generated it. That's all. But, I can't seem to make that happen. Any suggestions on how to accomplish this?

P.S. Another article I read, mentioned querying other tables, etc. The problem with that, is that it can be a large number of tables that can generate an approval base record. I will never know exactly which table is going to generate the record so writing a query for that wouldn't quite work.

[sumeet_n]

Hi Kenneth,

Just wanted to check if the 'Souce table' field is implemented and dependency is defined to that source table..

[Ken83]

I'm not entirely clear what you mean by 'Source table field'. Here is what I have...

I modified the dictionary record for the ID(u_id) field to be dependent on the Table(u_table) field.

[sumeet_n]

You are missing a field (I referred to as Source Table) of type 'Table Name', which you need to link it to your 'ID' field in dictionary in 'Dependent field' tab. And everytime you insert a record and you have to set Document Id field, you need to set the 'source table' field as well.

Please refer below link.

Creating a Document ID Field - ServiceNow Wiki

Document Id field works for my custom table if followed the steps above.

[Ken83]

Ok, so by your explanation, that's what those 2 fields do. See below...

This is an example of one that I manually created. I selected the table name and the record by clicking the magnifying glass for the ID field. I then saved the record, and the table name was automatically populated. That functionality works as expected and as designed. What I need to do, is not have to enter that information manually. If this record were generated because of it's relationship to another table, I need it to automatically populate the table name and ID as if I went through and manually did it.

Edit : So for further context, that example above is one that I manually created. When I don't manually create the record, this is what I get...

That's a screenshot of the the example above from the list view, and another one that I did not manually create. There is no ID or Table captured.