Jump to content

How do I create a form field that cross-references a database or excel sheet to confirm on deny the entry?

Recommended Posts

Hey guys I am looking to build a form that users will have to fill out. Should the one field not match the input of my excel file then they will be prompted to try again. Something like "The information you have entered does not match our records."

 

Example:

1. User is given a device with a MAC address

2. They have to register their device by filling out their personal information as well as the MAC address displayed on the box.

3. Two outcomes. If the MAC address matches my excel / google sheets file the registration is complete. If not then they are prompted to fill out the field again.

 

Of course I understand I might need a third party service as well as html and css, but any guidance on achieving this system would be helpful.

 

Edited by Kyler
Link to comment
  • 1 month later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.