Newbie Questions

Re: Adding Spaces to string

Mirage — Mon, 16 Aug 2010 04:13:43 GMT

You are amazing. I had it in the default value. So I put it in as a rule to execute only if it was in the form \d\d\d\d\d\d\d\d or \d\d\d\d\d\d\d\d

No doubt I will find something else over time particulary integrating it with our current database. Will report back with the final product or any additional questions.

Re: Adding Spaces to string

Jimmy — Mon, 16 Aug 2010 03:16:49 GMT

It sounds like you have the field recursively recalculating its own value over and over, which is what is causing that error and giving you that unexpected behavior.

Are you using the formula in the field's Default Value, or a Rule? I would suggest placing the formula in a rule, and giving it the condition to only execute if the string is 9 characters or less.

Adding Spaces to string

Mirage — Mon, 16 Aug 2010 01:41:52 GMT

Hi all,

My employer has recently sent me on a basic infopath course and I have been given the job of digitising all of our forms. The first one, probably the most difficult one, is a new client form.

We are an accounting firm and the form will integrate with an excel database which then integrates with our CRM. I am slowly getting there however I am having issues with what we call a Tax File Number. It contains 8 or 9 numbers and needs to be in the format dd ddd ddd or ddd ddd ddd.

I have used the following formula

concat(substring(., 1, string-length(.) - 6), " ", substring(., string-length(.) - 5, 3), " ", substring(., string-length(.) - 2, 3))

It throws the error of to many calculations. The first 2 or 3 digits work and the last 3 work but the middle 3 does something weird.

123456789 -> 123 4 5 6 789. If I change the middle section to be 2 long instead of 3, it shows like it should however I get the to many calculations error again and of course the middle section is 1 number to short.

Any help would be greatly appreciated as I have exhausted my ideas and cant find anything that really helps on any websites.