Notes, great finds, and more about SharePoint solutions, JavaScript, React, and more.
The following items can help your Nintex workflows run more reliably and efficiently: 1. Disable Nintex history logging in the workflow settings 2. Create one Nintex database per Web application in SharePoint 3. Run the Nintex purge workflow script every six months or more often, depending on your farm https://community.nintex.com/docs/DOC-1218 4. Use workflow constants. Best […]
Having trouble getting JavaScript files to run in your SharePoint site? Make sure you set the LoadAfterUI=”true” attribute in your ScriptLink tag. Here is an example: <SharePoint:ScriptLink ID=”MyBaseID” Name=”~Site/_catalogs/masterpage/MyPathtoJavascriptFile/mycustomjavascriptfile.js” runat=”server” OnDemand=”false” LoadAfterUI=”true” Localizable=”false”/>
Use Business Connectivity Services (BCS) when you want to: 1. Provide a no-code solution 2. Create several Web Parts that would all use the same ADO to connect to the SQL database. 3. Re-use code even if someone renames the SQL server, moves the database, or renames a table or column. 4. Maintain one connection […]
Need to upload an Excel to a SQL Server database on a regular basis? Check out the following article on SQL Server Integration Services (SSIS): http://www.excel-sql-server.com/excel-import-to-sql-server-using-ssis.htm
Workflow best practices for Workflow designers should document the workflow against the business process that the workflow supports. Workflow designers should be prepared to educate workflow participants on how to use the workflow and any custom security settings. Some processes are better implemented manuallyâ for a period of time before you automate the process. This […]
To avoid NaN appearing in calculation results of InfoPath formulas, do the following: Use Now instead of Created. Try to avoid using the Automatically retrieve data when form is opened option. If a form is slow and a data connection has the setting Save with form checked, try clearing this option. If data connection still […]
You can use the following formulas in SharePoint site columns. You can place any of the following formulas into a calculated site column. AcknowledgeDate1 = End date Created = Start date You can specify an exact start and end time for each day. The total number of hours is slightly low or high for modifications […]
1.Add a list to the SharePoint project using the tools in Visual Studio. 2. Deploy the lists. 3. In the SharePoint site that you deployed to, build views with correct columns, limits, filtering, and grouping, and sorting. 4. Save the list as an .stp file. 5. Next, you will save the .stp file to your […]
You can download the notes from my presentation on InfoPath 2010 Tips and Tricks, along with the list templates and step-by-step instructions. The instructions describe configuring cascading dropdown lists and custom unique record identifiers in InfoPath.
To add SharePoint:ScriptLink tags to your master on-the-fly, you can use a custom action or a delegate control. The following references provide the details: http://sharepoint.stackexchange.com/questions/56731/add-script-reference-to-all-pages-in-a-site-collection-when-a-feature-is-activat https://msdn.microsoft.com/en-us/library/ms463169(v=office.12).aspx