Assigning unique codes to students based on table lookup

  • Profile Image
    SuperDive
    Asked on January 05, 2022 at 03:56 PM

    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)

  • Profile Image
    Yau_C
    Answered on January 05, 2022 at 09:51 PM

    Hi,

    It's possible.

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

    1641437426_61d658f2ccfc0_

    Let us know if you need further assistance.