Mapping Order Guide variables to Cases

[Ash33]

Hi experts

I am currently working on a requirement where I need to map the requested_for from the Order Guide form variables to the procurement cases. Since there is no linkage between sc_requests and procurement cases I am unable to find a way to do so. Right now, upon submitting an order guide, all the RITMs requested for fields gets autopopulated as I'm fetching it from the sc_request(order guide), but I need the procurement cases (record producers) included in the order guide to also populate the requested_for. 

Any help would be appreciated.

Thanks!

[Tanushree Maiti]

Hi @Ash33 ,

Order Guide variables do not map directly via OOTB field mapping.

So Use ANY of the following option as per your requirement.

1. If you are using Record producer, use Producer script to map requested_for  with Procurement Case

2. If you are using catalog item, Associated flow/workflow will be there. From there using script, you can map

3. You can run an After Insert Business Rule on the sc_req_item table to extract the variable and map it to the case. 

[AshishKM]

Hi @Ash33 , 

As I understood, you have order guide with ( at least 2 ) or more catalog items clubbed for creating respective RITM -> Catalog Task. 

"Requested For" field on all individual catalog items are populating from order guide first page ( Described Need ) if variable names are same and cascade option is checked. 

Seems like you have other field "procurement cases" on order guide first page and you are trying to transfer the same to next tab ( choose option ) on catalog form. 

Query -> Do you have 2 different "requested_for" field or just one ?  Share the order guide main page screen shot.

Thanks,

AshishKM

[Ash33]

Hi Ashish

I have an Order guide with 3-4 form fields. Field name 1 is {requested_for}

This order guide has multiple catalog items (RITMS) and cases (record producers).

When I submit an order guide, say 4 catalog items are created and 2 cases (record producers) are created. The 4 catalog items have the requested for autopopulated but the 2 cases have the requested_for EMPTY. 

How can I populate the {requested_for} for the 2 cases?

[AshishKM · Accepted solution]

please check if variable name ( not the label ) is same on order guide and record producer. share the screen shot ... also if while filling the form this "requested_for" field value is visible but after submission case created but value not transfer to case means there is mapping issue on record producer form and under laying table ( on which record produce configured ) field.  

check both the details and share screen shot.