How to inject text string from multiple fields

  • 10 October 2017
  • 4 replies
  • 0 views

Badge +4

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.


4 replies

Userlevel 5
Badge +14

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

209018_pastedImage_1.png

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

Badge +4

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.

Userlevel 5
Badge +14

then you should use formula like this

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

‌ control value‌

Badge +4

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

Reply