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!






Comments

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
Creating and applying a Composed Look: 1. Download SharePoint Designer 2013 and SharePoint Color Palette Tool. 2. Create your theme using the SharePoint Color Palette Tool and save it as a .spcolor file. Suggest that you sort the Color Slot Grouping by UI Groups. 3. Open SharePoint Designer 2013. 4. Click Open Site. 5. Enter the URL of your SharePoint page (Master Page). 6. Click on All Files under Navigation. 7. Click on _catalogs. 8. Click on theme. 9. Click on 15. 10. Click Import Files. 11. Select your .spcolor file and click ok. You should now see your template file in the 15 directory. 12. Click All Files. 13. Click images. 14. Click Import Files. 15. Select the image you want for your background image and click ok. You should now see your image file in the image directory. 16. Now open the master page that you want to add the theme to in SharePoint 2013. 17. Click on the settings icon and select Site Settings. 18. Under Web Designer Galle...