Skip to main content

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.


 

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.

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

Embed your lookup function inside a parseLookup() function.

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

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings