Skip to main content
Nintex Community Menu Bar
Solved

Help with building an expression to fill in a data label using K2 automation V5.6


Forum|alt.badge.img+2

I am busy building a form that will serve as a logbook. there are different users that will use this form. they can pick their names using a control button to populate a data label on the main form with their name. From there I want to populate a data label with a welcome message. This message must also congratulate the user if it is his birthday, or work anniversary. What i have decided to do is use an expression for this data label, using if statements to compare the dates. I have successfully created the if statements, but now I want to add a concatenate function to build the complete welcome message. My problem is, when I add the concat to the front of the if statement, it makes the if statement the first argument of the concat function and I do not know how to add empty cells before the if statement to properly formulate the message. Is it possible, or should I just redo all of the expression and start with the concat function first?

Best answer by tbyrne777

Consider multiple separate expressions to simplify things - you can also do the concat in a data transfer rule that populates your label. So you can transfer in “Welcome {name expression} {birthday expression} {anniversary expression}” where the birthday and anniversary expressions would just return blank if not applicable.

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

2 replies

Forum|alt.badge.img+13
  • Scholar
  • 499 replies
  • Answer
  • January 15, 2025

Consider multiple separate expressions to simplify things - you can also do the concat in a data transfer rule that populates your label. So you can transfer in “Welcome {name expression} {birthday expression} {anniversary expression}” where the birthday and anniversary expressions would just return blank if not applicable.

Translate

Forum|alt.badge.img+2
  • Author
  • Rookie
  • 5 replies
  • January 16, 2025
tbyrne777 wrote:

Consider multiple separate expressions to simplify things - you can also do the concat in a data transfer rule that populates your label. So you can transfer in “Welcome {name expression} {birthday expression} {anniversary expression}” where the birthday and anniversary expressions would just return blank if not applicable.

Thank you. this worked perfectly.

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