Como preencher previamente o formulário usando um código exclusivo

  • sulamitadgp
    Perguntado em 19 de agosto de 2025 às 13:04

    É possível incluir uma base de dados para que os alunos selecionem as opções em vez de digitá-las? Exemplo: Ele preenche o campo matrícula e automaticamente aparece o nome.

  • Anna Jotform Support
    Respondido em 19 de agosto de 2025 às 13:27

    Hi sulamitadgp,

    Thanks for reaching out to Jotform Support. Our Portuguese Support agents are busy helping other Jotform users right now, so 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 Portuguese, let us know and we can have them do that. But, it might take a while until they're available again.

    Now, coming back to your question, yes, it's possible to prepopulate the form by filling out their name or a unique code that was shared with them by using the Spreadsheet to Form Widget. Let me show you how to use it:

    1. Create a spreadsheet with your data structured like you see below. Make sure that the column names in the spreadsheet match the field names on the form, and include a unique column, like an ID, so the data can be distinguished.

    Como preencher previamente o formulário usando um código exclusivo Image 1 Screenshot 50

    2. In Form Builder, click on the Add Element menu on the left side of the page.

    3. Click on the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

    4. In the menu on the right side of the page, upload your data file. (You can simply drag & drop your excel file to the Upload File area.) 

    Como preencher previamente o formulário usando um código exclusivo Image 2 Screenshot 61

    5. Then, click on the Downward Arrow icon in the Access Code Column option and select the unique column.

    6. You can also customize texts used in the widget. After you complete everything, click on the Update Widget button at the bottom right of the menu.

    Como preencher previamente o formulário usando um código exclusivo Image 3 Screenshot 72 Now, when people fill out your form and enter the unique code from the spreadsheet, the corresponding fields will automatically populate when they click Auto Complete Fields. Check out my screencast below to see how it works:

    Como preencher previamente o formulário usando um código exclusivo Image 4 Screenshot 83 Give it a try and let us know if you need any help.

  • sulamitadgp
    Respondido em 19 de agosto de 2025 às 15:13

    Obrigada!

Your Reply