Skip to main content
Nintex Community Menu Bar
Solved

Combine formula from two controls

  • August 2, 2024
  • 2 replies
  • 65 views

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

 

2 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+23
  • Nintex Employee
  • 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”,””)

 


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

that worked! thank you!