How to push Record producer name into a custom field on the form created by the very Record producer.

ravikiran0688 · ‎03-10-2022

When a case is created using a record producer, we want the name of the producer to be updated in one of the custom field on the case form.

@Ankur Bawiskar @Allen Andreas @Sandeep Dutta

Ankur Bawiskar · ‎03-24-2022

Hi,

you mentioned your custom field is reference to sc_cat_item_producer table

So you just had to use this and use correct field name

cat_item.sys_id -> gives sysId

current.u_customField = cat_item.sys_id;

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

ersureshbe · ‎03-10-2022

Hi,

What is the custom field type.

If it free text field you should hard code the name.

If it reference field you should hardcore the sys_id.

Regards,

Suresh.

Regards,
Suresh.

ersureshbe · ‎03-10-2022

I can see you mentioned as record producer and you custom field should not map it to catalog item table with reference field. Check the record producer name present in catalog item table as well. Can you check that point? Regards

Regards,
Suresh.

P-Rudenko-SN · ‎03-10-2022

Please have a look at ServiceNow Guru, there this topic is well described: https://servicenowguru.com/reporting/identify-servicenow-record-producer-create-record/

ravikiran0688 · ‎03-10-2022

Hi Pavlo,

I had come across this article but as mentioned in the article this BR needs to be updated in every single RP's and the issue with us is that we have 150+ RP's.

Ankur Bawiskar · ‎03-10-2022

@ravikiran0688

Did you check my above response?

It should work fine

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader