Skip to main content

InfoPath Would Not Submit a Form - Concatenate function yielded a title that was too long!

Had a user today who was experiencing issues submitting an InfoPath form.  The original set of error messages made me assume that SharePoint was not set as Local Intranet site (which it wasn't).  So I set SharePoint as the local intranet site,  updated the user's desktop icon shortcut (to use the https version of the site).  And thought, okay, problem solved.  Alas and alack, not so!

The user entered a form went to submit it and got a different set of error messages. (Unfortunately I didn't think to screenshot the errors and send them to myself so I don't have the exact wording for any of the errors.)  The basic message the second time was InfoPath cannot submit the form.  I've seen variations of this error before, so I started looking at Compatibility View, and Add-ons.  Well, I found the user had IE10 which we recommend our users NOT install as there are known compatibility issues with IE10 and SharePoint 2007 as well as some of our other internal systems.  So, I had IT roll her IE version back to IE9.

Again, I thought, okay, problem solved.

Alas, still not so!

This time the error message was one I had never seen.  Something along the lines of the administrator does not allow this form to be saved. To which I thought, okay, I'm the administrator so why am I not allowing this??

I kept looking at first one setting and another and then I got to noticing the name of the form.  The form names are created by concatenating several different fields in the form (user name, title of activity, and date in this case).  In this particular instance the Title of the Activity was about 20 words long (and most of the words were more than 4 - 10 letters).  Which made me wonder, could it be that the title is too long?  I know that there are limitations in Excel using the Concatenate function (255 characters I believe is the limit, but I could be wrong on that)....

What the user had was something that looked like this:  LastName_FirstName I Attended A Webinar On Using Mobile Multimedia and Something Else and Something Else in a Particular Field Class with something else and Something In something or other _today's_date. (NOTE: names have been changed to protect the innocent and the unassuming).  

 Of course in InfoPath every space became %20, so you can imagine the nastiness of this name for the form.

Solution??  I had the user change the name of the activity to something much shorter.  And the form submitted without issue.

Another interesting dilemma in the world of SharePoint.  I advised the user in the future to keep names in this form short and simple.

Happy SharePointing all!






Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Creating a SharePoint blog post using Word 2010

Create your blog posts in Word 2010 and post to your SharePoint blog (or other blogs such as Blogger). It's really quite simple. Open Microsoft Word 2010. From the Start menu, Select NEW>Blog Post The first time you do this, you'll be asked to register your blog platform. Word provides several options. I selected Blogger (of course). Provide your account # and password: Then you'll be asked to provide Picture Options... provide your server location or choose None. (see this page from Microsoft for more details on the Picture Options: http://office.microsoft.com/en-us/word-help/help-with-blogging-in-word-HA010164021.aspx?ver=14&app=winword.exe#_Toc321212396 ) ) Type your blog post as normal, inserting pictures if desired and publish. This Microsoft Video shows you how: http://office.microsoft.com/en-us/sharepoint-server-help/video-use-word-2010-to-post-to-a-sharepoint-blog-VA101790488.aspx
Post a Comment
Read more

This link no longer works, because it may have been moved or deleted error when following a site from a Mysite location

This link no longer works, because it may have been moved or deleted. You can try to find it and follow it in its new location. (via www.absolute-sharepoint.com ) I had a problem at a client who had SharePoint 2013 MySites and a couple of WebApplications. Users were able to follow sites and they appeared in their mysite as usual, however when they clicked on them, they had this error: This link no longer works…
Post a Comment
Read more

A review of VisualSP for SharePoint 2013 - unsolicited

One of the things we wanted to do in our new SharePoint 2013 environment was create a more user friendly environment and increase adoption by giving users the ability to learn "how-tos" without the need of a training class or a guided tour by the SharePoint person (aka me).  My first thought when we began planning for the upgrade was that built-in help would be excellent, but would also be a monumental task to create.  Having used many of SharePoint-Videos.com videos for my own learning needs, I turned to their site for ideas. Enter VisualSP.  Obviously, I'm not the only person who desired in-context help for the end users. We purchased VisualSP for SharePoint 2013.  Once our environment was configured properly, installation was not difficult. The installation procedures were straight forward and easy to follow. I am not replicating that information here, but will hit the highlights.  For full details and screenshots, see the link above. Installation must...
Post a Comment
Read more