Mendix : Low-code Application Development Course

Create a products page by copying the customer page, renaming it, and updating the header and description, then configure on-click navigation from the home page to the products page.

Add a location page by duplicating the products page structure, rename it, customize its header and description, and wire buttons to the location page before saving.

Create a salesperson page by duplicating the products page, renaming it, and updating its title and description to manage salespersons, with a datagrid to be configured next.

Create a sales tracking page by duplicating and renaming the sales person page, configure add, delete, and update for sales records with data grids, and assign page icons.

Create domain model entities, data sources, and data grids by modeling tables, fields, and relationships, then deploy to SQL Server with Mendix auto-creating the database and keys.

Create a customers entity in domain model, add first name, last name, birth date, email, phone, yearly income, and average order quantity, and define marital status and gender as enumerations.

Create a product entity: product name, color (yellow, black, red, green, orange), safety stock level, list price, size (big, medium, small, extra small), weight, model name, and status (active, disabled).

Create a locations entity in Mendix by adding fields like state, city, country, longitude, latitude, and postal code, then check system members before the next salesperson table lesson.

Create a salesperson entity in Mendix domain model, adding attributes like name, lastname, title, hire date, birth date, marital status, gender, monthly salary, and status, then prepare sales tracking relationships.

Create a sales tracking entity in Mendix, defining attributes such as order quantity, unit price, discount amount, product standard cost, tax amount, and order date, forming five tables.

Discover how table relationships and entity relationships work in Mendix, including normalization, dimension tables, and one-to-many links using store and product keys in sales fact tables.

Create relationships between entities in Mendix by linking customer, product, location, and salesperson keys to sales tracking fact table, establishing one-to-many relationships. Use on delete events to keep tables aligned.

Resolve errors by configuring data grid data sources to database entities across customers, locations, products, salesperson, and sales tracking; automatically populate attributes and save changes.

Generate create and edit pages for data grid entries in Mendix, add input fields like first name and birth date, and use enumeration and reference selectors to manage related data.

Learn to build responsive page navigation in Mendix by configuring layout types, adding nav bar items, and wiring on click events to switch between home and key pages.

Demonstrates adding customer data in a Mendix low-code app by running the project and creating records on the customers page using first name, last name, birth date, and contact details.

Add product data to Mendix products entity by creating new records with name, color, safety stock level, list price, size, weight, style, model name, and status, then save and repeat.

Add location details to the locations entity by clicking new on the locations page and filling city, longitude, latitude, and postal code, then save.

Add salespersons to the salesperson entity in a Mendix low-code app by entering name, title, hire date, birth date, marital status, gender, monthly salary, and status, then save.

Create sales orders from the web system by populating fields like quantity, price, discount, and cost, and display related customer, location, product, and salesperson data via associations.

Create and configure the mobile portion of a mendix low-code sales app by building a mobile home page, setting up navigation, and framing pages for customers, salespersons, and sales orders.

Create customers and products pages, remove the salesperson page, and set up list views with data sources and onClick actions, then run locally to verify the mobile design.

Learn to convert inline html elements to block elements using the paragraph render mode in Mendix to display data vertically on the customers and products pages.

Improve the customer page UI in Mendix by turning fields into block containers, adding prefixes, and applying CSS to bold labels. Extend the same design to the products page.

Create a vertical products mobile page by turning fields into text elements, adding containers for name, color, size, and model name, and applying bold font and color CSS.

Learn to update customer data in Mendix by using data view and clickable list view cells to pass a row object to a customer edit page and save changes.

Add an edit page to the products mobile page, configure onClick events to navigate, pass row objects as data, and save or back actions to update the product in Mendix.

Create a sales order draft entity using a temporary draft table that mirrors the sales tracking table, then copy drafts to the sales tracking table.

Create a draft sales order page using a one-row data view bound to the temporary sales tracking table, with a macro flow to create and save the draft.

In Mendix, adjust sales order draft user interface by aligning add draft sales order button to the right, and listing sales id, customer name, and product name vertically with margins.

Create and manage variables in Mendix micro flows, selecting data types from string to date and time, then pass values to show message and test the micro flow.

Use the change variable action in Mendix’s low-code environment to update a date variable to today, then run the microflow to verify the new value.

Discover how to use if statements in Mendix by creating integer and string variables, branching into true and false paths, and displaying messages.

Learn to debug Mendix code by setting breakpoints, running the project, and using the debugger to inspect variables like current user and string values while stepping through a microflow.

