DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Please enter at least three characters to search
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Last call! Secure your stack and shape the future! Help dev teams across the globe navigate their software supply chain security challenges.

Modernize your data layer. Learn how to design cloud-native database architectures to meet the evolving demands of AI and GenAI workloads.

Releasing software shouldn't be stressful or risky. Learn how to leverage progressive delivery techniques to ensure safer deployments.

Avoid machine learning mistakes and boost model performance! Discover key ML patterns, anti-patterns, data strategies, and more.

Related

  • Generative AI Models: Boosting Merchandising Analytics User Experience
  • Mobile App Development Trends and Best Practices
  • Everything You Should Know About APIs
  • How to Practically Implement Microservices Infrastructure in Your Business

Trending

  • The Role of Functional Programming in Modern Software Development
  • Apache Doris vs Elasticsearch: An In-Depth Comparative Analysis
  • Customer 360: Fraud Detection in Fintech With PySpark and ML
  • My LLM Journey as a Software Engineer Exploring a New Domain
  1. DZone
  2. Data Engineering
  3. Data
  4. How To Create a Crud App in OutSystems — A Low Code Development Platform

How To Create a Crud App in OutSystems — A Low Code Development Platform

Using the step-by-step instructions outlined in this article, the reader will learn how to create a CRUD application in OutSystems.

By 
Amritendu De user avatar
Amritendu De
·
Jun. 29, 23 · Tutorial
Likes (1)
Comment
Save
Tweet
Share
4.2K Views

Join the DZone community and get the full member experience.

Join For Free

OutSystems is a low-code development platform that allows you to build web and mobile applications rapidly. In this example, we'll create a simple employee management CRUD system. It took me around eight hours to get started with the platform and build my first CRUD app. 

Let's get started!

Register Yourself

  • Launch 
  • Create a new login.
  • Download OutSystems Service Studio.
  • You will be given a playground as TrialPortal for development. 

Create a New Application

  • Launch OutSystems Service Studio.
  • Create a new Reactive Web Application.
  • Provide a name for your application, e.g., "EmployeeManagementSystem."
  • Choose a theme and click "Create."
  • Click on "Create Module"

Create Entities

  • In the "Logic" tab, go to the "Data" section.
  • Right-click on "Entities" and create an "Employee" table
  • The fields I have used are ID (Auto increment), Name, and Email

Create Server Actions

Create a Server Action for Creating an Employee

  • Right-click on "Server Actions" and choose "Add Server Action."
  • Name it "AddEmployee" and input parameters "Name" and "Email"
  • Use the SQL widget to add an Employee instance with the SQL: INSERT into {Employee} VALUES (@Name, @Email)

Create a Server Action for Updating an Employee

  • Right-click on "Server Actions" and choose "Add Server Action."
  • Name it "EditEmployee" and input parameters "ID," "Name," "Email"
  • Use the SQL widget to edit an Employee instance with the SQL: UPDATE {Employee} set Name = @Name, Email = @Email where Id = @Id

Create a Server Action for Deleting an Employee

  • Right-click on "Server Actions" and choose "Add Server Action."
  • Name it "DeleteEmployee" and input parameters "ID" only
  • Use the SQL widget to delete an Employee instance with the SQL:DELETE from {Employee} where @Id = @Id

Design the User Interface

The UI we are trying to build will look like below:

Design the User InterfaceDesign the List Employees Screen

Design the List Employees Screen

  • Use the "Tables" widget to list the Employee table
  • Introduce Edit, Delete, and Add buttons
  • Use the "anonymous" option to avoid the login screen

Implement Screen Logic

Implement the Button Actions

  • "Add" button:
  • On click event of the "Add" button should open the "AddEmployee" screen
  • On entering the name and email of the employee, the client action "AddEmployee" is called, which in turn calls the server action
  • In the client action screen, redirect to the "EmployeeDetails" screen after a new record is created.
  • "Edit" button:
  • On click event of the "Edit" button should open the "EditEmployee" screen
  • On updating the name and email of the employee, the client action "EditEmployee" is called, which in turn calls the server action
  • In the client action screen, redirect to the "EmployeeDetails" screen after a new record is updated.
  • "Delete" button:
  • On click event of the "Delete" button, the client action "DeleteEmployee" is called, which in turn calls the server action
  • In the client action screen, the refresh data widget is called on the "EmployeeDetails" screen after the record is deleted.

Publish and Test

  • Save your changes and publish the application to generate the web app.
  • Run the application and test the CRUD operations by adding, updating, and deleting employees.

That's it! You have created a basic CRUD application in OutSystems using a simple employee management system as an example. Remember to customize and enhance the application as per your requirements.

Screenshots

Data

Data

Server Actions

Server Actions

Interfaces

Interfaces

Web application Data (computing) mobile app Software development

Opinions expressed by DZone contributors are their own.

Related

  • Generative AI Models: Boosting Merchandising Analytics User Experience
  • Mobile App Development Trends and Best Practices
  • Everything You Should Know About APIs
  • How to Practically Implement Microservices Infrastructure in Your Business

Partner Resources

×

Comments
Oops! Something Went Wrong

The likes didn't load as expected. Please refresh the page and try again.

ABOUT US

  • About DZone
  • Support and feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends:

Likes
There are no likes...yet! 👀
Be the first to like this post!
It looks like you're not logged in.
Sign in to see who liked this post!