as far as I know you can\t check an enum list with nfc or barcode scanning. Is there a way to work around this limitation? I want to register presence of members of a club using nfc or by checking the enumlist manually
You would use a second column that would query the members table based of of if any of their "nfcID" match the "ScannerColumn". ScannerColumn: Used for scanning the nfc/barcode MemberFound Column: Ref to Memebers Table App Formula: ANY(SELECT(Members[ID], [nfcID]=[_THISROW].[ScannerColumn]))
@@AppSheetTrainingthanks but I don’t think this is what i can achieve my goal with . My google sheet isn’t a list of members which I can search but only consists of a date stamp and a field which holds the members that were present. The members only exist in the enum list and new members can be added live in the app in the enum list. I also tried an if scannercolumn value statement direct in the member list enum list but the autocalculate function will make the list invisible, so unusable .im a bit stuck now
@@Johnsormani Where were you applying it to; the App Formula or the Initial Value? What if you had something like this in the Initial Value of the Member enumList IF(ISBLANK([ScannerColumn]),{""},{[ScannerColumn]}) If there is a value in the scanner it auto-populates the value of the member enumList.
@@AppSheetTraining I would give that a try but what do you mean with initial value of the enum list? Oops , I overlooked the initial value field. It works sort of but adds a scannercolumn item to the enum list with an empty checkbox in stead of the scanned value
Ok there was an error in your code : using this code IF(ISBLANK([ScannerColumn]),"",[ScannerColumn]) it now checks the item in the enum list but it will override it with the next scan , so I can’t check more than one item with scanning
Completely thrilled to find this, it's exactly what I was looking for!
hey i want to scan ISBN of book. so when I scan that ISBN, the app would show the identity of the book. how to do that?
Omg, thanks that was easy, why people can’t just explain this way
Thus Appsheet include barcode generator?
as far as I know you can\t check an enum list with nfc or barcode scanning. Is there a way to work around this limitation? I want to register presence of members of a club using nfc or by checking the enumlist manually
You would use a second column that would query the members table based of of if any of their "nfcID" match the "ScannerColumn".
ScannerColumn: Used for scanning the nfc/barcode
MemberFound Column: Ref to Memebers Table
App Formula: ANY(SELECT(Members[ID], [nfcID]=[_THISROW].[ScannerColumn]))
@@AppSheetTrainingthanks but I don’t think this is what i can achieve my goal with . My google sheet isn’t a list of members which I can search but only consists of a date stamp and a field which holds the members that were present. The members only exist in the enum list and new members can be added live in the app in the enum list. I also tried an if scannercolumn value statement direct in the member list enum list but the autocalculate function will make the list invisible, so unusable .im a bit stuck now
@@Johnsormani
Where were you applying it to; the App Formula or the Initial Value?
What if you had something like this in the Initial Value of the Member enumList
IF(ISBLANK([ScannerColumn]),{""},{[ScannerColumn]})
If there is a value in the scanner it auto-populates the value of the member enumList.
@@AppSheetTraining I would give that a try but what do you mean with initial value of the enum list? Oops , I overlooked the initial value field. It works sort of but adds a scannercolumn item to the enum list with an empty checkbox in stead of the scanned value
Ok there was an error in your code : using this code IF(ISBLANK([ScannerColumn]),"",[ScannerColumn]) it now checks the item in the enum list but it will override it with the next scan , so I can’t check more than one item with scanning
Can I use it for ios
How to scan multiple inventory IDs in the same row without moving to other row
Can only scan qr codes and not bar codes. please make a tutorial on it
Hi
Hi, how I can setup In phone ( movil) the scandit?
We only use AppSheets built in barcode scanning, we have not looked into Scandit.
cool