The Need for Efficient Date Handling Date values and operations are used extensively in SharePoint solutions, including formatting dates for display, calculating and comparing dates, and enabling date picker controls for data entry. However, JavaScript date processing can consume excessive client-side resources if not optimized, resulting in poor performance and high latency. JavaScript dates are…
Inconsistent Date Handling in SharePoint Can Introduce Risk Inconsistent date handling refers to the use of varying date formats and logics across SharePoint components like regional server settings, client machine settings, custom solutions, and external system integrations. When dates are parsed, interpreted and rendered differently in SharePoint environments, it introduces various data, functionality and usability…
The Problem with Default Date Formatting in SharePoint SharePoint displays dates using the default format of MM/DD/YYYY. This format may seem unintuitive to users in some regions who are accustomed to seeing dates formatted as DD/MM/YYYY instead. The inconsistency between SharePoint’s date format and a user’s expectations can cause confusion when interpreting dates shown in…
The Need for HTML Markup Using HTML markup in SharePoint calculated columns provides several benefits for formatting, adding links, displaying images, and more. The out-of-the-box calculated columns in SharePoint have limitations that can be overcome by enabling the use of HTML. Benefits of HTML Markup in Calculated Columns Format text with bold, italics, underlining, font…
What Gets Blocked and Why SharePoint calculated columns do not allow the use of HTML tags or JavaScript code. These markup languages get filtered out and blocked for security reasons. SharePoint is designed to prevent the injection of potentially malicious code into sites and libraries. The platform’s automatic input validation strips out anything that looks…
What Are Calculated Columns and Why Extend Them? SharePoint lists and libraries allow for calculated columns that compute values based on other columns and metadata. These can apply formulas, formats, and logic to generate useful information for items. However, the platform’s built-in calculated features are limiting – formulas use Excel-style expressions, data types are restrictive,…
What is Client-Side Rendering and Why Use It? Client-side rendering refers to generating markup and rendering web page content in the user’s web browser rather than on the web server. With client-side rendering, the initial page load contains minimal HTML, CSS and JavaScript code. Once loaded, JavaScript code fetches data from an API and uses…
What is Causing Loss of HTML Markup in Calculated Columns SharePoint Online displays calculated columns by rendering their output on the client-side by default. This means that the formula and formatting for a calculated column is processed by each user’s web browser rather than on the SharePoint servers. When content is rendered client-side, certain HTML…
An Overview of Connecting SharePoint and Azure SharePoint and Azure offer complementary capabilities that can be integrated to enhance collaboration, productivity, and data insights. By connecting SharePoint’s collaboration and content management features with Azure’s scalable cloud services, organizations can optimize workflows, apply intelligence, and enable more powerful cross-platform search and productivity. Key Azure services to…
What is the core difference between SPFx, Add-ins, and Web Parts? The SharePoint Framework (SPFx) allows developers to build client-side solutions using modern web standards like HTML, CSS, JavaScript, and web frameworks such as React, Angular, or Vue. SPFx solutions consist of client-side web parts, extensions, or custom Teams apps that run in the browser….