cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How to inject text string from multiple fields

Jump to solution

I have looked everywhere for this, so hoping someone has a simple answer.

At run-time, is there a way to inject the text value to a calculated field (Field C) from either Field A or Field B which could be drop-down boxes containing the same values for example?

But also if Field C already has a text string entered, it needs to be replaced with the text from Field A or Field B all at run-time.

I have tried FieldA + FieldB  also tried FieldA || Field B, but these don't work.

Thanks.

Labels: (2)
0 Kudos
Reply
4 Replies
Workflow Hero

Re: How to inject text string from multiple fields

Jump to solution

formula with "+" should work, see usage example below.

I'm not sure what exactly you mean with "at runtime" but note there are settings in which mode formula should recalculate. likely they are reasons why your formula do not recalculate

if that doesn't work for you, provide more details what problems do you exactly experience, resp. what error it throws.

0 Kudos
Reply
Workflow Hero

Re: How to inject text string from multiple fields

Jump to solution

Hi Marian, thanks for replying but no your response displays both Field A and Field B side by side.

I only want to display 1x answer in Field C. 

So if the user selects a value from Field A, then that value shows in Field C.

Then if they then choose a value from Field B, that value replaces the value in Field C.

Let me know if you need more clarification.

0 Kudos
Reply
Workflow Hero

Re: How to inject text string from multiple fields

Jump to solution

then you should use formula like this

if(isNullOrEmpty(CtrlA),if(isNullOrEmpty(CtrlB),"No Value Selected",CtrlB),CtrlA)

‌ control value‌

0 Kudos
Reply
Workflow Hero

Re: How to inject text string from multiple fields

Jump to solution

Thanks Marian, that works okay for my requirements. Thanks.

Reply