Skip to main content
Nintex Community Menu Bar
Solved

Combine formula from two controls

  • August 2, 2024
  • 2 replies
  • 39 views
  • Translate

Forum|alt.badge.img+2

hello,

I have two controls where they are both the same if statement, but one returns the current user and the other returns the date. Is there a way to combine both of these into a single control, so that if box1 equals true, it will return the user and the date?

IF((box1==true), userProfileLookup(Current User,"PreferredName"),"")

IF((box1==true),formatDate(Current Date,"MM/dd/yyyy"),"")

Best answer by SimonMuntz

Hi @AndrewDo,

Interesting question.
As the function's output is a string, you can concatenate them.
Something like this should work.
 

​​​​​​​If((box1==true),userProfileLookup(Current User,"PreferredName”)+ “ “ +formatDate(Current Date,"MM/dd/yyyy”,””)

 

View original
Did this topic help you find an answer to your question?

2 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2466 replies
  • Answer
  • August 4, 2024

Hi @AndrewDo,

Interesting question.
As the function's output is a string, you can concatenate them.
Something like this should work.
 

​​​​​​​If((box1==true),userProfileLookup(Current User,"PreferredName”)+ “ “ +formatDate(Current Date,"MM/dd/yyyy”,””)

 

Translate

Forum|alt.badge.img+2
  • Author
  • Rookie
  • 5 replies
  • August 5, 2024

that worked! thank you!

Translate

Reply


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