Dropdown list in catalog items - How to do it?

[PhFranca]

Hello everyone!

I have a table called Product with some fields, and when I request something, I would like the name (field 'nome') of the product to appear instead of the product code (number).


Dropdown list showing the product code (number) and not the name (field 'nome') as I would like.


It seems like a simple thing to do, but I'm having a lot of trouble.
Could you explain how to do it?
Thank you very much in advance!

Phlavio

[Brad Bowman · Accepted solution]

You can edit the Produto table to change the Display column to Nome

[PhFranca]

Hello, @Brad Bowman  
Thank you very much! It worked perfectly!
It was very simple! haha
I watched several videos and I didn't find anything so simple! hahaha
Again, thank you very much!

Phlavio

[Brad Bowman]

You are welcome!

[vishakhayadav24]

Hi @PhFranca 

this can be achieved by passing the variable attributes under the Type specification section on variable.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;number,ref_ac_columns_search=true,ref_ac_display_value=false

replace the name and number field with the field name whatever you are having in table.

Thank you!!
Vishakha Yadav