Simple Order System with Office 365 SharePoint and Galaxy – Part 1

In this blog post we make a simple order system for oursΒ sellers that work in any device (desktop and mobile) and operating system (android, iOS,Windows mobile and desktop) with web browser step by step with Office 365 SharePoint and SingularLogic Galaxy.

Prerequisites are Office 365 SharePoint 2013 , Install Access web app from Office365 Store in SharePoint site , SingularLogic Galaxy and Office 365 Pro

First you must made export actions from SingularLogic GalaxyΒ  to Access Web app , you can use User Actions or dll Entities.

Links below use user actions inside SingularLogic Galaxy , are very simple and must use your imagination to make them better….

Don’t forget to change Sql Server connections strings in code with that you receive from yours access web app that you see below, and guid for Fiscal Year in sql statements.

Export Customers

Export items

Export Suppliers

Export Transactions

From your SharePoint site select to add new appΒ Β Β Β Β Β 

After that select Access AppΒ Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β 

Give a name to your Access application

After that open access web application in Access 2013

Select File / Info / ConnectionsΒ Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β 

Select to Enable Read-Write Connection and From Any Location options

Select View Read-Write Connection Information and write connection Information for yours access web app

Select Home / Table and search for Orders template and select it

 

Modify Customers to according to export fields from Galaxy

Beside calculated fields see calculation

Modify Suppliers to according to export fields from Galaxy

Beside calculated fields see calculation

Modify Products to according to export fields from Galaxy

Beside calculated fields see calculation

 

Modify Orders that show in picture

Modify Order Details that show in picture

Beside calculated fields see calculation

Modify TransCust to according to export fields from Galaxy

Beside calculated fields see calculation

This is the end of 1st part ofΒ  Simple Order System with Office 365 SharePoint and SingularLogic Galaxy.

In the next part we will see how you can modify access web forms and insert macros for calculations in ours order system

Stay tuned !