Configuration Tutorial - Order Deliveries

Hi :wave:

Today, I would like to share with you how to configure a order deliveries module in INISTATE.
The order deliveries module allows you to optimize delivery logistics, track orders status, and improve customer satisfaction with efficient delivery management.

Problem
Inefficient Order Tracking - Manual methods, such as spreadsheets and email communication, to update and monitor order progress. This inefficient process leads to delays in order fulfillment, increases the risk of errors, and hampers ability to provide accurate order updates to customers.

Objective
Efficient - allowing you to optimize delivery logistics, track orders status, and improve customer satisfaction efficiently.

Step and configuration

  1. Access Your workspace builder

  2. In builder, create 2 modules by click “+ New” locate at the top right.

  3. Set a name and emoji for your modules. eg : Order Deliveries and Customers.

Add Information

Module : Customers

  1. Select module Customer

  2. Go to Information section

  3. Click “+ New”

  4. Add information as below :

  • Email - Email

  • Customer Name - Text

  • Phone - Phone Number

  • Address - Location

  • Related Orders - Table
    *Document ID - Module (Inspections)
    *Delivery Image - Image
    *OrderID - Text
    *Status - Text
    *DateTime - Date Time

    Screenshot 2023-08-02 125948
    Screenshot 2023-08-02 125956

Module : Order Deliveries

  1. Select Module Order Deliveries

  2. Go to information Section

  3. Click “+ New”

  4. Add information as below :

  • Customer Name - Module (Customer), Display information ( Customer Name)

  • Details - Text

  • Order ID - Text

  • Customer Email - Email

  • Customer Phone - Phone Number

  • Customer Address - Location

  • Delivery Date/Time - Date Time

  • Delivery Photo - Image

  • Status - Select
    *Ordered
    *Shipped
    *Delivered

    Screenshot 2023-08-02 142342
    Screenshot 2023-08-02 142437

Activity

  1. Select Module Order Deliveries

  2. Under Section Activity

  3. Click “+ New”

  4. Set Activity name :
    *MARK AS SHIPPED
    *MARK AS DELIVERED

State

  1. Select module Order Deliveries.

  2. Under section workflow

  3. Click “+ New” and “+ State”

  4. Set State name, color :
    *Ordered
    *Shipped
    *Delivered

Flow

  1. Select Module Order Deliveries

  2. Under section workflow

  3. Click “+ New” and “+ Flow”

  4. Create 2 Flow :

  • From state : Ordered → Activity : MARK AS SHIPPED → To state : Shipped

  • From State : Any state → Activity : MARK AS DELIVERED → Enable “Conditional” → 1. State : Ordered Formula : #Entry#Status == “Ordered”, 2. State : Shipped Formula : #Entry#Status == “Shipped”, 3. State : Delivered Formula : #Entry#Status == “Delivered”.

Listing

  1. Select Module Order Deliveries

  2. Under section Listing

  3. Click “+ New”

  4. Set a name ,emoji, list design and filter condition. :

Form Design and Formula

  1. Select Module Order Deliveries

  2. Under activity section

  3. Click Basic

  4. Choose Create

  5. Drag and drop information added as below :
    *Customer Name - Module
    *Details - Text
    *Order ID - Text, enable field visibility
    *Delivery Date/Time - Date Time, enable field visibility, formula : DateTime.Now
    *Customer Email - Email, enable field visibility, formula : #Form#CustomerName#Email
    *Customer Address - “Location”, enable field visibility, formula : #Form#CustomerName#Address
    *Customer Phone - *Phone Number, enable field visibility, formula - #Form#CustomerName#Phone


  6. Click “Design” under Activity Section.

  7. Click activity, MARK AS SHIPPED

  8. Click orange “+” icon to add form

  9. Drag and drop information as below :
    *Delivery Date/Time - Date Time, set formula : DateTime.Now

  10. Click activity, MARK AS DELIVERED.

  11. Click orange “+” icon to add form.

  12. Drag and drop information as below. :
    *Order ID - Text
    *Customer address - Location
    *Status - Select
    *Delivery Photo - Image, Set formula on visibility column : #Form#Status == “Delivered”
    *Delivery Date/Time - Date Time, set formula : DateTime.Now

Automation (Make sure to connect every block)

