Challenge Overview
Requirements
Extend the previous project to build on MS Office 365. Use the dep injection model shown in the doc provided to allow you to build menus, etc. You should be able to read and write into the document, build a menu, show a modal and show a sidebar. The code for previous application resides on our Gitlab repo - https://gitlab.com/jdrew/financialforce_gas_o365_poc/tree/feature/office365 - please post in the forums if you need access.
NOTE You should be able to install this application in either Google Sheets App Script or On MS Office 365 Excel without modification. It should be a single codebase. If you are unable to do this please document all issues encountered and this will be considered in place of a code submission (You should try to build as much of the app as possible and include that with your submission).
Resources
-
How to create Excel Apps for Office 365 : The original POC part 1 was based on the GAS version of this tutorial. In this one he attempts to recreate the same plugin for MS Office 365 Excel. Note that the tutorial is 2 years old and the API has evolved since then. A lot of the issues he encountered have since been fixed. Use it for reference only.
-
Loading an angular service depending on environment: environment_aware_dep_injection_with_angular.pdf
-
MS Office 365 Github Repo : Should contain api docs and client libraries, as well as demo apps.
Repo/Housekeeping
- You will need to base your work off the git repository provided.
- You will be required to handle any merge issues that occur from your submission.
Coding Standards
- Use Angular 1.5.
- Do not make use of jquery for DOM manipulation.
- All UI must utilise the Salesforce Lightning Design System style.
- All code should be fully unit tested and documented. Please use best practise here (you do not need to document getters and setters, etc)!
- All existing tests should be fully maintained (ie if you make a change to the existing functionality that breaks a test you need to fix that).
Final Submission Guidelines
- Please provide a detailed deployment guide in Word format with screenshots - walking through all the installation and verification
- Provide a demo video walking through the installation and verification (MUST show both Google Apps & Office 365 flows fully working)
- Provide all your source code as a zip
It is an absolute must to provide a detailed deployment guide & video covering installation and verification. Any submissions which do not provide these will be rejected without being reviewed.