Morning everyone, here is the problem
We use a form to scan barcodes, the box we scan has 2 barcodes, one or the other has to be scanned, and as it needs to be dummy proof both need to be handled.
for example K123456 and 123456 so the numbers are the same but one is without a letter in front
The barcode with only numbers who are added in the form (123456) gets the apostrophe infront, the once with K don't.
On the form we need to use the no validation option instead of setting the validation to numbers only, because we need the option to scan and that option doesnt appear when restriction is set to numbers only
So i use no restriction and now im trying to deal with the apostrophe's
I tried alot of different things to get rid of the apostrophe but nothing seems to work, i mean i can set a helper and use a mid() or a isnumber() ... but still when im trying to use the helper data in my formulas they exclude the data from that field in the formula
a simple join collect only shows me boxes scanned with a K infront
=IFERROR(JOIN(COLLECT(Doosnr:Doosnr; Datum:Datum; Datum@row; Methode:Methode; Methode@row; DubbeleDoos:DubbeleDoos; 1); " - "); "")
Doosnr is the helper
any ideas ? why isnt there a way to show the scan option when restrictions is set to numbers only ?