Mapping referenced fields from record producer to referenced fields on case form

Shawn Baar
ServiceNow Employee
ServiceNow Employee

Greetings,

I have a question I feel I should know, but my brain is not getting around this at the moment. I have a number of fields on an HR Talent Management case form that are references to the user table. I also have a record producer that prepopulates values that correspond to those same fields based on which user is selected as the subject person. This part works.

While in the record producer, the person making the request can then make changes to those same fields. Once submitted, I want to map those fields with the new values to the case form. The variables I wish to map from the record producer to the case form do not have the ability to use the Map to field as the referenced fields on the case from do not appear as options to select.

I have tried using the RP script to set the current case field to the producer variable (i.e., current.u_start_date = producer.start_date) as well as even trying to query the user and setting the user record directly (not my favorite option, but I was experimenting). None of these populated the fields on the TM case form.

Is there a quick way which I am not envisioning at the moment to make this happen? Or do I just need to break down and recreate those fields as non-referenced fields on the Talent Management table?

Any assistance with this is greatly appreciated. 

Shawn

#toomanyhoursatthekeyboard

1 REPLY 1

Mohit Kaushik
Mega Sage
Mega Sage

Hi Shawn,

I am not sure how far I understood it correctly, but if the fields on the case form are reference from the user table, then why not bring those fields by dot walk from user table on case table, where you can have just one field as reference to user table and then the other values can be populated directly from the user table the moment user field is selected.

In that case you will be saving a lot of scripting I feel.

Please ignore if I understood it wrong.

 

Please mark this as correct and helpful if it resolved the query or lead you in right direction.

Thanks,
Mohit Kaushik
Community Rising Star 2022

Thanks,
Mohit Kaushik
ServiceNow MVP (2023-2025)