QR Code Inventory Management with SmartSuite (or Barcodes)

[@SaifAli-xz3cc]

I want to create an inventory system that can scan QR codes using a barcode scanner, with the data automatically updated in the database. Additionally, I want the admin to have the ability to customize user permissions, such as who can view, edit, or create records, and also view the activity log or last updated information. Do you have any suggestions or ideas related to implementing this system effectively?

[@zackstevenson]

Using SmartSuite or Airtable as your database and Noloco as your front end might be an option worth exploring

[@sprig.sprout]

Hi! Very helpful video, thank you! I am wondering if there is a way to open the url to my record with a QR code on my iphone. When I scan the QR code my phone brings me to a smart suite page in chrome prompting me to download the smart suite mobile app (which is downloaded and signed in) but not to the smart suite app itself. Is there a way around this?

[@zackstevenson]

Yes you can! If you use the link from the expanded record view, which you can copy here. help.smartsuite.com/en/articles/8302431-expanding-records-open-record-view#h_55b8b98aa3 Assign that to the QR code and it should open directly to that record assuming you are signed into the app. It works for me. This is the format that of the link that’s required. app.smartsuite.com/{Workspace Slug}/solution/{Solution ID}/{Table ID}/{View ID}?editRecord={Record ID}

[@sprig.sprout]

@@zackstevenson wow thanks for responding, I’ll give that a try!

[@zackstevenson]

@@sprig.sprout Let me know if that doesn't work.

[@STN-ZA]

Hi, I sort of followed the video but I am not a SmartSuite boff - so got lost a bit along the way. My very simple question is, is there any simple way to create a QR code from a URL in SS and attach it to the same record, in a similar way as can be done in Coda? Sorry for my limited knowledge ...

[@zackstevenson]

Not currently, the method outlined is the most straightforward way that I have found so far.

[@WilsonMar1]

Can you add NFC tag?

[@zackstevenson]

NFC Tags are a physical item, so not in an automated way like this. You could however assign the URL of the record to individual tags.

[@CharliesCustomClones]

Now, I just need to figure out how to use the bar code scanner without moving my mouse to the app.