Solved

Build formula

  • 9 March 2022
  • 4 replies
  • 14 views

Again.. to new to get it.., I want to pickup a value based on a rule using the claculated value. UI want to pickup what user changed a dropdown value to "Complete". I started like this. But of course its not working 🙂 I'm looking at it but.. anyone give me a hint please 🙂

 

 equals(Task, "Complete"),userProfileLookup(Current User,"PreferredName")

icon

Best answer by Aleximo 9 March 2022, 11:13

View original

4 replies

Badge +8

hey @JHjalmarsson ,


 


u can try this formula:


 


if(Task == "Complete", userProfileLookup(Current User, "PreferredName"), "")


 


If the Task Dropdown is "Complete" then u will get the PreferredName from the current User... if it is something else then its empty. 🙂

Thats perfect.. i just can't get the commas and brackets right. So if i want the CurrentDate in there also, do I just tack it on before the close bracket

if(Task == "Complete", userProfileLookup(Current User, "PreferredName"), "")
Badge +8

hey @JHjalmarsson ,


 


yes, u have to put it there:


 


if(Task == "Complete", userProfileLookup(Current User, "PreferredName") + CurrentDate, "")


 


If u want to format the date u can use formatDate (german date example):


 


if(Task == "Complete", userProfileLookup(Current User, "PreferredName") + formatDate(CurrentDate, "dd.MM.yyyy"), "")


 


for US formats u can look here:


 


https://community.nintex.com/t5/Community-blogs/Date-and-Time-Format-Strings-Quick-Reference-Guide/ba-p/81050

Thank you .. awesome.. thank you so much

Reply