Solved

Build formula

  • 9 March 2022
  • 4 replies
  • 10 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

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"), "")

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