cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Nintex Forms - Calculated value lookup last/latest entry for multiple items

Jump to solution

Hi all,

 

Google has not been my friend on this.

I have a single list that I'm using Nintex forms to lookup previous entries for.

I have a single field that the user enters the search criteria (a username) and then several calculated value fields use a lookup formula to populate previously entered information.

 

If I'm targeting a single user in the list (via his username) that has multiple items added, is there a way to lookup the latest item?

 

My formula is 

If(isNullOrEmpty(RACF),"",lookup("UserDB","Phone_User", RACF,"PC_User"))

This brings works however brings up only the first entry for that user instead of the desired last item for that user.

 

In my head, my thought is to call the user and sort the last ID/date modifed entry.  I can't seem to get that to work....if that's even possible

 

I tried a method that calls on Item Child Count, which seems to be 0 for all entries

Labels: (1)
0 Kudos
Reply
2 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Nintex Forms - Calculated value lookup last/latest entry for multiple items

Jump to solution

Hi,

I just answered a similar post here: https://community.nintex.com/t5/Nintex-for-SharePoint/Get-previous-column-value-in-a-new-form-for-pa...

The formula looks up all the items for a user and returns all the ID's.
You then look for the highest ID which would logically be the latest entry and knowing that ID then allows you to lookup what ever other column you want.

View solution in original post

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Nintex Forms - Calculated value lookup last/latest entry for multiple items

Jump to solution
You are a legend!!!!
I came across some similar posts but was still trying to decipher how to get this result. Your post nailed it. Well done and THANK YOU!!!
0 Kudos
Reply