Order Capture app change ProductID search when adding product

[Alexandros_Mant]

Hi all,

i’m using the Order Capture sample app. I have made a lot of modifications but i’m lost in one last thing.
When adding a new order and you go to add products you get the Product Name. I would like to change that and use the Product ID instead. The best thing would be to be able to search by product ID but also to have the Product name if it is possible.

[Marc_Dillon]

Are you aware of how key vs label works with Ref-type columns?

help.appsheet.com

Row Labels

How to determine which columns are prominently displayed in a view.

You may want to create a new column in Products table that concatenates ID and Name, and use that as your label.

[Marc_Dillon]

The new column should be in Products table in this case.

[Alexandros_Mant]

Hi Marc and thanks for your answer.
I have created the new column but i’m still struggling on how to create that.
From what i have seen that drop down list is coming from a View Ref (Product ID) but i really don’t know how to change that.
Also by creating a virtual column i have access to a different table than the one i want to change in the form.

[Marc_Dillon]

Did you follow the steps in the help article I linked? Which step did you have trouble with?

[Alexandros_Mant]

When im going to add a virtual column it doesn’t let me to select data from a different table.
I’m not sure though if i’m looking on the correct table. I believe it’s in Data->Columns -> Order details

[Alexandros_Mant]

I have created the new column in Products and i have added as a virtual column in Order details but it is not shown at all.
I don’t know what im doing wrong…

[Guy_Merlin_Dyan]

@Alexandros_Mantsios, en espérant avoir bien compris ta préoccupation, La meilleure chose à faire pour cela c’est de cocher simplement les labels (Product ID , Product name ) dans la colonne de la table Product. Ainsi, il sera désormais possible pour toi de voir le Product ID et le product name dans la liste déroulante.
Cette solution fonctionnerait très bien aussi si vous voulez que l’image du produit soit visible dans la liste déroulante.
Courage

[Alexandros_Mant]

@Guy_Merlin_Dyangnou That indeed solved my problem!
When i enable it in the preview i can see both Product ID and Product Name.
But the problem now is that when i click to save the project the label on Product Name is turned off.
I tried many times and it get’s off…