How to get current record producer variable names as choices to a field

[Mr_Vin]

Hi All,

Can anyone accept this challenge?

I have an interesting requirement to get the record producer variables as a choice list ( should be able to select multiple ) to a field in the record producer. And, the choice list must be built by pulling current record producer variables.

for EG:

1. I have created a field 'u_rp_variables' on 'sc_cat_item_producer'

2. I have sample record producer 'My_record_producer1' and it has variables 'short_description','description','comments'

3. Now, I would like to get those 3 variables as choice list and I should able to select two of them.

Any suggestions/guidance is much appreciated.

Thanks

Vino.

[Patrick Schult2 · Accepted solution]

Can you provide more information about what it would actually be used for? This seems like a very strange requirement.

There are no multiple-choice field types available for you to use here, but if you just want to select multiple related records, use a List field which references Variables (item_option_new). This field type can take a reference qualifier, which you would use to limit the available choices to just variables which belong to the current record producer.

[Mr_Vin]

First, Thank You very much Pat for the reply....

Long story short: I need to pass the selected variable names to onload ajax. The ajax will save the data entered in those variables as user preference. When the user try to access same record producer it will fetch the previous values from his user preference and repopulates the form.

I am kinda stuck in writing ref qualifier.. could you help please?

[Patrick Schult2]

I'd use this for the reference qualifier. In the Dictionary Entry for your "RP variables" list field, select "Advanced" for Use Reference Qualifier, then enter this in the Reference qual field:

javascript: 'cat_item='+current.getValue('sys_id');

[Mr_Vin]

Thanks Pat, that worked like a champ. Could you tell me, What should I write in ref qul code, if I wanted to filter out container variables out.