question Mapping Record producer field to HR case form field in Community Central forum

Mapping Record producer field to HR case form field

Community Alums — Wed, 04 Sep 2024 15:29:53 GMT

Hi Team,

On a record producer I have tried to map a Lookup select box with category field on a Hr Service Case form using record producer script.

I have used below script but instead of mapping with the choice already defined, it is creating the new choice in category field. Please help me on this?

Record producer (filed):- tool_provision (value comes in "u_variable option" table)

HR case form (field) :- u_hr_service_category (it is a Custom Filed and Value Comes in sys_choice table)

Script :-

var cat=producer.tool_provision.toString();

current.u_hr_service_category =cat;

note-Without Field map we need complete this functionality (using record producer script)

Re: Mapping Record producer field to HR case form field

Sandeep Rajput — Wed, 04 Sep 2024 17:24:21 GMT

@Community Alums Can you share the type specification screenshot of your look up select box.

Also please confirm if u_hr_service_category is a reference field or a choice field, and if tool_provision returns a sys_id or a choice value.

Hope this helps.

Re: Mapping Record producer field to HR case form field

Community Alums — Wed, 04 Sep 2024 17:45:07 GMT

Hi @Sandeep Rajput

u_hr_service_category is a choice field and tool_provision returns a choice value

Re: Mapping Record producer field to HR case form field

Sandeep Rajput — Wed, 04 Sep 2024 18:51:30 GMT

@Community Alums HR Service Category is a dependent field. Could this be the reason why a new choice is getting created?

Re: Mapping Record producer field to HR case form field

Community Alums — Thu, 05 Sep 2024 04:14:12 GMT

@Sandeep Rajput

How to overcome this Issue ?

is there any script for mapping the correct Value ?

Re: Mapping Record producer field to HR case form field

Community Alums — Thu, 05 Sep 2024 04:26:10 GMT

Hi @Community Alums ,

Please refer to the threads:

https://concurrency.com/blog/servicenow-dependent-variables-on-record-producer-in-service-catalog/

https://www.linkedin.com/posts/s%C3%A9bastien-martin-ba580622_servicenow-servicecatalog-selectboxdependency-activity-6963043691951271936-vDRv

and this video : https://www.youtube.com/watch?v=4ur_fdsxsLs

Re: Mapping Record producer field to HR case form field

Community Alums — Thu, 05 Sep 2024 04:30:56 GMT

Hi @Community Alums

without filed map means by using Record producer script we need to complete this functionality

Re: Mapping Record producer field to HR case form field

Community Alums — Thu, 05 Sep 2024 04:34:50 GMT

Hi @Community Alums ,

Have you looked at the links i shared? worth checking