-
4000 items in a SharePoint library is a lot.
I'm not sure how you or why you need to promote 424 fields to a SharePoint library, that seem very excessive. Even in a SharePoint view that would look horrific, and you'd run into issues, especially if you were using lots and lots of calculated columns.
Does the form have one or many ...
-
All field values should be editable unless you have set them or the vierw to read only. Also check the user permissions on the form, are they too restrictive?
-
Yes, you would just need to filter the data base on the Employee Name or ID. You could also use the getuserprofile service or the getmanager option too.
-
I don't do code.
A mapped network drive would happen as part of a login script i..e like a home drive.
-
So you'd just create a field called file name and then you can format the name as you want.
-
I always thought that commas etc. where picked up from the user's Regional Settings. Assuming they are correct. You could use the translate function.
If you had a field called Cost it would be: translate(Cost, ".", ",")
-
Why not create a questionnaire site in SharePoint
Then have all your list data i.e. business unit, country, products as SharePoint lists. I think you could even connect these external lists to an access database if somebody else needs to maintain it. That way SP does the grunt work and not your form.
Within InfoPath, you'll need ...
-
2007 or 2010 what? SharePoint?
If all users have access to SP 2010 form library, I'd use that. Then put your form inside a webpart page and you should be good to go because users will use a browser to acccess and use the form.
You can use either a blank form or a Form library template. It makes no odd really (as far as I know) since ...
-
If I've understood you correctly
All you're need to do is add form load rules, so that each view opens up at the correct stage depending on when the form is opened and by whom. You'll need to copy your buttons to each view (I assume your buttons are on the form).
If you haven't already but your form inside a web part ...
-
SharePoint libraries already have options to connect to Excel or Access, look on the ribbon of your library.
Thing to note is that if you're connecting to the SP data source live, users will only have access to the data fields that permissions allow.
Option Buttons, by default have values associated with them i.e. 1,2.3 - look at the ...