Skip to main content
Nintex Community Menu Bar

Lookup Function in Nintex forms

  • June 14, 2018
  • 4 replies
  • 13 views

Forum|alt.badge.img+1

I am using nintex forms 2013 designer and a lookup function. There are two lists - N2F F2F Repository & Change requests. The N2F F2F Repository has columns CRN, ProjectAcronym with the data in the list for these columns. In Change Requests list, there is a column called CRN which is a list lookup to CRN column in N2F F2F repository. I want to autopopulate Project Acronym value from N2F F2F repository when CRN value is selected in Change Requests list to a column called Project. To do this, I am using the following formula for Project column in Change Requests list = lookup("N2F F2F Repository", "CRN", CRN, "ProjectAcronym") and Recalculate formula on view mode as Yes. But it is not working. Appreciate any help in letting me know what is wrong.

4 replies

Forum|alt.badge.img+8
  • June 15, 2018

Patrick Kelligan‌, Rhia Wieclawek, nmarplesMarian HatalanmarplesCassy Freemancan you help with this issue? Venkata is trying to populate a field from a lookup. Thanks!


kelliganp
Forum|alt.badge.img+10
  • Rookie
  • June 15, 2018

Forum|alt.badge.img+8
  • June 15, 2018

Forum|alt.badge.img+1

Thank you all! I got it to work. The mistake that I was making is related to spaces. Once I fix my spaces in the formula, it started working