How to pre-populate other field based on user selection?

  • ghflopes
    Asked on July 18, 2017 at 2:49 AM

    Olá!

    Gostaria de saber se é possível salvar os dados de uma submissão, por exemplo: O formulário possui os seguintes campos de identificação do usuário (TELEFONE, NOME, ENDEREÇO), daí quando o usuário informar o número de telefone, automaticamente fosse preenchido o nome e endereço caso o usuário já tenha feito anteriormente em uma data do passado, uma espécie de consulta pelo número do telefone

  • Jenny
    Replied on July 18, 2017 at 4:23 AM

    If I understand your question correctly, you are asking to autofill the form fields based on user selection. Unfortunately we are not able to get an external data from outside sources. However, you can achieve the thing you are looking for with alternative options. To do so you may choose one of three options;

    First, you may use conditional logic. I have created a demo form and added visual guides explaining step by step. If you want, you may clone demo form and check conditional logic for further understanding. Demo Form: https://form.jotformpro.com/71982207723964

    1- I added a dropdown field for names and added three example names. After that, I added three email fields.

    How to pre populate other field based on user selection? Image 1 Screenshot 70

    2- Using email properties button, I opened advanced tab and wrote default email. I repeated it three times so that I have three different email field for each user.

    How to pre populate other field based on user selection? Image 2 Screenshot 81

    3- I hide 3 email fields. You need to right click to the field and then select hide option in the pop-up window.

    How to pre populate other field based on user selection? Image 3 Screenshot 92

    4- Then, using settings tab I selected conditions and clicked show/hide field section.

    How to pre populate other field based on user selection? Image 4 Screenshot 103

    5- Finally, I set following logic to achieve that if certain name is selected, related email address will be shown accordingly. You also need to repeat this for three options in dropdown field. 

    How to pre populate other field based on user selection? Image 5 Screenshot 114

    Here is the result of the process according to condition above.

    How to pre populate other field based on user selection? Image 6 Screenshot 125

    Another workaround could be using widget. You may use Spreadsheet to Forum widget. While using this widget please bear in mind that spreadsheet columns should have the same name as filed labels. For further information you may check following link:

    https://widgets.jotform.com/search/spreadsheet%20to%20form 

    Third, You may follow user's guide how to automatically pass form data to another form:

    https://www.jotform.com/help/351-How-to-Automatically-Pass-Form-Data-to-Another-Form 

    If you have more questions, please do not hesitate to contact us.