Monthly Archives: October 2016

New SharePoint apps for education and business

We are releasing several apps for SharePoint (on-premises and Office 365) I’ve included some information below, please feel free to drop me an email or give me a call if you want an online demonstration of the Apps. More information on the apps can be found here

Parents evening booking system

Parent evening booking SharePoint App

This app allows parents to view available days/times and book online. This app was designed to reduce the administrative time taken to book slots on behalf of parents based on their preferences.

Parent evening booking SharePoint App

Some of the features include:

  • Parents view available slots
  • Parents book online
  • Parents can make changes to the booking
  • Teachers can see who has booked to see them
  • Admins can upload session data via spreadsheet
  • Supports multiple children at the school
  • Updated several times a year as part of the subscription

Internal helpdesk

The Cloud Design Box internal helpdesk app manages all your support tickets in an easy-to-use list. Users can view and update their own tickets while the helpdesk team have access to manage all the support tickets.

Parent evening booking SharePoint App

Leave requests

Leave and holiday requests tend to create a burden on admin, managers and human resources. Streamlining requests to just a few clicks and automating the processes by sending notification emails saves everyone time.

Parent evening booking SharePoint App

Using the Cloud Design Box dashboard, employees can view all approved holidays for their team, allowing them to make an informed decision on when to request leave. Employees fill in a simple form on the site which is them emailed to their manager for approval. In just a few clicks the manager can approve or reject with some feedback.

Employee onboarding dashboard

Over the years Cloud Design Box developed several workflows and processes for new employees. When making this web part, we took the core requirements made added them to an easy-to-use interface.

Parent evening booking SharePoint App

A clean dashboard shows instantly the onboarding status and progress of each employee. Each task list assigned to individual departments can be viewed in more detail.

Parent evening booking SharePoint App

The HR department have full control over the lists so they can check the current status and chase up any outstanding tasks. Departments are alerted by email when a new employee joins and have access to update their own task list. The app is mobile friendly and can be used on any device.

KPI and appraisal tracker

This dashboard was designed to make it easier and clearer for managers to track the progress of their team. Setting a KPI is easy and the employee can view their own goals and see a graphical representation of the progress made towards meeting their targets.

Parent evening booking SharePoint App

Appraisal documentation can also be attached to the employee making appraisal meetings easy to track.
It’s been really exciting developing these new apps and dashboards. Our enthusiastic customers have helped define the core functions and we look forward to developing these further as time goes on.

Other Apps

Our other apps include:

  • PO Tracker
  • Timesheets

And can be found on the Cloud Design Box website

For more information or to arrange a demonstration please drop me an email or give me a call.

Thanks,
Tony

Integrating Google Calendar Data with SharePoint using Microsoft Flow

It can be time consuming to update multiple calendars. You can now setup custom flows using Microsoft Flow to copy and edit data between the two calendars.

Google Calendar to SharePoint

In the example below, I create a Microsoft Flow to detect when a new Google Calendar item is added and then create a new item in a SharePoint calendar.

First of all, open Microsoft Flow.

Microsoft Flow

Select “Create from blank” to open the flow editor

Search for the correct trigger by typing “Google” into the search box. You should see “Google Calendar – When an event is added to a calendar”. We will use this trigger to detect when a new item is added to the Google calendar.

Google Calendar trigger

When prompted, sign into your Google account and allow access to the calendar.

We are now going to add another step to the flow to add the items into our SharePoint calendar. Click “New Step” and then Add an action.

New flow step

Search for “SharePoint – Create item”, add the URL and list name. This should load up all the calendar new item fields.

Click in each field and select the output from the previous step (the google calendar data). You may wish to populate the Title, Start Time, End Time, Location and Description.

New SharePoint calendar item

Select “Create flow” when you are ready to publish the new task. It can take a few seconds for the task to run once the Google calendar item has been added. You can check the progress and status of the task from the Flow site.

There are other things to consider when setting this up such as all day events, recurrence, editing items and deleting items. However, you should be able to extend the logic in the flow to handle these data types. Below is a video guide going through the process.



Creating a simple Microsoft Flow for a SharePoint list

For anyone using the new style SharePoint lists, there is now a new action for Microsoft Flow integration. It’s a really cool product that integrates all the Office 365 products (and more) into your workflow.

SharePoint Designer workflows still have their place but the Microsoft Flow interface offers rich functionality and is easy to view and structure workflows.

One downside to using Microsoft Flow is the error messages. They come back as error messages from the REST API as headers which can be very confusing for non-technical users. SharePoint Designer errors were much clearer and easy to understand for general users.

In the video below, I go through quickly creating a Microsoft Flow from a new style SharePoint list in an Office 365 group site.