Please help with Multirow variable set populate values

[Lisa Goldman]

Hello, 

I have been struggling to figure out how to link the two tables and get the data populated.  I hope someone can help. 

I would like to populate variables in a Multirow variable set based on the selection of the part number variable.  If a part number is selected, then populate the part description, Qty and Price variables  

Table: u_part_number

Columns: part_id   (Primary Key)

                 part_no

Table: u_part_detail

 Columns:  part_id (Primary Ke)

                   part_description

                   qty

                   price

Muti Row Variables:  Part No (Reference field)

                                    Part Description (Single text)

                                    Qty (dropdown)

                                    Price (dropdown)

[AshishKM]

Hi @Lisa Goldman , 

Create MRV ->Part No ( variable = part_no ) reference to table u_part_number

For Part Description (Single text) reference to table u_part_detail with reference qual

javascript: 'part_no=' + current.variables.part_no'

Check with this update and confirm if its working for, assuming variable name as part_no , in both table and MRV. You can change as per configuration.

-Thanks,

AshishKM

[Lisa Goldman]

Thank you for helping @AshishKM 

I have been trying to get it work, but still no luck.  The reason why it did not work is because the variable contains sys_id instead of the actual value.  Is it possible to convert it to display value.

[Amit Verma]

Hi @Lisa Goldman 

Can you try updating the reference qualifier as below :

javascript:'u_part_id='+current.variables.part_id.getDisplayValue();

Thanks & Regards

Amit Verma

[Lisa Goldman]

Hello @Amit Verma 

I made the changes based on your suggestion.  It is now displaying the actual value in the lookup box.  However, the value did not get refresh when I select difference part no.  Could you provide suggestion.  Thank you