Solved

Formula Not Working

  • 12 February 2020
  • 2 replies
  • 3 views
amydpp
Badge +2

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?

icon

Best answer by SimonMuntz 13 February 2020, 04:58

View original
1 Attachment

2 replies

SimonMuntz
Userlevel 6
Badge +22
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.
Cool Nintex courses: https://learn.nintex.com/
amydpp
Badge +2

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. 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings