I want to create more text fields and add serial number

I have a Store Computer and I need create orders with serial number by product
for example:
I sales two mainboards and i want to creare orders with quantity, description, serial number and price
The serial number is unique and isn’t same as the product code
If i sales two mainboards with 123 product code i have two serial numbers: A1234 and A567
I want to enter data in the form and if a put in column quantity two so i want to scan a twice
The result of the serial number would be: A1234,A567

2X_2_24c889c523ee3b6781217ea86bdc2c9f949092a8.png

Please!
Thanks you

0 20 1,262
20 REPLIES 20

Steve
Platinum 4
Platinum 4

Set the column type for the Serial Number column to EnumList with a base type of Text. Optionally set the initial value expression for the Quantity column to COUNT([Serial Number]) to automatically set the quantity from the number of serial numbers entered.

Thanks Steve but it doesn’t work

Let me look the screen

In what way doesn’t it work? Is there an error message?

The application doesn’t let me enter data when I put enumlist

Can you provide a screenshot of the column definition pane showing more information?

Yes of course!

Does the column have a Valid_If expression? If so, what is it?

I create valid if in columnd [Quantity] but in columnn [Serial Number] don’t have “Valif if”
look

Please show me the rest of the column definition. Almost there!

Yeah!
Column Serial Number

I can’t scan barcode
2X_5_547a39a655360f270b0ec6bd0908cd80fa6cc86f.png

Ah, looking at a test app of my own, you can’t use the scanner with EnumList.

If I subscribe to Appsheet, would they develop it?

I don’t know…

Is there any other solution? another way to do it?

Nothing I’d call simple. Others might have suggestions. @LeventK?

Please! i need solutions

I have other query please
I want to add a button, let me show the example


I have 2 tables: Orders and Order Details
I create other 2 tables: Buys and Buy Details
I use a sample app “Order Capture”

I did the same steps to get that ADD button but it doesn’t appear in my new creation

It sounds that the Ref column’s option “Is a part of” is set to FALSE.

Hi @Cyber_Driver_Corpora Enable “Is part of” here .

Thanks you so much!!!

Top Labels in this Space