How to Build an Approval Workflow Application with Caspio

This course will teach you how to create a database driven web application that incorporates approval workflows.

Created byNed Pajic

Last updated 4/2018

English

English [Auto],

What you'll learn

You'll have a greater understanding of database tables, relationships, and how to develop forms and reports without coding.

Course content

1 section • 5 lectures • 1h 36m total length

Introduction - Application Overview10:22
Explore how to build an approval workflow application with Caspio, including login, database tables, views, and workflow with new, pending review, submitted for approval, approved, and declined states.
How to Create Database Tables and Relationships Using Primary and Foreign Keys23:09
Design and link four Caspio tables—customer, employee, service requests, and status lookup—using primary keys and foreign keys to enforce one-to-many relationships and data integrity.
How to Create Views and User Level Authentications (Logins)9:55
Create views to filter active managers and active employees, and set up login screens for customers, approving managers, and service reps.
How to Create All the Necessary Forms and Reports41:58
Build and secure all forms and reports for a service request workflow in Caspio, including data pages, login redirects, submission forms, and manager and service rep reports.
How to Publish the Entire Application to a Website11:27
Deploy your Caspio-based approval workflow by embedding eight data pages and login screens into a website, using copy-paste embed codes, authentication redirects, and logo links.

Requirements

No technical background necessary.

Description

This course is meant for non-developers who are interested in learning how to create database-driven web applications. There is no coding involved, so you do not need to have prior software programming knowledge or experience. This course is great for anyone with some technical acumen who wants to learn how to build applications which contain data capture forms, reports and workflows. When you're done with this course you'll have a better understanding of how Database tables function, and how you can build your own web application without writing any code! Building applications with Caspio is a breeze; so much so, that most applications, regardless of their size, can be built within an hour. This service request application that we built for this course, with detailed explanations in each of the lectures, took literally 90 minutes to build. Once you get a good grasp on how the platform works, you'll be able to build this exact application in 20 minutes or less. Good luck and have fun with the build.

Who this course is for:

Anyone interested in learning how to build an application with Caspio.