Trying to get my head around this workflow. Basically, when adding stock I need to just scan the barcode not have the barcodes from products populate. I need it to look like the product barcode form where I can just scan it, and not have it populate like the last photo. I have tried to change the โtypeโ from ref to text but it seems to break the app.
Solved! Go to Solution.
I created a little tester app to play with this.
You had mentioned you had โturned offโ the Scannable property for testing. If that is off then the setting โAllow scan input overrideโ is essentially ignored and you will still get the dropdown.
If you have โScannableโ on and โAllow scan input overrideโ off, then you should get a scannable field with NO dropdown. However, it does still compare the scanned entry against the existing list and if the scanned barcode is not present you will get this message:
I hope this helps!
If I understand correctly, you want the Add Stock form โProduct Barcodeโ field to look like the โProduct Barcodeโ field in the Dynamic Inventory Form so you can scan in the product barcode.
If so, then it seems like the โScannableโ property is not turned on for that Product Barcode field. Youโll find this in the โOther Propertiesโ section of the column definition. See the image below
Thank you, I turned the bar code scanning off for some testing as I am using a zebra scanner. However that is not the issue, the issue is I donโt want barcodes to populate when adding stock.
Forgive me, now Iโm confused. You donโt want them to populate where? In the field, or as a dropdown list?
I donโt want the dropdown list to appear when a user tries to input a barcode. Im having a hard time explaining it, sorry! Thank for you help.
As I thought about it more, I realized you are wanting to scan in a NEW barcode and not have them have the capability to chose an EXISTING one.
The dropdown list is controlled by the Valid_If property in the column. You must have some SELECT() statement in there. Remove that and you should be good.
No Valid_If property, but it looks like appsheets adds it on automatically. Trying to find a way to make the input valid no matter what it is.
If you have no Valid if expression for a Ref-type column, AppSheet will automatically provide the pop-up youโre getting. You can affect that behavior by setting a Valid if expression. Either of the following expressions will accept a recognized scanned barcode without producing the pop-up:
AND(TRUE, IN([Product Barcode], barcode-table[barcode-column]))
OR(FALSE, IN([Product Barcode], barcode-table[barcode-column]))
Replacing barcode-table
with the name of the table that identifies known barcodes, and barcode-column
with the name of the column in that table that contains those known barcodes.
If youโd instead prefer to accept any scanned barcode, recognized or not, simply set the Valid if expression to TRUE
.
Thank you, I have tried to make a few changes to the validity but the issue is still ongoing. Maybe im inputting it wrong?
Please provide a screenshot (or shots) showing the entire column configuration, with all sections expanded.
Here they are
Well, everything looks okayโฆ But youโre still getting the drop-down with existing barcodes?
@Fabian_Anguian I was little rushed earlier as I needed to step out so I wasnโt thinking clearly.
As @Steve correctly surmised earlier, this is a Ref column and you will get that dropdown automatically. As far as I know, you canโt get rid of it. Its kind of the idea of a Ref column.
So Iโm curious, for the Add Stock to work best, contrary to what i was thinking earlier, it seems you would only want to be able to use Barcodes that already exist in your Product list.
Why wouldnโt you want to have the dropdown list available?
Is there some problem with it? Or are you just trying to force them to scan the item?
Yeah the idea is to just have them scan the item, to many barcodes to have to have them search.
Yeah still having the same issue.
Yes, thats work to solve my problem, thanks
But can you help me, how to just show the idโฆ i mean, when i use barcode(scan), id canโt edit, just show the idโฆ thanks
I want the id โ123โ canโt edited
Hi @rose_lina one way is to use an expression in โEditable_Ifโ
ISBLANK([_THIS])
This would let the user scan the Barcode once. After that he cannot modify it.
But with this the user could enter something before scanning.
To avoid this you could enable โRequiredโ.
(You should also enable โAdvance forms automaticallyโ for this, under UX > Options)
yeyy, its work. Thank you so muchโฆ
@Fabian_Anguian Please try this:
Under UX --> Options --> turn off the โAllow scan input overrideโ
Tried but the issue is still persisting, thanks, however!
I created a little tester app to play with this.
You had mentioned you had โturned offโ the Scannable property for testing. If that is off then the setting โAllow scan input overrideโ is essentially ignored and you will still get the dropdown.
If you have โScannableโ on and โAllow scan input overrideโ off, then you should get a scannable field with NO dropdown. However, it does still compare the scanned entry against the existing list and if the scanned barcode is not present you will get this message:
I hope this helps!
That was it! Thanks for taking the time to do that for me much appreciated!
Actually @Fabian should get the credit. I wasnโt even aware the โAllow scan input overrideโ was an option.
Wow! two Fabianโs in the Community. What are the odds of that?!?
I have posted similar questions about scanning with appsheet but, So far Iโve yet to see any evidence that Appsheet has the ability to work PROPERLY with bar codes.
Of course I could be wrong and I would be HAPPY to be proven wrong. Even if I am wrong, Appsheet is way to slow to be practical (IMO)
Please someone point me to a commercial grade Appsheet App that has the ability to read bar codes like they do in billion billion stores and supermarkets around the world.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |