Creating site column declaratively

Hi All,

Please find below site columns type normally helpful while creating site columns declaratively.

Type of field	Field Type
Yes/No	Type="Boolean"
Single line of text	Type="Text"
Multiple lines of text	Type="Note"
Choice (menu to choose from)	Single Choice (dropdown or radio buttons): Type="Choice" Multiple choices (check boxes): Type="MultiChoice"
Date and Time	Type="DateTime"
Hyperlink or Picture	Type="URL"
Integer	Type="Integer"
Number	Type="Number"
Person or Group	Single User or Group Type="User" Multiple Users or Groups Type="UserMulti"
Currency	Type="Currency"
Calculated	Type="Calculated"

Thanks,

Sachin K.

SharePoint Site Columns and Site Content Type Customization Best Practices

Hello All,

While creating Site Columns and Content Types we may came across a scenario that which option to go with.

1. Browser Based Custom Development
2. Feature Based Custom Development
3. Object Model-Based Custom Development

Please refer to this post  to see the best practices and pros and Cons of each approach while creating Site Columns and Content Types.

Thanks,
Sachin K.

Deciding between apps for SharePoint and SharePoint solutions

Hi All,

Please find below higher level decision table to go with apps for SharePoint and SharePoint solutions-

Key	Apps for SharePoint	SharePoint Solution
Environment	If you are building for Office 365, the choice is pretty clear that apps are the way to go.	If you are building a customization for the Central Admin, then a full-trust solution is the way to go.
Code-Reevaluation	Apps do not require you to do this at the same scale as full-trust code due to their loosely coupled nature.	Typically full-trust code must be reevaluated when you are upgrading SharePoint to ensure that the customizations will not negatively impact the upgrade to the next version.
Skills	Apps require you to just understand the object model you are using because an app will not impact the performance or stability of the SharePoint environment.	Full-trust code requires a deep understanding of the internal workings of SharePoint to build stable and scalable solutions.
Application lifecycle	Due to the isolated nature of apps, apps, in most cases, will not require that your application lifecycle processes test the SharePoint environment and other customizations along with your app.	Full trust code requires extensive lifecycle management processes and procedures to not only make sure the app itself works as expected, but to insure that the SharePoint environment including any other full trust customizations is also stable.

Reference

Thanks,

Sachin K.

Save (Not Permitted) Dialog Box

Hi All,

Some times you may get following error when modifying any SQL table 

"Saving Changes is not permitted. The changes you have made require the following tables to be dropped and re-created...."

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

Reference

Thanks,

Sachin K.