Document ID Field

[amol_joshi]

I have a field with type "Table Name" and another field with type "Document ID".

I want to use a script to add another table as a reference in the "Table Name" field and one of the records from that table into the "Document ID" field.

I just can't do it.

For Example:

var gr = new GlideRecord('incidebt');

gr.setLimit(10);

gr.query();

while(gr.next()){

var gr2 = new GlideRecord('u_test_table');

gr2.initialize();

gr2.u_table_field = 'incident';

gr2.u_record_field = gr.getUniqueValue();

gr2.insert();

}

Any clues?

[DrewW]

Well in your script I'm going to guess that incidebt should have been incident and you need to fix that.

[amol_joshi]

Thanks for that Drew, I realised it after I pasted it and I fixed it as well. Now I can get the field with "Table Name" data type accurately pointing to the "incident" table but I can not get the other field with "Document ID" data type to populate with a record from the Incident table. Please help.

I want to see something like "Incident: INC000225522" in the "Document ID" type field. Thanks.

[Bert_c1]

Hi amol_joshi,

I don't see any problem with your script, I am guessing that 'u_record_field' on  the 'u_test_table' table is defined as a Reference field for the 'incident' table.  If so, I expect your script to work.  But then that field on u_test_table will show the number field from the incident table, and not "Incident: INC000225522" on the u_test_table form.

I now see your defined it as a Document ID field, and that will require more work. I don't use that field type.

[jonsan09 · Accepted solution]

The dictionary entry for the needs to have the 'Use dependent field' set to true and have it point to a field on the on your table that has field type set to 'Table Name'