Create a pin secured read only database.

Ask the community
,
1

We would like customers to visit a page. Enter a given 5 digit alpha/numeric pin. If correct, it would then display the data associated with that pin. The database would look like this:

EX123 | JOHN SMITH | READY FOR PICKUP, PAID
EX456 | JANE SMITH | READY FOR PICKUP, OWES $123
EX789 | JOE SMITH | NOT READY FOR PICKUP

So if the customer goes to the page and enters “EX123” the data “JOHN SMITH | READY FOR PICKUP, PAID” would be displayed.

The data would be manually entered on the back end. (or, long shot, is it possible to poll the data from a Google Docs excel page?)

What would be the best way to implement something like this? Really just looking for a starting point or suggestions. Thank you!

2

Hello.

You can add a database to your site and implement a database search functionality as per this tutorial: Corvid Tutorial: Adding Collection Data Search Functionality

To learn more on refining your queries refer to this article: Corvid: Working with the Data API

You can save or retrieve information from Google sheets using an NPM module as you can see in this example: Save Data to a Google Sheet Using npm

Good luck!