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,229
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