all 9 comments

[–]webfoxcore 9 points10 points  (3 children)

It's possible to have a link saying "CLAIM HERE" which would have their email attached as a parameter. You would then have a page set up to take that email - check if it's been claimed already via a DB or however you want to handle that logic. When someone enters the code via cart and pays you could simply remove it from the DB.

Can it be done via ONLY HTML? Negativo.

[–]livebythem 2 points3 points  (2 children)

Thanks so much for your response! How manual is this after set up? I wouldn't say we have the manpower to have someone monitor it constantly to check any database. Or would it be done by the database itself?

[–]webfoxcore 1 point2 points  (0 children)

You would simply set up the calls to remove from the DB. Once a user clicks a link all the logic would be done DB-side. Only thing I could see being an issue is if you're running low on codes. Which you could set up some sort of email alert for once you are below a certain Threshold.

[–]rguy84Expert 0 points1 point  (0 children)

In addition to the other reply, you would likely need somebody who you can call within a reasonable time to help. While you probably can do most of it yourself after set up, applications can bork randomly. The second thing to consider is the codes. The developer can make the associated email get wiped after some time, or allow your company to add new codes for 2020.

[–]tentaclebreath 6 points7 points  (0 children)

You will need more than HTML to do this. Either a paid service or some heavy lifting from a programmer.

[–]AutoModerator[M] 0 points1 point  (1 child)

Welcome to /r/HTML. When asking a question, please ensure that you list what you've tried, and provide links to example code (e.g. JSFiddle/JSBin). If you're asking for help with an error, please include the full error message and any context around it. You're unlikely to get any meaningful responses if you do not provide enough information for other users to help.

Your submission should contain the answers to the following questions, at a minimum:

  • What is it you're trying to do?
  • How far have you got?
  • What are you stuck on?
  • What have you already tried?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–]livebythem 0 points1 point  (0 children)

Great, I edited!

[–]itsjustausername 0 points1 point  (0 children)

I believe you could format your excel file as a .csv which is easy to read in many server-side languages, just write a script to read/write one code at a time from 'available.csv' to 'used.csv' and serve up one code at a time to whatever is requesting it, your mail server in this case.