How to enable autopopulate matching values when start typing

[sunil maddheshi]

Hello everyone!

I have a catalog item, where I have a reference field which is referring to a custom table, My issue is when i start typing in this field, it is not poping out matching values. Could you please help me, how to make this work> Here are some screenshots and variable attrubute i tried so far.

[Ankur Bawiskar]

@sunil maddheshi 

any query business rule is blocking some records?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[sunil maddheshi]

@Ankur Bawiskar  there is no Query BR on this Table. When I am searching with * then values are populating but when just typing then some of the values are not showing in matching records,

[Ankur Bawiskar · Accepted solution]

@sunil maddheshi 

how many such records are there?

any leading space is there in that text?

[sunil maddheshi]

Hi @Ankur Bawiskar  Thanks this was the real culprit, there was trailing spaces in some of the Products, I removed them and working fine now. Thanks Again!

[VaishnaviK3009]

Hi @sunil maddheshi ,

This issue occurs because reference fields search only on the Display field by default.

 Fix:

1. Go to your referenced table (e.g., u_products)
2. Make sure the field users search (e.g., product name) is set as Display = true

OR

Use variable attributes for multi-field search:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=u_product

Also, verify:

• Data exists in the field
• User has read access (ACL)

Mark this as Helpful if it clarifies the issue.
Accept the solution if this answers your question.

Regards,
Vaishnavi
Technical Consultant