How to populate fields based on dropdown selection?

  • Profile Image
    LOSD 
    Asked on January 09, 2018 at 05:23 PM

    Hi,


    I work for a school district and am trying to create an online form for our employees to fill out during open enrollment to make their health and welfare selections.  What I'd like is for the employee to pick their name from a pull down list, enter their employee number and have the form populate with their current year picks.  Then I'd like them to be able to select the new year selections and have the form calculate their new cost. 


    I'd also like them to be able to submit the form and have the results entered into a google spreadsheet if possible.



  • Profile Image
    Marvih
    Answered on January 09, 2018 at 07:36 PM

    This is possible.

    What I'd like is for the employee to pick their name from a pull down list, enter their employee number and have the form populate with their current year picks.

    You can use Dropdown field element for your employee list and add a Update/Calculate field condition to pre-populate/insert data to the other field elements based on the selected employee.

    Then I'd like them to be able to select the new year selections and have the form calculate their new cost. 

    This can be done using the Update/Calculate field condition too. Or use Form Calculation widget to do the calculation.

    I'd also like them to be able to submit the form and have the results entered into a google spreadsheet if possible.

    Here is the guide on how to integrate your Form into with Google Spreadsheet.
    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Let us know if you need further assistance.

  • Profile Image
    Jed_C
    Answered on January 10, 2018 at 03:11 PM

    You can use the Spreadsheet to Form widget in this case. On this test form https://form.jotformpro.com/71500914392957, you can simple input a number which corresponds to the number column where the information will be pulled from.

    Guide on how to use the widget - https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget 

    ex. Input number 300

    1515615063spreadsheetoform.gif

    Let us know if you have further questions.