Partager via

Improvements to Share Point integration - Property demotion

  • Article

One of the new features in InfoPath 2007 when publishing to a SharePoint 2007 server is the ability to turn on property demotion.

 

Property demotion is the ability to be able to modify fields that show up in SharePoint document libraries and cause those fields to be automatically updated in the underlying document (in this case InfoPath form).

 

Where would you use demotion?

Imagine you have a document library where you save your company assets as InfoPath forms. Let us say one of the fields in the library, is the current owner of this asset. When you need to bulk assign a bunch of assets from one person to another, wouldn't it be really easy if you can just update this field in a data grid view instead of opening each and every asset form and having to update it.

 

Let us see how you can enable property demotion

When you go through the publish wizard (File/Publish) pages for publishing to SharePoint, InfoPath will detect if the server is 2007 and if it finds that to be true, you will now be able to turn on property demotion for a field by selecting the check box as shown in the image below.

 

 

Note that not all data types can be demoted and also fields that are within a repeating context cannot be demoted. For data types that don't allow demotion, the checkbox will automatically be disabled.

 

 

Once you enable certain fields for demotion, they become available in SharePoint's data grid view to be edited. The data grid view can be accessed from SharePoint library using the Actions menu as shown below.

 

 

 

Also since demotion happens on SharePoint side (when the field is edited), the form's business logic such as Data Validation, Rules, Formulas, Code and Script will not run at that time. So there may be situations when you do not want to turn on demotion for certain fields.

 

Hope you find this helpful and look forward to see you turning on demotion.

 

Thanks,

Anand

Lead Software Development Engineer

Comments

  • Anonymous
    June 14, 2006
    The comment has been removed

  • Anonymous
    June 14, 2006
    Weird name "Demotion" for this feature.

    Can demotion be enabled in a web part page?  For example, a dvwp?

  • Anonymous
    June 14, 2006
    The comment has been removed

  • Anonymous
    July 07, 2006
    PingBack from http://blogs.msdn.com/infopath/archive/2006/07/07/659534.aspx

  • Anonymous
    October 14, 2006
    PingBack from http://blogs.msdn.com/infopath/archive/2006/07/07/got-suggestions.aspx

  • Anonymous
    October 14, 2006
    This is a shout out to Andrew May, who's posted some great content on SharePoint as it relates to InfoPath

  • Anonymous
    October 27, 2006
    A number of good questions have been raised about the building permit application solution that we built. One question in particular that I see frequently relates to the SharePoint columns that were promoted from the InfoPath form template. How did we

  • Anonymous
    April 18, 2008
    Any reason that date fields can't be demoted and updated using workflow??  Seems very restrictive....  Is there a workaround??  (other than changing data type)

  • Anonymous
    April 18, 2008
    Hi angedjohnson, In order for property "demotion" to work the data type you choose in InfoPath must exactly match the data type in SharePoint. So for a date field, in InfoPath you would need to choose "Date/Time." Scott

  • Anonymous
    October 10, 2010
    The business logic is quite different and vary from market to market This is really a nice share point session. www.1800sharepoint.com/index.php