Sorry for my lack of precise wording but I'm not really familiar with HTML/js/app script.
We work with plenty of clients every month and organize events with them. Each one of our clients has a unique code which is necessary in order to take part in our events.
We heavily rely on Google Forms in order to let clients book their spots. On the form, we ask for their code but we do not have any kind of validation.
Recently we've been given access to a database API that works with URL queries (e.g.,
- If the
CODE
on the URL query returns a non empty JSON value, user gets a browser alert that saysRouting to Google Form
, then user finally gets routed to the Google Form
- Otherwise, user gets a browser alert that says
Code is invalid
and it will never route user to the Google Form