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

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.

Do same things for Suppliers Form

Do same things for Products Form

Do same things for Order Form

To create a total field from detail table , choose the detail tab of detail table and choose Ξ£ symbol and choose field that you want to add sum to main form

Add a textbox to main form of Orders and choose source input element

In Expression Builder and expression that show below

Now we create a macro that return Address for Customer that choose in CustomerAutocomplete field

Add a parameter that take CustID from CustomerAutocomplete field that use to filter a query that return address details

We create 2 return vars that return address and city

All these show below in pictures

Now at actions of field CustomerAutocomplete choose after update action

Choose to run macro that previous create , add 2 locals varsΒ  to save values that return from macros and change value property for fields ShipAddress1 and ShipCity1

Now we create a macro for Order Detail form that return price and vat for product that selected with the same manner that created Customer macro

Now for fields of order detail form quantity, unit price , discount from actions after update insert below action for Extended_PriceTextBox

You can use below simple user action in Galaxy to insert Orders in Galaxy

Insert Sales

This is a simple ordering sales system that you can use with SharePoint 2013 , Access Web Database and Galaxy

Some suggestions for improvement can according when chooseΒ  the customer in the order create a temporary table with all address of customer and choose one of them in the order, you can transfer your trade policies and many other additions to make your ordering even more functional.

Happy code , stay tuned and more coming…!