InfoPath Dev

Do you know how many characters you can have in your field that you are setting? The formula would change to be: substring(Your Current Formula Here, 1, Total Length Here)

I came up with a work around to populate the hidden field before the submit but I would still like to add on the @Created by field which is queried on submit.  Is there a way I can attach @Created by to the end of the formula?

I'm not well versed on the substring.  What I have is just a copy and paste from what someone else gave me.  how should i incorporate it into the formula?

You could use a substring formula around your concat to truncate to a specific length.

So, I think I figured it out.  I think it has to do with the formula for populating the hidden field.  For mdebit, the formala is:  concat(Type, " ", "Effective Date:", concat(substring(Effective_Date, 6, 2), "/", substring(Effective_Date, 9, 2), "/", substring(Effective_Date, 1, 4)), " ...

Yes.  The type field is a radial button. button 1 = mdebit and button 2 = Phone_Address.  It is a required field so one or the other must be selected. The rule to submit to the sharepoint library works all the time, no matter if button 1 or 2 is selected.  The submit rule to query Created by from the library and email to ...

So, you have the Type field displayed on your form, and you can see that the value is Phone_Address and you click Submit and the rule doesn't fire?

Yes these are submit rules.  I've tested all the fields in the condition and initially they work.  Then I publish and test all the fields from the live site.  They still work.  The users will begin using the form again and it works... A few minutes later, only 1 condition is working for all of us.  Even the saved copy ...

These are Submit rules? In general, if rules aren't working as I anticipate, I assume that a condition is not what I expect, for some reason. If this were my form, I'd put all the fields in play onto the form, temporarily, and see if I can determine a reason for the change...

I have built a Data Query that retreives the Created by data from a sharepoint list.  On submit, the form does the following: (no conditions)Submit to sharepoint If Type = MDEBIT Query Created by Populate a hidden field with summary MDEBIT form data which includes @Created by If Type = Phone_Address Query Created ...