Delete entries from enum list

[Andrew8228]

Hi all

I've put together a database app that with a barcode function. Because I'm using sequential barcodes with no repeats, the same item/row might have several barcodes assigned to it if I have multiples of the same item. To achieve that I have a "barcode" field that resets on edit and an enum list "barcode list" with the following formula: CONCATENATE(CONCATENATE([_THIS]," "), [Barcode])

When an item is used, I would like to scan its barcode into a different column "used barcodes". What would be the best way to either exclude the "used barcodes" from "barcode list" above or create a new list that displays the barcodes in "barcode list" minus the ones in "used barcodes" so when looking at the app, I only see the barcodes for the items that are not yet used up?

[Marc_Dillon · Accepted solution]

Start here:

https://help.appsheet.com/en/articles/4575802-list-subtraction

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

-----

Additional questions/info:

You have an EnumList column with a CONCATENATE formula? That doesn't make any sense. Maybe you just meant Enum? But why would it need to be any Enum if it has a formula? Enums are for presenting a dropdown of choices.

CONCATENATE allows any number of arguments, you don't have to nest them like that. Also you can just use "&" to concatenate things together. Like:

[_THIS] & " " & [Barcode]

[Andrew8228]

Thanks Marc. I was using Enum (not EnumList) and it was based off a solution I found online for a similar scenario. I've now changed it to [_THIS] & " " & [Barcode] as you suggested and it's achieved the same thing - thanks. 

With the subtraction, I then created a virtual column with app formula LIST(LIST([Barcode List)-LIST([Used Barcodes])). That seems to be working well for items with a single barcode in the "barcode list" but when there's more than one, the resulting list is identical to "barcode list" and it doesn't seem to be removing entries in "used barcodes". How do I resolve that?

[Marc_Dillon]

Nothing that you're describing makes any sense, so I have no idea how to help you. Please show (many) more details about what you're doing. Use screenshots, show us your data and data structure, etc...

[Steve]

This:

LIST(LIST([Barcode List)-LIST([Used Barcodes]))

should be:

LIST([Barcode List)-LIST([Used Barcodes])