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

  • Profile Image
    ghflopes
    Asked on July 18, 2017 at 02: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

  • Profile Image
    Jenny
    Answered on July 18, 2017 at 04: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.

    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.

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

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

    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. 

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

    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.