Concatenate If-String (Recommendations)

[nesonica]

Hi guys,

I am trying to build a text-string that CONCATENATES every if-statement which leads to a result as follows:

// Customer no more online
if([Online % Pos.VJ]>0 and [Online % Pos.]<=0
,'Customer no more online'
,
// Customer online activated
if([Online % Pos.VJ]<=0 and [Online % Pos.]>0
,'Customer online activated'
,
// Less Positions online
if([Differenz Pos.]<0
,'Less Positions online'
,
// EDI-interface no more working
if([EDIUmsatz]<=0 and [EDIUmsatzVJ]>0
,'EDI-interface no more working'
,''))))

Please show me a way to rebuild this formula so that there will be a text-string like "EDI-Interface no more working, customer no more online". Currently only one single result of each is being shown.

Optional: I would also like to add a function where the person who sees the "recommendation text" can just switch it off and write a comment on it. Do you have an idea how to do that?

Thanks a bunch!

Nes

[Shubham_Deshmukh · Accepted solution]

Try this :

=if([Online % Pos.VJ]>0 and [Online % Pos.]<=0
,'Customer no more online')&','&
if([Online % Pos.VJ]<=0 and [Online % Pos.]>0
,'Customer online activated')&','
&
if([Differenz Pos.]<0
,'Less Positions online')&','
&
if([EDIUmsatz]<=0 and [EDIUmsatzVJ]>0
,'EDI-interface no more working')

[Shubham_Deshmukh]

Change the sequence as per your requirement.

[nesonica]

Very well, thank you! 😄 Only all the commas in case of no recommendations may be disturbing. If you find a way to avoid them, just update me.

[Shubham_Deshmukh]

Sorry, I didn't get your OPTIONAL part of question, hope you are talking about the same.
Please elaborate a little.

[nesonica]

Our sellers shall see recommendations about their customers, if an issue occurs.
But if the seller fixed the issue, he shall be able to "check off" the recommendation and "write a comment" to it that goes live. Is there any option for this?

[Shubham_Deshmukh]

Sorry buddy, no idea

[sunny_talwar]

You can may be look into making it an Inputfield