Skip to main content
Nintex Community Menu Bar

Auto-populate a field in a form base on the value of another

  • September 22, 2020
  • 3 replies
  • 352 views
Forum|alt.badge.img+5

Afternoon

 

I have a form with a field called 'Employees name' and when that's filled in I want a number of other fields to auto-populate with that employees details, including 'Department'. I have a list called Starters which contains this information including an 'ItemID'.

I'm trying to use a formula in a Calculated Field to auto-populate the 'Department' field, but I'm not sure of the syntax. Can anyone help me out?

 

Thanks in advance.

 

    3 replies

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • September 23, 2020
    Hi

    lookup("Starters","Employees name on Lookup List",Employee Name Named control,"Department")

    This says lookup the list starters and find the Employee's name that matches the employee's name in the employees name field on the form and return the department.
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Forum|alt.badge.img+5
    • Sutekh
    • Author
    • September 24, 2020

    Thanks @SimonMuntz that worked! Just two questions the fields with the formula are pulling through random results before anything is entered: 9068i1E606B28700311D5.png

     

    and secondly when it does populate it has some other characters, how do I get rid of the '380,#' and '1,#' as shown below?

    9069i3C9B41E9BC9961E0.png

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • September 28, 2020
    Embed your lookup function inside a parseLookup() function.

    parseLookup(lookup("Starters","Employees name on Lookup List",Employee Name Named control,"Department"))
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement