question Custom Field Mapping to Catalog Item variable in Community Central forum

Custom Field Mapping to Catalog Item variable

SantushtS — Tue, 11 Mar 2025 17:11:44 GMT

Hi,

How i can map the custom choice type field(Educational unit Impacted) that is created on RITM table to catalog item variable(Educational Unit Impacted), so that after submitting the form from portal the value should be reflected in RITM custom choice field as well which coming under variables as APEI but not on RITM custom field.

Re: Custom Field Mapping to Catalog Item variable

Rohit Singh — Tue, 11 Mar 2025 17:31:45 GMT

Hi @SantushtS ,

If you creating SC Task using Flow Designer then you can do following to map RITM Field with the Catalog Variable (Both should be of same Type of Field/Variable):

Update RITM record using Update Record Action.
Select your RITM Field "Educational unit Impacted" and map it with Variable "Educational Unit Impacted" using data pili picker.
Refer below snip.

If my response helped, please mark hit the Thumb Icon and accept the solution so that it benefits future readers.

Regards,
Rohit

Re: Custom Field Mapping to Catalog Item variable

SantushtS — Tue, 11 Mar 2025 17:52:17 GMT

Hi Rohit,

Thanks for reply I can not use flow designer since i need to do it for all the catalog items . Please let me know if there any other workaround to resolve this issue

Thanks,

Santusht

Re: Custom Field Mapping to Catalog Item variable

Rohit Singh — Tue, 11 Mar 2025 17:58:49 GMT

Hi @SantushtS ,

Do you have "Educational Unit Impacted" this variable for all catalog items?

Regards,

Rohit

Re: Custom Field Mapping to Catalog Item variable

SantushtS — Tue, 11 Mar 2025 18:12:45 GMT

Hi @Rohit Singh

Yes, I have created a variable set having this one variable(Educational Unit Impacted) in it and i will use that variable set for all catalog items .

Thanks ,

Santusht

Re: Custom Field Mapping to Catalog Item variable

Rohit Singh — Tue, 11 Mar 2025 19:12:55 GMT

Hi @SantushtS ,

In that case you can utilize sc_item_option table. In this table record of variables gets created with it's value.

Create a flow with trigger point Requested Item Created
Look up record on sc_item_option table.
Question contains Educational Unit Impacted. Don't use Question is Education Unit Impacted (Because every time a SC Catalog triggers with Educational Unit Impacted variable it will create a record with that value in Question).
Now you have to opt that value of Education Unit Impacted which is recently created every time. Hence Order by Created and in Descending Order.
Now update your RITM record in next action and update your RITM field with the sc_item_option Question Value.
This will work for all Catalog Items. Here in example I have taken sc_task
Also make sure that you are not creating any other variable which conatins "Education Unit Impacted" in name other wise system will not able to recognize which question needs to be picked for assigning value.

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

Regards,
Rohit

Re: Custom Field Mapping to Catalog Item variable

SantushtS — Tue, 11 Mar 2025 19:38:13 GMT

Hi Rohit ,

Thanks for your information just one more can i do it for RITM and catalog task both for all catalog item .

Thanks,

Santusht

Re: Custom Field Mapping to Catalog Item variable

Rohit Singh — Tue, 11 Mar 2025 20:56:38 GMT

Yes, you can.

Please mark my response as helpful and also accept my solution.

regards,

Rohit

Re: Custom Field Mapping to Catalog Item variable

Rohit Singh — Wed, 12 Mar 2025 10:54:37 GMT

Helllo @SantushtS

Yes, you can.

Please mark my response as helpful and also accept my solution.

Regards,

Rohit

Re: Custom Field Mapping to Catalog Item variable

Ankur Bawiskar — Wed, 12 Mar 2025 11:08:02 GMT

@SantushtS

Why not use after insert business rule on sc_req_item table and handle this and it will work for all RITMs whose catalog item has that variable?

Ensure choice values are same between the variable and field on RITM

(function executeRule(current, previous /*null when async*/) { // Add your code here current.fieldName = current.variables.variableName; current.setWorkflow(false); current.update(); })(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.