How can we display First Name and Last name for a reference field search

[Aswathy3]

Hi All,

We have a custom table "Contractor" for storing contractor users details and by using the autonumering we have assigned contractor ids for them.

Now tried to create a field in one catalog item which references this "contractor" table. In the dropdown option of this field showing only the contractor Id (numbers), How can we get First name and Last name along with its contractor id available in dropdown option.

Thanks

Aswathy

[Sumanth16 · Accepted solution]

Hi @Aswathy3 ,

1. Navigate to the reference variable
2. Under Related Links,, click Advanced view
3. In the Attributes field, enter a comma-separated list of auto-complet attributes:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=first_name;last_name;email,ref_ac_columns_search=true

          4. Click Update

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[Aswathy3]

Thank you Sumanth!