question Re: Combine Script Plus ac columns in reference field syntax in Developer forum

Combine Script Plus ac columns in reference field syntax

anfield — Wed, 19 Mar 2025 17:08:08 GMT

Is there a way to combine a script call and the ref_ac columns attribute on a reference field?

Current reference qual: javascript&colon;'sys_idIN' + getPortfolioProgramIds(current.portfolio, current.getTableName());

I want to add an additional column from the table this is pointing at, which would be something like this:
ref_ac_columns=u_sub_category, ref_ac_columns_search=true,ref_auto_completer=AJAXTableCompleter.

What would be the correct way to have the syntax of both when combined into the reference qual?

The desired outcome is that in the reference field I can display both columns when searching.

(The script above returns programs, and the subcategory field is part of the same record on the same form)

Re: Combine Script Plus ac columns in reference field syntax

Brad Bowman — Wed, 19 Mar 2025 17:14:03 GMT

These are not combined - the Reference Qualifier is fine, and the other things you mention are added to the Attributes field.

Re: Combine Script Plus ac columns in reference field syntax

Ankur Bawiskar — Wed, 19 Mar 2025 17:11:15 GMT

@anfield

both are different things.

ref qualifier helps to restricts

to add additional column add this and use this syntax

ref_ac_columns=u_sub_category;fieldName, ref_ac_columns_search=true,ref_auto_completer=AJAXTableCompleter.

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

Re: Combine Script Plus ac columns in reference field syntax

anfield — Wed, 19 Mar 2025 17:14:00 GMT

Ok. How can i achieve my goal? I want to leave the script as is, but have 2 columns in the reference field displayed

Re: Combine Script Plus ac columns in reference field syntax

anfield — Wed, 19 Mar 2025 17:17:49 GMT

Missed that part. Got it thanks