InfoPath Dev

OK, I fixed number 1 already by putting open brackets at the start of the formula and at closed brackets before the / 30 * 100 2. Nan error - is the only thing I need guidance on now I think... Mike

Hi Hillary,  Thanks for your amazingly quick response. Good Advice - Present me has fondly thought of future me and renamed all fields!! I plugged in the formula: Here it is: WelcomeResult [.!="n/a"] + ToneResult [.!="n/a"] + EmpathyResult [.!="n/a"] + LanguageResult [.!="n/a"]  + ...

in my InfoPath form there is the possibility of to click on option and to automatically send itself via e-mail as body mail message addresses to a list of default .... everything works fine if I use the form over the LAN, but if I try to post the form to sharepoint 2010 does not work this, ...... someone can help me?  

Thanks for all your help. I ended up getting this to work: concat(substring(NAME, 1, 1), substring(substring-after(NAME, " "), 1, 1), number(substring(DATE, 3, 1)), number(substring(DATE, 4, 1)), number(substring(DATE, 6, 2)), number(substring(DATE, 9, 2)), concat(substring(now(), 12, 2), substring(now(), 15, 2)))  And this is ...

Hi, it's easier if you have 2 fields one for the firstname and another for the last this formula is not full proof it only work for this pattern:"firstname lastname" concat(substring(field1; 1; 1); substring(field1; string-length(substring-before(field1; " ")) + 2; 1); substring(now(); 3; 2); substring(now(); 6; 2); ...

Solution so far: concat(number(substring(DATE, 3, 1)), number(substring(DATE, 4, 1)), number(substring(DATE, 6, 2)), number(substring(DATE, 9, 2)), concat(substring(now(), 12, 2), substring(now(), 15, 2)))  That is returning the date (from a date picker) and the time(now) as YYMMDDHHMM The names are formated as "firstname ...

Hi oliviar, I help you on the second part of your form because I'm not certain on the format of your name field. For the pattern:YYMMDDHHMM, you can use: concat(substring(now(); 3; 2); substring(now(); 6; 2); substring(now(); 9; 2); substring(now(); 12; 2); substring(now(); 15; 2))

Alright, I worked out a little bit of it myself: This is date in YYMMDD format: concat(number(substring(DATE, 3, 1)), number(substring(DATE, 4, 1)), number(substring(DATE, 6, 2)), number(substring(DATE, 9, 2))) But it will only work if the date comes from a date picker (called DATE in this case)   So I please need help on the TIME (now) ...

I have been trying to construct a formula that take the initials of a persons name (from the 'name' field) and the DATE expressed as YYMMDD and the TIME expressed as HHMM. And concatenated it looks like ABYYMMDDHHMM I keep ending up with a complete dog's breakfast of either errors or '12-2812:33' or '198,456,44' and ...

Hi, have you try to use the form cache to get your xsd file :string cacheID = this.Application.ActiveWindow.XmlForm.Template.CacheId; string path = this.Application.GetFormTemplateLocation(cacheID); http://msdn.microsoft.com/en-us/library/microsoft.office.infopath.application.getformtemplatelocation(VS.80).aspx