InfoPath Dev

sorry, im a bit of a n00b, and most of that went over my head. According to that, is it more of a limit in the database or sharepoint itself? I dont follow the tables / rows?

Im trying to publish my infopath form to sharepoint which has approx ~50 columns (these are ALL required), but getting an error "cannot update library or list" which im almost certain is down to the number of columns i've mapped. I've tried it with alot less columns and its publishing fine.  Does anyone know the limit for ...

I wasnt using concat, but there was also a spelling error in my fieldname, all sorted now thanks. One last (and very last!), the infopath form submits the date as DD/MM/YYYY (I have also checked the formatting), and displays as this, but when saving, the file name gets reverted to YYYY/MM/DD. I have the date field mapped to a column in ...

That worked a treat thanks. I was already using that formula, but not wrapping it around the whole (existing) formula. One last thing, Ive chose to submit this to a sharepoint list, using the file name as: Fieldname1 - FieldDate The first field is a location and the second is a date. But when saving I get the NaN as the file name. Is there a ...

Wow, thank you guys, for all your help, the problem is solved. @Jimmy, Is it possible to add a translation function into this, to convert say.... "aN" to a zero, such that the NaN error would be replaced with a zero if nothing is filled out?

Qazi, Would you mind explaining on what each of the cells are used for? I can follow it, but just not understand it all fully.  Thanks,

Qazi, You are a real gentlemen! I will take a look at the code and compare to what I previously had. I think I should be able to expand on this. Many, Many thanks Adam

Logically thinking, I think it can be achieved by the following info; I have 10 fields, with 1-10, so the maximum score can only be 100 (providing all fields are used). What I think I need is "(field1 + field2 + field3 ...+field10) div (100 "then some if statments - if field1 = blank -10, if field2 = blank - 10..... if ...

Hi guys, im a real infopath newbie, on a steep learning curve, but enjoying it so far.  I have 10 fields, lets say field1, field2..... field10, each containing a drop down value of 1-10, with an optional blank choice if the particular item is not applicable. (the user might only fill out fields 1 to 5). I would like to work out a percentage ...