Hi,
The issue is I have inventory items with multiple barcodes and are all in the one column cell separated by a "; " (for example 0930061738693; 789264; 9311111378209) but when I go to add a new barcode with Appsheet it removes the other barcodes.
I have tried to make a separate field where you enter new barcodes and it adds it to the list of barcodes for that item but I can’t seem to get that to work.
Any help would be appreciated
If understanding of your requirement is correct, please try below
-
Create a text type column called [NewBarcode] If you are entering the new barcode by scanning, please make this column scannable. Also please make this column with “reset on edit” enabled.
-
To store the list of barcodes, create another Enumlist type column [BarcodeList]with the app formula setting of the column having an expression [_THIS]+LIST([NewBarcode])
Whenever you enter new barcodes in the field [NewBarcode] , it will append it in the column [BarcodeList]
https://help.appsheet.com/en/articles/2357279-list
https://help.appsheet.com/en/articles/4575684-list-addition
https://help.appsheet.com/en/articles/1013271-column-types-diving-deeper
3 Likes