Observe the database by running the project locally, using the built-in viewer to execute sql on products and sales persons, then add a new sales person and verify.

Learn how to use the retrieve action in Mendix microflows to fetch data from a database table, returning a collection or a single object.

Explore loops in Mendix to iterate over sales tracking table objects, access their properties like sales id, and display messages with debugging and sorting tips.

Create an object in Mendix with a new microflow for the products entity and attributes like color, size, and status. Commit to the database and refresh the client.

Retrieve a product object from the products table, change its name to product 99, commit updates to the database, and refresh the client to reflect changes.

Learn to delete the first product from the database in Mendix by creating a microflow that retrieves a product and deletes it, with optional real-time refresh on the client.

Learn how to pass parameters to macro flows in Mendix, sum two integers, return the result, and explore nested macro flows with a main microflow and test macro flow debugging.

Learn to use merge components in Mendix microflows to merge paths, create counters, and control loops with if statements, showing messages and debugging in the Mendix studio.

Learn how to implement break and continue logic in Mendix microflows, iterating over a products list, applying conditions, and debugging with breakpoints and messages.

Learn to use change list, create list, and add, remove, and replace objects in a microflow to build an in-memory product list and power a data grid.

Learn to use the aggregate list action in Mendix to retrieve the customers entity, apply aggregate functions like sum, average, count, minimum, and maximum, and test in a macro flow.

Master Mendix list operations, including union, intersect, subtract, equals, and contains, with sorting and filtering examples. Retrieve products, apply filters, and use head, tail, and find in microflows.

Send draft sales orders to the real sales tracking table using a microflow in the Mendix low-code course, creating real orders and clearing drafts.

Learn how to use XPath string functions to filter data grids in Mendix by salesperson name. Explore contains, starts with, ends with, and length-based constraints with practical examples.

Learn XPath date time functions to extract day, month, week, weekday, hours, minutes, seconds, and quarters from date time attributes and use boolean expressions to filter data sources.

Learn to use XPath as a data source in Mendix, applying string and datetime filters to a data grid on the sales tracking page.

Explore xpath and system variables in Mendix to filter data using end of current month, begin of current month, and begin of current year expressions.

Configure Mendix security system and user roles to control data, page, and micro flow access. Create demo users, assign roles, and define entity and page permissions.

Define a new sales role and grant module, page, and microflow permissions, then use an xpath constraint to show only data created by the current user.

Apply page level security by configuring the security section, selecting demo users, and granting or revoking access to specific pages like the invisible products page for Kate the salesperson.

Apply microflow level security by removing the comet sales orders micro flow permission from the salesperson role, then verify access by testing with Kate (no button) and Bill (button visible).

Apply entity level security in Mendix by configuring access rules tied to user roles and city-based filtering via associations on the sales tracking page.

Apply conditional visibility based on user roles in Mendix, hiding or showing elements like data grids and buttons, demonstrated with Kate the salesperson and the sales tracking page.

Use attribute based visibility in mendix to conditionally show or hide the phone number field by enumeration value, with a hands-on test workflow.

Learn to implement expression-based visibility in Mendix by using the current object to access attributes, compare values (like average yearly income or gender), and conditionally reveal fields in the UI.

Explore Mendix domain models, defining entities, attributes, and associations across modules. Learn validation rules, event handlers, microflows, and indexes to ensure data integrity and cross-module connections.

Apply validation rules in a Mendix low-code app to enforce order quantity greater than zero in the sales tracking table, preventing saving invalid orders.

Apply event handlers in the Mendix domain model to track deleted sales orders by recording a history entry with sales ID and order quantity before deletion.

Learn to create a calculated column that counts sales orders using a macro flow and aggregate list, displayed via a data view on a Mendix mobile page.

Explore calculated columns with passing entity feature in Mendix by computing total revenue (order quantity × unit price) via a microflow and displaying it in the sales tracking grid.

Delete list view items on the sales order draft page by adding a danger-styled delete button that calls a microflow, then adjust the interface with css for better alignment.

Install the community commons package in your Mendix project by downloading it from the Mendix App Store, importing the module, and using Java actions in microflows.

Learn to convert date time to long in Mendix using Java actions within a micro flow, displaying the seconds value from a sales tracking table.

Use the months between Java action in a microflow to compute the number of months between the first sales order date and today, then show the result.

Generate a random hash as an operation code for batch sales orders in Mendix using a Java action, and track each draft in the sales tracking table.

Learn to split a string in Mendix using a Java actions approach, applying a delimiter and iterating results within a microflow that retrieves and sorts data.