How to allow a list of emails to submit my form?

  • tesideniseparisi
    Domanda del 14 marzo 2024 alle ore 09:09

    Buongiorno,

    Con la presente per richiedere se è possibile importare in piattaforma gli indirizzi mail che potranno compilare il rispettivo modulo di appartenenza.

    Ad esempio: nel mio modulo n. 1 devono compilare 10 persone con i loro 10 indirizzi mail. C'è un modo per far sì che SOLO queste 10 persone con i 10 indirizzi compilino il modulo? (Questo per evitare che qualcuno compili il modulo con un indirizzo mail diverso.

    In attesa di vostre,

    Grazie

  • Gian Jotform Support
    Risposta del 14 marzo 2024 alle ore 09:36

    Hi silversearayevents,

    Thanks for reaching out to Jotform Support. Unfortunately, our Italian Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Italian, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. You can add the Spreadsheet to Form widget to your form and upload an Excel file that has the list of email addresses to it. You can use it to validate the email addresses that is entered to your form. Let me show you how to add the widget:

    1. In the Form Elements window, go to Widgets.
    2. Search for Spreadsheet to Form and click it.
    3. Click the Wand icon to open the widget's
    4. Upload your Excel file.Prepopulate form fields after entering the name of the person Image 1 Screenshot 50 Screenshot 60
    5. For the file to upload, create an Excel file with the list of valid emails. Here's the file on my demo as an example: How to allow a list of emails to submit my form? Image 1 Screenshot 71
    6. After the file is uploaded, you can select the access code column. In your case, you can use the Email column. How to allow a list of emails to submit my form? Image 2 Screenshot 82
    7. Set your Email field as read-only. Make sure the Email field label matches the Email header in the uploaded Excel file. How to allow a list of emails to submit my form? Image 3 Screenshot 93
    8. Add a Hide/Show condition to only display the Submit button if the Spreadsheet to Form widget is validated:How to allow a list of emails to submit my form? Image 4 Screenshot 104

    Here's the result:

    How to allow a list of emails to submit my form? Image 5 Screenshot 115

    Give it a try and let us know if you need any other help.