Skip to main content
Nintex Community Menu Bar
Solved

Formula Not Working

  • February 12, 2020
  • 2 replies
  • 8 views
  • Translate
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.
View original
    Did this topic help you find an answer to your question?

    2 replies

    SimonMuntz
    Nintex Employee
    Forum|alt.badge.img+22
    • SimonMuntzNintex Employee
    • Nintex Employee
    • 2469 replies
    • 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.
    Translate
    Get a flying start and additional functionality at: https://gallery.nintex.com/
    amydpp
    1 person likes this
    • amydpp
      amydpp
    amydpp
    Forum|alt.badge.img+2
    • amydpp
    • Author
    • 9 replies
    • 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. 

    Translate

    Reply


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

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings