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.
Is this still the only recommendation for string concatenation?
I'm wanting to create a custom Text field to hold a hyperlink, but I want the hyperlink to be generated dynamically from other custom fields. (ie. using other fields to populate URL parameters).
This would allow us to have deep-linking between related systems with a url in the format of:
Hi Andrew Ritchie, welcome to the forums 👋 I'm afraid it is. I'm not sure if this could be possible with API, so if you think it could be, I'd recommend exploring this option or reaching out to our Support team about this.
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'm with Andrew.... it would be really cool to have this functionality. Currently there is "calculated" fields... I would love to have a "concatonated fields" option with custom fields.
Hi Richard Bitgood, you can do it by using Wrike API (or Integrate), not in Wrike standard Formula