Column Auto Increment through SharePoint Designer

Hi,

After adding a new item in the Sharepoint list, value should be incremented under a Sharepoint column ‘ChronoListField’.

This has to be achieved with SharePoint designer workflow.

To achieve this, first we have created a list ‘ChronoIncrement’ and added a column ‘AutoIncrement’ of type number.

Now we have created workflow in the list where column value needs to be incremented with newly added list item.

Through Do Calculation we have done the manipulation as below i.e.

Under Data source, have selected list ‘ChronoIncrement’ and have selected field ‘AutoIncrement’ field to retrieve.

To find the list item, have selected ID field and the Value ‘1’

Incremented the value and have assigned to a variable called ‘incrementedval’

After this have assigned variable ‘incrementedval’ value to SharePoint column ‘ChronoListField’

Then updated the value back to list ‘ChronoIncrement’ under column ‘AutoIncrement’ w.r.t ID value ‘1’

After this, logging the incremental value to the history list

Ended the workflow as below

At last below is the workflow that has been published

End Results

Below are the results that have been achieved

WHY SHOULD I UPGRADE TO SHARE POINT 2016?

Hi,

Below are the reasons listed so far to upgrade to SharePoint 2016

•       Support

•       Cloud

•       Stability

•       HYBRID – Delve, Profile Redirection, OneDrive, Search, Hybrid Sites, Groups

•       Data loss Prevention (DLP)

•       Performance and Patching

•       Upload and DB size

•       Fast Site Collection creation

•       Durable Links

SHAREPOINT 2016 DEPRECATED FEATURES

Hi,

Below are the deprecated features that have been noticed so far in SharePoint 2016

•       SharePoint Foundation is no longer available.

•       Standalone Installation

•       Forefront Identity Manager(FIM)

•       Excel Services is no longer part of SharePoint Services

•       SharePoint BI Capabilities

•       Tags and Notes

•       STSADM

HYBRID POSSIBILITIES in SharePoint 2016

Hi,

Below are the hybrid possibilities that have been noticed so far in SharePoint 2016

•       Unified Search Capabilities

•       Hybrid extranet sharing.

•       OneDrive Redirection

•       Sites Follow IN ONE Place

•       First Cloud Down Release

•       App Launcher and UI changes in SharePoint 2016

SP 2013 vs SP 2016

Hi,

Below are the differences that have been noticed so far in SharePoint 2016 w.r.t SharePoint 2013

SP 2013	SP 2016
CONTENT DATABASE SIZE -       200GB -       5000 SITE COLLECTIONS	CONTENT DATABASE SIZE -       1TB -       1,00,000 SITE COLLECTIONS
INDEXED ITEMS -       100 million indexed items per search service application -       10 million per index partition	INDEXED ITEMS - ABOUT 500MILLION ITEMS( TWICE the size)
Max File Size  - 2GB	Max File Size  -       10GB
THRESHOLD -       5000	THRESHOLD -       REMOVED(SORT OF)
-	DURABLE LINKS
CHARACTER RESTRICTION FOR FILENAME	NO CHARACTER RESTRICTION FOR FILENAME

New Features in SharePoint 2016

Hi,

Below are the new features in SharePoint 2016 that have been noticed so far

•       MinRole - Automatically configures the services on each server.

•       Services on Server

•       Durable Links

•       Extended File size and Threshold

•       Image and Video Preview

•       Zero Downtime Patching

•       No Filename Character Restrictions

•       Integrated Project Server

•       App Launcher

•       Open Document Format

•       Document Deletion Policy center

•       New Collaboration Experience in SharePoint 2016 – TOUCH FRIENDLY INTERFACE

What's New on SharePoint 2016

Hi,

Below are the updated that have been received from our architect.

​What's new

·         New MinRole- Server roles are now streamlined as User, Robot and Caching. SharePoint logic behind multiple services are now consolidated into one single ​machine thereby reducing no. of discrete roles (Web frontend, Application, Specialized and Caching).

·         New Role based installation let you install SharePoint components required for chosen roles

·         SAML based authenticaation using OAuth 2.0

·         Office graph and delve support. It's also coming to SharePoint 2013 as update

·         Durable links - File links will be based on reference id and not url , so no matter where the file is or moved somewhere, the link just works (no more broken links...yaaaayyyy!)

·         Fast site creation using SPSite. Copy at Content Database Level

·         Cloud search service application - Unified on-premises and cloud index and provides support for Office Graph/Delve. New search as a service reducing crawl footprint 

·         Real-time Telemetry - New usage data analytics reporting and logging apis

·         Migration apis to migrate content from SharePoint 2013.

·         Video portal as in O365

·         Support of ODF in document libraries

·         Site Publishing - Publish internal sites to internet (Extranet) using O365 identity federation services

·         Automated hybrid deployment, configuration of pre-requisite and core infrastructure. This mean no need to write 50 pages of powershell!!!

What stays

·         Farm solution will continue be supported, however the new app model will see more updates and traction

What's gone

·         ​Standalone installation - You need to have a SQL Server 2014 installed and configured already. Its called Single Server Installation

·         Classic authentication

·         FIM for user profile within SharePoint farm. It will be now external to SharePoint

What's updated

Now be ready to get surprised and make sure you don't scream,

·         Content database can grow up to 1 TB

·         100,000 site collections in single web application

·         List threshold limit much higher that 5000. They did not disclose the exact figure, but gonna be much higher...this is real big one developers

·         Search index size increased by 2 times to 500 million items

·         Improved files performance using BITS protocol

·         Patching is totally changed from 2013 with very few MSI and MSP files. In place and online installation are supported

·         Improved bi-directional user profile sync by having external FIM

·         Project server database is merged with SharePoint content database and not separate anymore

I will end this by a quick summary on system requirements and migration options, 

Hardware requirements remains same as of 2013,

16 - 24 GB, 64 bit Quad core processor for single server farm

12 - 16 GB, 64 bit Quad core processor for multi-server farm 

In order to migrate to 2016 you have two options,

1.       First upgrade 14.5 version to 15 site (2010 mode to 2013). Then use DB Attach Detach to migrate to 2016.

2.       Use 3rd party tool or migration api (which is planned) to migrate content.

Happy Share Pointing folks!