Get the form to autofill the last name of employees once the first name is filled in

  • Profile Image
    selectability
    Asked on December 16, 2020 at 04:24 AM

    Hi,

    I'm trying to get the form to autofill the last name of employees once the first name is filled in.

    Does prepopulating allow this once the form is filled in repeatedly?

    As far I can understand the prepopulating fields in this case would mean I'd have to manually fill the name and last name for each form and send them out.

    Could you please help me find a solution?



    This is a re-post of a comment on Prepopulating Fields to Your Jotform via URL Parameters

  • Profile Image
    Gaetan_B
    Answered on December 16, 2020 at 04:36 AM

    Hello,

    You can use a Spreadsheet to Form widget for this purpose: https://www.jotform.com/widgets/spreadsheet-to-form.  

    Here is how you can set up the widget: How-to-Use-the-Spreadsheet-to-Form-Widget 


    Although if you want to have the form being sent each time with some customization in the style of "Hello Employee Lastname Firstname", you would have to indeed modify it manually.


    Gaetan