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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
6 comments

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

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Thanks for your response. But would the solution that you are proposing, pull (and concatenate) data from the text fields mentioned above?  

Kind regards

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

I would have suggested the same solution as Lisa.

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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:

https://www.othersystem.com?projectID=<dynamic text>
0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Custom Field Formula for String Concatenation
[this list is visible for admins and agents only]

Top
Didn’t find what you were looking for? Write new post