Prevent form submissions from unauthorized emails

  • Profile Image
    Rachael_admin
    Asked on June 16, 2021 at 07:47 AM

    Hi Again

    Just wondering if I can use Jotform tables to allow access to a form, instead of using conditional logic in the form itself?

    eg. a training supervisor adds an employees email address to the table.

    Then, when the employee opens the form they are required to enter their email address, which then performs a lookup in the table to verify the email is present in the table and allows them to proceed filling out the form.

    If this is possible, is there also a way to add a row to a table (ie. the employees email address) using parameters in a URL, much like pre-populating fields in forms?

    Otherwise, can you think of any other way to achieve validating an employee?

    With Thanks

  • Profile Image
    Anthony
    Answered on June 16, 2021 at 12:49 PM

    Howdy Rachael_admin,

    Unfortunately it is not possible to compare fields in a form to fields in a table, with the one exception of a Uniqueness Check, however this will not be useful in this situation. Additionally, the only way to pass values from a URL to a Table is through a From.

    This is sort of possible with the Spreadsheet to Form widget. However, this widget is not able to be dynamically updated, that means you must provide a pre-compiled spreadsheet for the widget to use and if the list is updated the widget must be manually updated as well.

    I believe the best method, with your requirements, would be to change the form's Access Settings to Private, and then invite the employees by email to complete the form. Otherwise, you can limit form access to only emails that share your Company's domain.

    Please let us know if there's anything else we can help you with!