Assigning unique codes to students based on table lookup

Hi,

I want to send students a Unique Code using the connection between two tables.

Table 1: List of Student E-learning Codes, what type of E-learning, and if the code has been Used Already or not (each can be used once)
Table 2: Students name, their email, and what type of E-learning they want

If a student fills out the form, I want to create a formula that checks if I have an unused code. If the code hasn't been used yet (and it's the class they want), I would like to send an email out to the student with their code. Then I want to mark it as "used" so that other students can't select the same code.

How much of this is possible? I am OK if there are parts I have to do manually, but please let me know what a good workaround could be.

(see my table NAUI NES Codes)

Hi,

It's possible.

You just need to enable the unique answer option in your form settings:

Let us know if you need further assistance.