Need to fill "Approving" - document_id field on the Approvals form view (table approval sequence)

[Milan13]

Hello,

I am trying to fill the "Approving" field with REQ number (first screen shot) and as it is document_id field I added 2 fields to table sysapproval_approver   and used  code (second screen shot) which I got from a community thread.

The desired outcome is that the field "Approving" is filled with for examle "Request: REQ0010364", to be perfectly honest do not even know where the text "Request:" is automatically coming from.

This is making me a kind of confused and I am just wondering whether someone can bring some shed of light into this.

Appreciate your help,

Milan

[Ankur Bawiskar]

Hi Milan,

The prefix is coming because it is a document_id field

If you populate table_name as sc_req_item it will show Requested Item

it shows the name of the table whose sys_id you are storing

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Mark Roethof]

Milan,

Yesterday you posted a similar question. I responded with how this works, because it's a document id field + a table field which you will find in the XML. I also mentioned why it is showing Request:, this is because it's showing the table + the display value of the record (document id). In your case Request:, because the display value (short_description of the request) is empty.

Somehow, you are now posting almost the same question again. Why? Also you deleted the post from yesterday?
https://community.servicenow.com/community?id=community_question&sys_id=194fd0bcdb18801413b5fb243996...

Kind regards,
Mark

---

LinkedIn

[Milan13]

Hi Mark,

you are right I deleted the post as I guessed it would be better to start again...there is a bit of more than one thing going on here, so I might have overlooked something, thanks for your advice again.

Milan

[Mark Roethof · Accepted solution]

About the "Request: REQ0010364".

You have to check what the display is for the sc_request table. I guess it's the short_description if I remember your image from yesterday. So if you want to display the REQ number there, you would have to change the display (obviously this would impact everywhere you are using the displayvalue for Request!!!).

Maybe "Request: Somet short description here" is also fine for you? Though then be sure the short_description field on sc_request is always filled.

Kind regards,
Mark

---

LinkedIn