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