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

Formula Not Working

Jump to solution

I have a form where the Title field is calculated from a formula. I've done this before and thought it would be easy, but I was so wrong. 

 

I want the Formula to be IDLastName02122020

which is

[Context].[Item ID] + userProfileLookup([Context].[Item Created by Display name],"LastName") + formatDate([Context].[Item Created],"MMddyyyy")

But it does not populate. 

I tried with just one element - ID, and still, I get an empty field. 

 

Any idea. 

Attaching a screenshot of ID Formula

@EuanGamble any idea?

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

Re: Formula Not Working

Jump to solution
Hi,

DId you publish the form and test or just preview?
[Context].[Item ID] will only work once the form is submitted and the item created as the ID will not generated until then. When the form is then opened from an existing item the ID will show.

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: Formula Not Working

Jump to solution

Published form. I tried it from the list. Even with refreshing, it doesn't give an ID Number, but your point makes sense about it not being assigned until the item is created. 

0 Kudos
Reply