Skip to main content
Nintex Community Menu Bar

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?

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.

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. 

Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie SettingsAccessibility statement