Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Scanning QR Code and update column without adding new row

I'm creating an app that let user scan QR Code on the item and The app will mark "✔" on the 'Marked' Column in the same row, I'm struggling with the qr code scanning method.

 

My expectation is when the user click the QR Scanning icon(I want this icon to show in Bottom right corner where Add action usually located but i can't find a way yet),then user scan the QR Code and the app will mark "✔"  in 'Marked' column in database.Now when the user click the QR Code icon there's nothing happen,I tried adding a form views,The scanning is work but i cannot save the scanned value because it's adding the new row into the table,making 'there's already a row with a key'xxx' shown up.
Kasidit_1-1726543781639.png

This is the action which i've created 

Kasidit_2-1726543994160.png

 

Kasidit_3-1726544022023.pngKasidit_4-1726544034623.pngKasidit_5-1726544054603.png

I also set the 'Scanned QR' to scannable already

 

 

0 1 118
1 REPLY 1

Steve
Platinum 5
Platinum 5

Your Open QR Scanner action doesn't open the QR scanner. Instead, you need an action of type App: go to another view in this app with a target that uses LINKTOROW() to target a suitable form view of that [_THISROW]. That form view should include only the Scanned QR column and have auto-advance and auto-save enabled.

Top Labels in this Space