Skip to main content
Nintex Community Menu Bar

How to populate a text box based on a dropdown from another list

  • July 15, 2020
  • 1 reply
  • 16 views
Optimus
Forum|alt.badge.img

Hello All,

I am trying to create a list, where based on a dropdown selection, three text boxes are populated from an external list. I have a look up field of values that are badge numbers from the external list. When a badge number is selected, the member's information is populated in three text boxes, being name, company and status. All information for the look up and the text boxes is retrieved from the external list. As well, I am hoping to eventually use barcodes to retrieve the data for the text boxes. Any help would be greatly appreciated.

    1 reply

    Forum|alt.badge.img+4

    you can place the lookup value field on top of the text box so when the option is selected the text will get populated, that of course will not work if you want your users to edit the text boxes afterwards.

     

    I've done something similar two years ago with SQL lookup action, you can also create three different calculated fields that will look up the external list and add a rule to hide them, and add a button with a JavaScript action that will take values from the fields created above and populate the text boxes which the user can edit, check the link below to create the JavaScript button

     

    https://community.nintex.com/t5/Nintex-for-SharePoint/Form-Button-Javascript/td-p/49726

     

    best of luck

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement