Hi.
I’m working on a ticket app.
I wish to create a flow as the following:
1)User A (role=customer) has a barcode (that get from Make automation).
In a Google Sheets I have all the barcodes. Keeping the barcodes, who bought the tickets, and for which event.
2)User B (role=checker) screen the barcode, and check if the barcode is related to the event, and it was never used (first time it screened).
3) if it wasn’t screened before - shows success message with the details of the customer and mark it as “screened”.
4) if it screened already - shows "fail"message.
You could add a barcode button to scan a barcode into a user specific column. Then create a single Relation that links that user specific value to the table that contains all of the valid barcode values. If there is a match, then the relation will be populated. You can use Lookup columns to pull back any relevant info from the relation and display it on the screen. Then you will need another button to set a column value, such as the current date and time, to a column in the barcode table, through the single relation. So I’m the end, you will need two buttons. One to scan the barcode, and another to mark it in the table as scanned. Instead of displaying a message when the second button is pressed, you could just hide the second button by using a lookup column to return the scanned date, and then only display the button when the date is empty. Or, you could create a custom action on the button with an IF condition that checks the scanned date. If it’s empty then set the date using the Set Column action, followed by a Notification action to say it was successful. Else, just show a notification that it was not successful.
Just be mindful of any barcode scan limits and your update limits as you will eat through those pretty quickly.
Glide also offers third party integration with a paid dynamsoft subscription, that would allow you to scan barcodes much more easily than what the built in scanner provides.