General

Re: Fill rich text field with formatted data from list - how can this be done?

AmsterdamSchool — Mon, 23 Jun 2014 13:36:05 GMT

UPDATE - much easier than expected I did get the permission. However, the next obstacle was just around the corner. The code builds fine, but when I publish it, I get a message that states that the sanbox solution can not be activated because of an error while validating Microsoft.ApplicationServer.Caching.Client. It also states that the solution references the illegal System.Threading.Timer which may not be used in a site collection.

Why might that be? My code does not use or reference any of the mentioned assemblies etc. It is completely based on this sample code: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f9cd50d5-0782-49c0-b71a-e242ff4d5758/how-do-i-retain-formatting-when-setting-fields-value-in-infopath-2010-to-be-formatted-text-from-a?forum=sharepointcustomizationprevious

Does someone understand what could cause these errors if I don't use these assemblies in my code and this is the only code behind used in the form?

Thank you.

Re: Fill rich text field with formatted data from list - how can this be done?

AmsterdamSchool — Mon, 23 Jun 2014 12:30:43 GMT

It is a browser form. Should have mentioned that. Filler mode is not an option.

I'll look into qRules, but I already saw that this also requires sandboxed forms. Curretnly the code is less of a problem than the permission, but worth looking in to.

Than you.

Re: Fill rich text field with formatted data from list - how can this be done?

Jimmy — Mon, 23 Jun 2014 05:31:14 GMT

If you are ok with having users access the form in Filler mode (in the InfoPath client), then you shouldn't need any elevated permissions to publish the form, just regular Contributor permissions. Is this a browser form?

Just so you know, qRules provides a command called CopyRichText that makes it really easy to copy rich text from place to place. qRules also provides all sorts of other helpfuly functionality and takes all the hassle out of writing your own code. I recommend checking it out as it can save you lots of time and effort.

Re: Fill rich text field with formatted data from list - how can this be done?

AmsterdamSchool — Fri, 20 Jun 2014 17:45:03 GMT

A shame that there is no codeless solution to do something that seems as straightforward as retrieving formatted text to go into a rich text box. Oh well... Thanks for the explanation Hilary.

Re: Fill rich text field with formatted data from list - how can this be done?

Hilary Stoupa — Fri, 20 Jun 2014 17:34:37 GMT

Unfortunately a browser form with code either needs to go in the Sandbox (which means you have to be a site collection admin and publish directly to the library) or be admin approved (which means it is uploaded to central admin. I don't know of a way to do what you want to do without code, however.

Re: Fill rich text field with formatted data from list - how can this be done?

AmsterdamSchool — Fri, 20 Jun 2014 17:31:34 GMT

UPDATE - I am now able to add the code, but it turns out I need admin rights to the site collection in order to upload my form. Not sure if I'll be able to get those and how fast. Is there an non-code solution? Not that I mind doing it in code, but I get stuck on permissions... Thank you

Fill rich text field with formatted data from list - how can this be done?

AmsterdamSchool — Fri, 20 Jun 2014 16:52:44 GMT

I'm trying to pull formatted text from a SharePoint list (Office 365) and display it in a rich text box on my form, with it's original formatting. So far all formatting keeps getting lost in the process. I understand it can be done with code behind. I tried this, but because I don't have SharePoint installed locally this is proving to be surprisingly difficult. I managed to get the microsoft.sharepoint.dll from somewhere, but I still cant run the code. I get error messages about missing namespaces. Cab someone show me an alternative route, or explain how I can use code behind without SharePoint on my machine? I use SharePoint Online 2013, InfoPath 2013 and Visual Studio 2012. I would be very grateful. Thank you. This page explains how it can be done with code behind: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f9cd50d5-0782-49c0-b71a-e242ff4d5758/how-do-i-retain-formatting-when-setting-fields-value-in-infopath-2010-to-be-formatted-text-from-a?forum=sharepointcustomizationprevious