HI,
I have a field of type list which is a reference to the user table
It shows me 2 columns: name, email.
I want to search by the 3 columns
search both by name and by email
I would appreciate the help, thanks Shir
Hi @Shir Sharvit,
Since you haven't given the 3rd column name, let's say you want to show employee number field on the list collector. Do the following to achieve that:
- Go to the list collector field's dictionary attribute [Right-click on the field name > Configure Dictionary]
- In the attributes field, provide the following value:
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email;employee_number,ref_ac_columns_search=true
It would look something like this:
Verify on the record field that you have those fields visible in the list collector field:
You can use the reference from this documentation.
Please mark the answer correct/helpful if my answer helps your query
Cheers,
Uttkarsh
@Shir Sharvit Please right click to configure the dictionary of your reference field, click on the advanced view from the related links and add following attributes in attribute field.
Here are the attributes.
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email,ref_ac_order_by=name,ref_ac_columns_search=true, ref_ac_display_value=false
Hope this helps.
