simple (I hope) Deluge script requests from a newbie

simple (I hope) Deluge script requests from a newbie

Hey, 

Complete newbie here - wondering if you good folks can assist with a script request (or two) and general Qs?

I have a form with a single field that requires a QR code input (a mobile phone scan)
  1. How can I introduce a delay (in seconds) to prevent the same user from re-submitting a form (after their successful initial submission)? In reality, this will prevent repeated back-to-back scans of the same QR code. I also wish to show an error message (e.g. please try again in X seconds) 

  2. I need a strategy to prevent random QR scans to enter our Database - please advise?. My plan was to introduce strict formatting validation as our QR codes have finite characters containing strings, integers and spaces e.g. 

    21:56:26 17/04/2020 3 4.2v Unit ID: 3 2.0

    If the above format isn't followed, an error is displayed (e.g. Input Not Recognised)

  3. Can the above input be 'split' so that the first portion (which is a timestamp) goes to its own column in the Database (the delimiter would be the "SPACE" creating a single record of 6 columns). This is similar to 'Text to Columns' in Excel
Thank you & God Bless