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.
Are you aware of how key vs label works with Ref-type columns?
You may want to create a new column in Products table that concatenates ID and Name, and use that as your label.
The new column should be in Products table in this case.
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.
Did you follow the steps in the help article I linked? Which step did you have trouble with?
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
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โฆ
@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
@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โฆ
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |