Skip to main content
Nintex Community Menu Bar
Answer

Formula Not Working

  • February 12, 2020
  • 2 replies
  • 27 views
amydpp
Forum|alt.badge.img+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?

Best answer by SimonMuntz

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.
1 Attachments

    2 replies

    SimonMuntz
    Nintex Employee
    Forum|alt.badge.img+23
    • SimonMuntzNintex Employee
    • Nintex Employee
    • Answer
    • February 13, 2020
    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.
    New look Nintex University is HERE: https://learn.nintex.com
    amydpp
    amydpp
    Forum|alt.badge.img+2
    • amydpp
    • Author
    • February 13, 2020

    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