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?
Page 1 / 1
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.