What is ref_ac_columns and how to use it?

[Madhan007]

I have these requested for and Associate ID fields referring to the sys_user table in the catalog item form.I want these fields to be filled automatically bases on the logged in user using ref_ac_columns.Can someone tell me how to achieve it?

[Ravi Chandra_K]

Hello @Madhan007 

Greetings!

ref_ac_columns Specifies the list of reference table columns to display. Separate column names with a semi-colon. For example, ref_ac_columns=user_name;email;sys_created_on allows auto-complete to match text from the user_name, email, and sys_created_on columns.

example:

basically if you want to show users associate id and model, then you can use ref_ac_columns attribute.

for your use case, since you have two different variables already, it ahs to be done through on load client script or default value from the table.

Please hit the thumb and Mark as correct based on Impact!

 Kind Regards,

Ravi Chandra.

[ConstantineVac]

Great, thank you for the thorough explanation!