Calendar Creator Free List Template – Add A Simple Calendar To An Office 365 2013 Public Site

Share events and schedules with the world! This free list template will let you add a list and simple calendar web part to Sharepoint Online 2013 public web sites. See an example here »
Download here »

Compatibility And Limitations
The calendar will display current month view, links to previous and next months and any corresponding events in ANY O365 tenant public site.
The event items cannot be opened by anonymous viewers due to restrictions MSFT has imposed on public sites. However a tool tip will display event date and title when event is moused over.
Enterprise level tenants can enhance the calendar and make event details accessible by allowing anonymous access. To do that you will need to install this solution: (The solution can’t be activated in Small Business accounts).


SPO 2013 Calendar Creator.stp file | Readme.txt file
1/ Download zip file and extract
2/ Open “list template gallery” on desired site [If not in settings, use this url:]
3/ Click “upload document” and navigate to the location the .stp file was saved in.
4/ Click the “cog” icon at top right of page and “Add An App”
5/ Locate “SPO 2013 Calendar Creator” and add to your site
1/ Open your desired web site page for editing or create new
2/ Place cursor where you want calendar to appear
3/ Click the “insert” tab and the “App Part” icon
4/ Locate the SPO 2013 Calendar Creator app and click the “Add” button.
5/ If the standard list view appears, click edit web part and change it over to the “calendar” view.

6/ Save/publish the page

Public view

1/ Click the cog at top right » site contents » locate the list and open
2/ To add an event: “items” tab » new item and fill in the form.
3/ To edit event: click the title in the calendar display and click “edit item” in the ribbon.
4/ Click the “list” tab and “list settings” to reconfigure columns, views etc.

Admin interface


Sharepoint calendars are just lists formatted with a complex view so can’t provide the same functionality as an Exchange calendar. Like any SP list you can set an alert based on a limited set of conditions, such as when an event is added or changed. More sophisticated functionality like setting up reminders would require some hefty customization, using workflows and probably code.
The software includes no warranty but we’ll try to help if you post any problems at:


Visit my forum » if you have any questions. For development work, you can contact me here ». And if you think this would be useful to others, feel free to share it by clicking one of the share buttons up top!

Display a sub site list on a parent site in Sharepoint Online 2010 and 2013

If you want to show a list belonging to one site on another site (in the same site collection), you can use a list template. BUT if you want the list to dynamically reflect changes made in either site on both sites, here’s how:

Insert the sub site list on a sub site page
In Sharepoint Designer, open the page and select the list
From the ribbon “save to gallery”
Choose the option to show items from THIS list (not a list relative to the site the web part is inserted on).

Go to parent site and insert that web part on a page.
This works for an Enterprise account.

In Sharepoint Online 2013, this still works, but Microsoft in their own inimitable way has made it a bit harder and less obvious.
Using Sharepoint Designer 2013, it’s not apparent how to “save (a web part) to gallery”. The trick is to open a page with the list view on it in SPD, click anywhere in the list view web part, right click and select “tag properties”. Click “OK” and the web part tools will show in the ribbon.
From there you click “save to gallery” and the option about showing “list data from the current web site or from the same list relative to the site it’s inserted on” will appear. Opt for “list data from the current web site”, save the web part and insert it (from the “miscellaneous” group) on the other site…

Open links in a new window in Sharepoint Online lists / libraries

?If you want your links in an SP list to open up in a new window, you can change the behavior with this simple update to the list view’s xsl code. All that’s needed is to add “target=”_blank” to the line in the xsl that creates the link. I’m using a “links” list here but this works for any list with links in it.Assuming you already have a list added to a page, open that page in Sharepoint Designer 2010 in advanced mode. Select SPLIT view.The links in the list will display in the “design” view at bottom.
Click a link and you’ll see the corresponding bit of xsl highlighted in the code portion of your screen.
It will look like this:

a href=”{$url}”>
Add target=”_blank” so it looks like this:
/a> , a href=”{$url}” target=”_blank”>
Since the xsl loops through your list, every link will get updated when the page is rendered in a browser. So save the page and test it out.
NOTE: if you’re not able to find the line referenced above and don’t see 1700+ lines of code for the web part, try this:
Click the top of web part in design view where it says “webpartpages:xsltlistviewebpart”
In the ribbon click design under list view tools
Click customize xslt and then select “entire view”.
Then try to locate the code for the links in the list.

Publish Form Submissions On An Office 365 Sharepoint Online 2010/2013 Public Site

In our article: “Create a custom form on your public site ” we covered how to get a Google Docs form onto your O365 site to collect data. If you’re looking to publish visitor comments, feedback or any other data submitted through the form back to the site, here’s how:
Since Google stores submitted data in a spreadsheet, what you need to do is simply embed that spreadsheet on your page.

Open the spreadsheet version of the form in Google Docs.
Click the”Share” button up top and select “Publish as a web page”.
Click the”start publishing button”.
Copy the url that opens in the box.
Enter this code in an html module:

Adjust the url, height and width as necessary.

Click here to see a working example.

A note on spam

We’ve never had much of a problem with Google forms, but if you start getting spurious submissions, you can add a validation field to filter out non human submissions (in Google Docs, go to ‘Data / Validate’). If you still get spam, the best defense is to change the url your form is under so the spammers submit to a url that doesn’t exist.
To do that, save your iframe code in notepad as an .aspx file, upload it to documents and iframe that document on your page instead of the Google code. If you periodically change the file name and reupload it you will foil the spam bots who can only post to a url-which of course you’ve changed.