Pass a catalog item variable to another catalog item from RITM numbers selected in a list collector.

[MB12]

Hi Experts,

I'm not sure if this is possible or not. I have two catalog items (A & B). Catalog item A has a text field (field_1). Catalog item B has a list collector on the sc_req_item table referencing item A RITM numbers. When RITMs are selected from the list collector in item B, I would like to populate another text field in catalog B (field_2) with the field_1 values for each selected RITM. 

Maybe using a list collector for field_2 would work better for this.

Thank you,

[Allen Andreas · Accepted solution]

Hello,

Thanks for posting your question. At this point, you've sort of just listed your requirement that you were given without really telling us:

• What have you tried so far?
• What has worked/hasn't worked?
• Do you have screenshots or script of what you've tried

etc.

This helps us not only help you...but helps you learn. I believe you've asked a good amount of questions on these forums previously to see the value in this approach?

As far as what type of field to use to capture it, that's on you to decide, but if it's a text field, you can find the values from the catalog items select for that variable field on their respective items and then take all those results, concatenate them together (comma separated) and then write them to this field on catalog item B.

You would simply use an onChange client script that uses GlideAjax to communicate with the server, passing all the values selected in that list collector field, querying the RITM table and finding that variable information, then pass it back to the client to then be populated in the field on catalog item B.

This can be done in client or in the workflow/flow, after the fact, if that works for you.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[MB12]

Hi Allen,

I'll be sure to provide more info in the future. I guess I was looking more for some guidance on the best approach to take here. 

Thank you for the explanation. My first thought was to write an onChange client script to pass these values, but thought there might be a better way to do this using a reference qualifier and list collector for field_2.

I'll test out the client script as you described. 

Thank you,