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.

 

Link to comment
  • 1 month later...
  • Replies 1
  • Views 405
  • Created
  • Last Reply

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.