need to combine if statements in the formula

if($control[contains(text(), 'MB_')]) then replace($ control  ,"MB_","")  else if($ control[contains(text(), 'NA_2')]) then replace($ control  ,"NA_2","")  else if($ control[contains(text(), 'NA_3')]) then replace($ control  ,"NA_3","")  else ''

I am trying to use the calculated value to modify what goes to an alternate control.  Basically one control goes to two data base destinations and should contain the same value.  The answers in the control are set with a prefix to indicate the database destination.  For the first destination I want to remove the prefix and keep the database answer.  But then I need the if statements to continue so that it removes the answers that will be moved to the second database destination.

In short, I need the if statements to not terminate when the first is executed.  I imagine that i need a different operator or need to modify the placement of parentheses? I just do not know the syntax.

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/b8c20bbf-b0cb-43b7-9bd0-9cf5a570a28an%40googlegroups.com.

Hi,

instead of 'if' use replace function. See https://demo.orbeon.com/demo/fr/orbeon/builder/edit/df43586459985c768617c53e6a499bd1d3992bb0

Let me know if it works for you.

//Jarek

pt., 10 lip 2020 o 22:48 Seth Parkhurst <[hidden email]> napisał(a):

if($control[contains(text(), 'MB_')]) then replace($ control  ,"MB_","")  else if($ control[contains(text(), 'NA_2')]) then replace($ control  ,"NA_2","")  else if($ control[contains(text(), 'NA_3')]) then replace($ control  ,"NA_3","")  else ''

I am trying to use the calculated value to modify what goes to an alternate control.  Basically one control goes to two data base destinations and should contain the same value.  The answers in the control are set with a prefix to indicate the database destination.  For the first destination I want to remove the prefix and keep the database answer.  But then I need the if statements to continue so that it removes the answers that will be moved to the second database destination.

In short, I need the if statements to not terminate when the first is executed.  I imagine that i need a different operator or need to modify the placement of parentheses? I just do not know the syntax.

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/orbeon/b8c20bbf-b0cb-43b7-9bd0-9cf5a570a28an%40googlegroups.com.