Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search

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


Kyler

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 post
  • 1 month later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Did you ever get guidance on this?  I am looking to do a similar thing where they need to submit a form back after purchase, but have been struggling with it.  Thanks!

 

Link to post

Create an account or sign in to comment

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


×
×
  • Create New...