Hi Folks, I have a scannable column which i...

[Freemup_Technol]

Hi Folks,

I have a scannable column which is valid if and only if the first 6 letters of the value falls in a column given in another sheet.

I’ve put a valid_if constraint in AppSheet which looks like

=IN(LEFT([_THIS], 6),ProductMaster[StockCodePrefix])

Now my intent is quite clear. Allow any value inside this column as long as the first 6 letters are matching. However the constraint is being evaluated by appsheet such that any value other then the values in ProductMaster[StockCodePrefix] are being considered invalid.

Any help here ? The intent is to allow the barcodes which start with a set of prefixes rather then any and all barcodes.