Something *like* Appsheet but for a website?

[Christopher_Jac]

My solution has two pieces- an Appsheet app for device administrators (authenticated), and a web interface for users (not authenticated). I 100% love the Appsheet toolset and approach to building out a Web/mobile app. I am looking for something similar to build out an unauthenticated Web site. The use case is this:

a) user scans a QR code attached to a padlock
b) user enters the padlock serial number
c) a table is queried to match the padlock serial number with its four-digit unlock code
c) user is provided with the four-digit code to unlock the padlock
d) the device administrator (padlock owner) is sent an SMS and an email notifying them that the padlock code has been requested

Appsheet device administrator side is figured out, obviously. But what’s a good low-code solution for the Web side? I anticipate having dozens of device administrators (padlock owners) but thousands of users who don’t need authenticated accounts. TIA.

[WillowMobileSys]

Christopher_Jacoby:

My solution has two pieces- an Appsheet app for device administrators (authenticated), and a web interface for users (not authenticated).

AppSheet apps ARE web apps. They will run directly in a browser as is. You just need to use the browser link. The community will often times refer to this as the “desktop app” but its really just a web app run in a browser. You can bookmark the browser link or even create a desktop icon that will “launch” the app (just opens the link in the browser)

For QR code scanning, regardless of how you implement your “desktop” version of the app, you will need to integrate a 3rd party scanning device - desktops do not support scanning by default like mobile devices do. I have not performed this integration myself but I am certain I have read Community posts in the past that it is possible.

Maybe someone else can provide more details on how to add scanning hardware.

[Christopher_Jac]

Thank you! I don’t want my users to have to install an app. They should be able to scan the QR code and directly go to the “form” where they enter the padlock serial number without authentication. Is that possible without the Publisher Pro plan?

[WillowMobileSys]

Christopher_Jacoby:

Is that possible without the Publisher Pro plan?

Not in AppSheet. I do understand the reluctance for your use case of having users to install an app.

A quick search and there are options out there for barcode scanners built in javascript. You will likely need to integrate these into your own HTML code/website and integrate some kind if backing store to save the data.

Google Forms can accommodate barcode scanning using Google sheet as the data store. But then to send an SMS/email you will need some kind of automation like using Google scripts.

[Christopher_Jac]

Let me be a little clearer- I expect users to scan the QR code with their phones almost 100% of the time. Every phone has that functionality these days, I think. So the QR code scanning problem is solved.

[mateo]

Hi @Christopher_Jacoby
Sorry, but I am almost sure it is not possible without publisher pro plan.
In my organisation we are using one app with this plan and it works perfect. In my case it is being shared in the HTML IFrame but you can also use appsheet link. We also use 3rd party scanning devices, really all works very good.
Generally speaking you can achieve all you need using account with proper plan

[SkrOYC]

Recently I found something called Glide.
Idk if that will be your solution in this case, take a look at it