Custom Field Formula for String Concatenation
Hello All,
I am trying to create a request form with various questions and one variable to concatenate values from the questions responses. For example, if we have request form with the following three questions:
Question 1: Please Type your name here
Question 2: Please Select Leave Type from dropdown list
Question 3: Please select the leave duration (from - to)
I want to concatenate responses from the above three questions in to one field as follows:
Concatenated Field: "Sick Leave, Peter, 03/28-03/29
At the moment I don't see any option in Wrike to get this done. Any help in this regard will be highly appreciated.
Thanks a lot,
Wrike User
Hi Sajid Yousaf, thank you for reaching out!
While I don't think there's a way to put all this info into one field, it should be possible to add to a task's/project's title or description field. Would that work for you? I'd be happy to share some screenshots if that could help 🤗
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
Thanks for your response. But would the solution that you are proposing, pull (and concatenate) data from the text fields mentioned above?
Kind regards
Sajid Yousaf, yes, let me show you an example of how it can work.
First, you need to create a request form with the questions you need. For the leave duration, you'll need to create two questions - one for when the leave starts, the second for the last day of leave. Make sure to map responses to the title of the tasks:
Here's what the filled-out request will look like in this case:
And here's what we get when the form is submitted - the info is in the task title:
Is that the result you were trying to achieve? Please let me know!
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
I would have suggested the same solution as Lisa.