Multiple Barcodes for one item

[Mearsy101]

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

[Suvrutt_Gurjar · Accepted solution]

If understanding of your requirement is correct, please try below

1.  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.

2. 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

[Mearsy101]

Thank you that worked 🙂