Hello,
I am looking for a solution to my app for ordering. So far I use (among other functions) 3 tables to record orders.
Products (all articles saved)
Orders (all orders)
Order Summary (All items from the orders)
Unfortunately, at the moment I can only add articles to the orders by scanning the EAN/barcode.
The rest of the entries (price, name, article number etc.) are taken from the products by Lookup Thisrow.
My wish would be that if I don't have a barcode available, I can still add the item by name & item number.
If I don't scan the EAN field and tap on it, I get the list with the EANs. It would be cool if the name and article number were also at the end and I could also search for them. Of course, only the barcode should be inserted in EAN.
So far, I have tried to create a virtual column in Products to merge these two designations & mark these as "Label".
In the Ordersummery I have set the EAN Scan entry as "Ref" (point to products)
nd tried to show the generated name next to the barcode.
I get yellow triangles next to the barcode.
How could I add items without affecting my basic function (scanning to capture).
Only if no barcode is available should I be able to search by name and or number and fill the fields again based on that.
Do you understand what I mean?
For reference a few Pictures
Thank youfor your help!
... is there really nobody who can help me with that? ๐
This problem has already arisen. I think they treat it with 2 separate fields.
In case it helps you:
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Columna-ref-scanea-columna-Barcode/m-p/648571
Asked my GPT of choice. I did not get a chance to test it, but maybe it helps:
Refining the Products Table:
Adjusting the Orders Table:
Handling the Selection:
Autofilling Other Details:
Handling the Yellow Triangles (Warning Icons):
Hola, creo que es un tema de configuraciรณn de la tabla productos en campo EAN/BARCODE debe estar como texto.
Saludos.
Hey guys,
thank you for your help.
I've just been working for hours on realizing my idea. But still without success....
I tryed multiple ways..
A strange problem has arisen:
I have already created in Products: DisplayName with Concanate.
I have now created another column in my order summary -> (ProductSelection)
This has the suggested value: SELECT(Products[DisplayName], TRUE)
In the PC version, i.e. in the editor, I can select the entry and the entries are displayed as desired.
On the smartphone it shows me the column, but when I want to select, the list is completely empty.
How does that happen? App and editor are updated...
Maybe I could use this method to fill the values.... But unfortunately no entries in ProductSelection.
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |