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

Posted on by

In the previous article we saw how to connect to a database access with Sharepoint and shape the tables needed to implement the ordering.

In this article we will see how to create the forms and macros will introduce them to various processes

We start with Customers Form

To add a Details table to the main table picking out the ribbon tools the Related Items Control and choose plus symbol and choose detail table that you want to show.

To add extra fields choose textbox and label controls and connect fields from table you want.

Customers

Do same things for Suppliers Form

Suppliers

Continue reading →

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

Posted on by

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

Continue reading →