General

Re: Two (3?) Questions on Concatenation

Jimmy — Wed, 13 Jun 2012 17:59:30 GMT

I have to correct myself. qRules has included a command for creating delimited lists for some time now. It's called DelimitedList

So there's always that option if the errors in the logic inspector prove to be a problem for you.

Re: Two (3?) Questions on Concatenation

Jimmy — Wed, 13 Jun 2012 14:58:41 GMT

Yes, it does seem to be common for the double eval trick to cause a processing error in the design checker. I haven't heard of this causing any actual issues in the operation or publishing of the form, but it does prevent the design checker from displaying everything correctly.

Perhaps this would be a good reason for us to add a Join command to our qRules suite. We'll take it under consideration.

(See below)

Re: Two (3?) Questions on Concatenation

merley72 — Wed, 13 Jun 2012 14:41:38 GMT

Jimmy

Thanks hugely for the guidance over this element. I'm certain that many people will have used this as I have to get things working correctly, and to concatenate a bunch of variables into a single field, so thanks for the help. For myself I've used it to create a list of email addresses which I then swing through into SharePoint and use in a workflow (better formatting, layout and options etc in SP Designer than through IP).

However there is one thing that does worry be about this, namely that as soon as I add this processing onto the 2 fields in the form, I get a Processing error appear in the Rule Inspector for the Calculate Default Values and Actions elements. I can still save the form and publish it ok (I think) and if I look at the design checker it doesn't throw a hissy fit (which is great), so is there any concern in having this processing error?

Do you get one in your situation and do other users such as Jen B get one? I'd appreciate any feedback people have over this, and like to know the root cause if you can second guess the problem.

Again thanks for the help.

Alan C.

Re: Two (3?) Questions on Concatenation

Jen B — Thu, 07 Jun 2012 17:54:20 GMT

I bow down to you...

THANK YOU!

Re: Two (3?) Questions on Concatenation

Jimmy — Thu, 07 Jun 2012 17:41:00 GMT

To fix that, you need to add a similar formula as the default value for the text field, except instead of this time, instead of manually using ../my:RqtType, you would use the select field button.

Re: Two (3?) Questions on Concatenation

Jen B — Thu, 07 Jun 2012 17:38:02 GMT

Oh, oh, oh... just saw/learned I can copy the Xpath of the field. Got it. So, I put it in my real form and IP now accepts the formula BUT if I uncheck something, it stays in my text field... so, how do I remediate that?

And, FYI, you are a rockstart... a patient, patient rockstar

Re: Two (3?) Questions on Concatenation

Jen B — Thu, 07 Jun 2012 17:31:57 GMT

Ok... I'm so confused. So when you entered it that way... were you using the Insert Field Group button? I literally feel like banging my head against something incredibly hard.

Re: Two (3?) Questions on Concatenation

Jimmy — Thu, 07 Jun 2012 17:28:48 GMT

I changed it to this, and it worked:

substring(xdMath:Eval(xdMath:Eval(../my:RqtType[. != ""], 'concat("; ", .)'), ".."), 2)

Re: Two (3?) Questions on Concatenation

Jen B — Thu, 07 Jun 2012 17:21:16 GMT

Hi Jimmy, thanks for responding...and catching me on the other post. Are you talking about the first dot in the entire formula or from the 'not an empty string' portion of the formula? Either way... the first dot in the formula is the multi-select field and I have actually tried entering the field into the 'not an empty string' portion as well and it still freaks out about the bracket.

I just don't get what the heck is going on. IP just doesn't like [. != ""] when I enter it...

Re: Two (3?) Questions on Concatenation

Jimmy — Thu, 07 Jun 2012 16:40:02 GMT

It looks like you also have an extraneous left parenthesis after the second eval.

Re: Two (3?) Questions on Concatenation

Jimmy — Thu, 07 Jun 2012 15:00:20 GMT

Please try replacing that first dot with the following:

../my:MultiSelectFieldName

Re: Two (3?) Questions on Concatenation

Jen B — Thu, 07 Jun 2012 14:16:27 GMT

Anyone able to assist with this? Still struggling with this stupid formula... I've tried another found in an IP book, but the same issue occurs with the bracket.

Re: Two (3?) Questions on Concatenation

Jen B — Wed, 23 May 2012 15:00:10 GMT

I've noticed IP's tendency to get irritable when open too long. I actually restarted computer beside shutting down IP, but I still get the same error when trying to preview. That the form template isn't valid and there's an unspecified error. It's definitely directly connected to the formula in the default value field as the error goes away when I remove it.

I also just got a chance to test the concatenating with the multi-select field. Getting error...

The formula is in like this: substring(eval(eval((.[. !=""], 'concat(";", .)'), ".."), 2)

The error I'm getting is:

Expected value type: )

Actual value: [
substring(eval(eval((.-->[<--. !=""], 'concat(";", .)'), ".."), 2)

If I take out the double (( after the 2nd eval, I get this error:

Expected value type: ,

Actual value: [
substring(eval(eval(.-->[<--. !=""], 'concat(";", .)'), ".."), 2)

Thoughts?

Re: Two (3?) Questions on Concatenation

Jimmy — Tue, 22 May 2012 23:57:18 GMT

The formula certainly looks like it's alright. Could you try saving, closing and reopening the template? Sometimes InfoPath seems to just get into a bad mood and need a fresh start.

Re: Two (3?) Questions on Concatenation

Jen B — Tue, 22 May 2012 21:15:24 GMT

Looks like I'm running into the same problem another person had... when I set the default formula on the field and try to preview, I get an error saying it isn't a valid form template and won't preview. If I remove the formula, the preview works just fine. The formula now looks like this:

substring(eval(eval((ImpctAudBllng | ImpctAudBllngAllnc | ImpctAudBllngEmpAcct | ImpctAudBllngNE)[. != ""], 'concat(",", .)'), ".."), 2)

Xpath: substring(xdMath:Eval(xdMath:Eval((../../../../my:SecImptAud/my:SecImptAudBREC/my:ImpctAudBllng | ../../../../my:SecImptAud/my:SecImptAudBREC/my:ImpctAudBllngAllnc | ../../../../my:SecImptAud/my:SecImptAudBREC/my:ImpctAudBllngEmpAcct | ../../../../my:SecImptAud/my:SecImptAudBREC/my:ImpctAudBllngNE)[. != ""], 'concat(",", .)'), ".."), 2)

Not sure if it's a formula issue with me typing something wrong, a placement issue (putting in the Default Value field of text box), or something else bizarre.

Haven't even been able to test the multi-selection one yet... oh technology and learning it...