Condition - To pass information from Module Order Deliveries to Table Related Orders In Module Customer based on customer name

  1. Select Module Order Deliveries

  2. Go to Activity Section.

  3. Click Basic

  4. Add new automation by click the “:zap: new automation”.

  5. Click “Do After”

  6. Drag Action block

  7. Add action, Find
    *Module : Customer
    *Filter : Customer Name is #Entry#CustomerName#CustomerName

  8. Drag Condition block

  9. Set condition : #CustomerFound

  10. Drag Action Block

  11. Add Action, Form
    *Module : Customer
    *Activity : Edit
    *Entry : #CustomerFound

  12. Drag Action Block

  13. Add Action, Create

  14. Set Value : AddRow(#CustomerEditFrom#RelatedOrders)

  15. Drag Action Block

  16. Add Action, Set

  17. Set Variable and Value
    *Variable : #Variable1
    *Expand Value
    *DocumentId - #Entry
    *OrderID - #Entry#OrderID
    *Status - #Entry#State
    *Date Time - #Entry#DeliveryDate/Time

  18. Drag Action Block

  19. Add Action, Perform

  20. Set Module, Activity, Entry and Form
    *Module : Customer
    *Activity : Edit
    *Entry : #CustomerFound
    *Form : #customerEditForm

Condition - To update new Date and State from "Delivery Date/Time in activity MARK AS SHIPPED to the “Date Time” and “Status” in Table “Related Orders” in Module Customer after activity executed

  1. Select Module Order Deliveries

  2. Under section Activity

  3. Click Design

  4. Create new Automation in Activity MARK AS SHIPPED

  5. Click “Do After”

  6. Drag Action Block

  7. Add Action, Find

  8. Set Module and Filter :
    *Module - Customer
    *Filter - Customer Name is #Entry#CustomerName#CustomerName.

  9. Drag Condition block.

  10. Set Value : #CustomerFound

  11. Drag Action block

  12. Add Action, Form

  13. Set Module, Activity and Entry :
    *Module : Customer
    *Activity : Edit
    *Entry : #CustomerFound

  14. Drag Condition block

  15. Set Value : #CustomerEditForm#RelatedOrders.Count>0

  16. Drag Action block

  17. Add Action, Create

  18. Set Variable Name(Optional) and Value :
    *Name - line
    *Value - find(#CustomerEditForm#RelatedOrders#DocumentID == #Entry)

  19. Drag Condition Block

  20. Set Value : #line

  21. Drag Action block

  22. Add Action, Set

  23. Set Variable and Value :
    *Variable - #line
    *Expand Property :
    *Status - #EntryState
    *Date Time - #Entry#DeliveryDate/Time

  24. Drag Action block

  25. Add Action, Perform

  26. Set Module, Activity, Entry and Form:
    *Module : Customer
    *Activity : Edit
    *Entry : #CustomerFound
    *Form : #CustomerEditForm

Condition - To update Delivery image, State, and Delivery Date/Time from Activity MARK AS DELIVERED to the Delivery Image, Status and Date Time in “Related Orders” Tables in module Customer.

  1. Select Module Order Deliveries

  2. Under Section Activity

  3. Click Design

  4. Add new automation for Activity MARK AS DELIVERED

  5. Click “Do After”

  6. Drag Action Block

  7. Add Action, Find

  8. Module and Filter :
    *Module : Customer
    *Filter : Customer Name is #Entry#CustomerName#CustomerName

  9. Drag Condition block

  10. Set Value : #CustomerFound

  11. Drag Action block

  12. Add new action, Form

  13. Set Module, Activity and Entry :
    *Module : Customer
    *Activity : Edit
    *Entry : #CustomerFound

  14. Drag condition block

  15. Set Value : #CustomerEditForm#RelatedOrders.Count>0

  16. Drag Action block

  17. Add Action, Create

  18. Set Variable name (optional) and value :
    *Variable name : line
    *Value : #find(#CustomerEditForm#RelatedOrders#DocumentID == #Entry)

  19. Drag condition block

  20. Set value : #line

  21. Drag Action block.

  22. Add Action, Set

  23. Set Variable and Value :
    *Variable : #line
    *Value : Expand property
    *Delivery image : #Entry#DeliveryPhoto
    *Status : #Entry#State
    *Date Time : #NOW

  24. Drag Action block

  25. Add Action, Perform

  26. Set Module, Activity, Entry and Form :
    *Module : Customer
    *Activity : Edit
    *Entry : #CustomerFound
    *Form : #CustomerEditForm

Congratulations!!!:tada::tada: You have successfully created a Order Deliveries module.

For more template and ready solution.
Try INISTATE for FREE now.
Sign up at https://inistate.com

Related topic :