In a form, the second column is the QR code scanner. (Iโm using a uniqueID() for the key). Iโm trying to get two other columns to auto populate once the qr code is scanned. When the qr code column is blank it doesnโt show up in the form (which is fine). Iโm using the following formula:
ANY(SELECT(QR Codes[Campaign], ([QR_Code] = [_THISROW].[QR_Code])))
and in another column:
LOOKUP([_THISROW].[QR_Code], โQR Codesโ, โQR_Codeโ, โElementโ)
in the QR Codes table i have a list of the QR codes and the reference information in the columns โCampaignโ and โElementโ
Hereโs the funny part. When I click the scanner button in the emulator and get the resulting 1111222333 code, the other columns show up with the correct information. However when I use my phone and an actual QR code, it scans the qr code fine giving me the same data as in the table, but the other columns donโt appear with the relevant info.
What am i missing?
Perhaps the scanned code has extraneous spaces around it? Try wrapping [_THISROW].[QR Code]
with TRIM():
ANY(SELECT(QR Codes[Campaign], ([QR_Code] = TRIM([_THISROW].[QR_Code]))))
See also:
Thanks for the reply. Unfortunately that didnโt solve it. In that same vein when I do submit the form all of the logic and vlookups I have running on the google sheet recognize the QRCode just fine. So I donโt think itโs a formatting issue either (i.e. text, number, etc). btwโฆmy qrcodes are text and the Type is set as text also. Does anyone think this could have something to do with it? Text vs number?
Iโm still looking for help here. I just canโt figure out why Iโm not able to use a lookup or any(select in a column formula to input a value based off another columns value (qrcode scan). Anyone have any ideas? Meeting with a client tomorrow to try to explain. Thanks in advance!
As you need is time-sensitive, consider engaging support@appsheet.com for help with this.
OK. Works like a charm when I use Enum and โhard codeโ the list of Campaigns into the column. Once I select the corresponding Campaign the resulting enum list is triggered in the ShowIf of the other column.
The goal is to have the QRCode scan trigger the Campaign column which will trigger which of the 3 columns is shown.
Basicallyโฆ if QRCode โAโ is scanned, โ1โ will appear in the โCampaignโ column. Then column โBlueโ will Show with Enum List of โPaleโ โBabyโ โNavyโ. If QRCode โBโ is scanned, Campaign โ2โ is autofilled and column Red is shown with Enum List buttons of โRubyโ โScarletโ and โLightโ. Any thoughts why the QRScanner is not triggering the other columns?
Yep. Tried the TRIM formula and did not work. Itโs the same values in the columns. When I do submit the form data all of the vlookups in my google sheets work just fine, so I know the text matches.
Thanks for the suggestion!
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |