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!
Omg, thanks that was easy, why people can’t just explain this way
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?
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