Office 365 Installations

SharePoint TODAY column in calculated fields and auto updating it

There has been much discussion around using a [TODAY]  column in SharePoint Lists since SharePoint Lists and Libraries have been around. Other than being able to use [Today] to set a DEFAULT value, users have always asked if they could use it in a calculated field. There are workarounds well documented in various threads that detail creating a field called “Today”, then creating a calculated field ([CalculatedToday]) that references the “Today” field, and finally removing the “Today” field in order to be able to use “[Today]” in a calculated field.

The question that follows is always, “how do I get the [CalculatedToday] to update every day or on a scheduled basis?” Again, there are numerous articles documented on the internet that suggest adding and removing a [Today] field and SharePoint will update all the [CalculatedToday] fields with the current Date. Administrators have created scripts and even timer jobs to do this automatically. This method [...]

Setting up Office 365 on a WordPress hosted domain name

Many people use WordPress.com for their public facing website.  If WordPress manages your domain (i.e. your name server is pointing to WordPress, then you will need to set up Office 365 DNS entries on WordPress.  When setting up Office 365, you have to add appropriate DNS entries for CNAME, SRV, TXT, and MX records. The typical instructions per Microsoft look like the following:

(These are for the surfpointtech.com domain, change accordingly)

To add these entries in WordPress, go to your Dashboard, Store, Domains, Edit Domain.  The problem is, if you paste these straight into WordPress, it will not work. WordPress uses a shortened version for CNAME.

For the SIP and LyncDiscover CNAMES, take out the “.domain.com” and it will work. If you don’t do this, you will get a “Cannot connect to server” error on Lync on your iPhone.

Below are the correct format DNS entries for WordPress hosted domains to work with Office 365 [...]

Understanding Office 365 terms

Here’s a good reference of what the actual deliverables are for Office 365. The terms can get confusing, especially when trying to understand the Office 365 Pro Plus and the desktop suite.

•Office 365 Platform includes information about the Office 365 hosted solution platform that is common across the other services. The Office 365 Platform service description is where you’ll find details about Office 365 user management, support, service updates, privacy and security policies, and other operational details that apply across the individual services and are part of the core Office 365 service.

•Exchange Online is a hosted messaging service offered in some Office 365 plans that web-based email, calendar, contacts, and tasks from PCs, the web, and mobile devices. In the Exchange Online service description, you can easily see which Exchange features are available across Office 365 plans. In addition, you can compare Exchange Online feature availability to an Exchange [...]