{"id":3010,"date":"2024-06-10T08:00:36","date_gmt":"2024-06-10T00:00:36","guid":{"rendered":"https:\/\/five.co\/?p=3010"},"modified":"2024-06-28T12:02:23","modified_gmt":"2024-06-28T04:02:23","slug":"how-to-build-a-cloud-application","status":"publish","type":"post","link":"https:\/\/preview-php85.dzine.org\/five\/blog\/how-to-build-a-cloud-application\/","title":{"rendered":"How to Build a Cloud Application [Full Tutorial]"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hi and welcome to our step-by-step guide on building your first cloud web application with Five.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Goals and Objectives: Build a Cloud Application<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In this step-by-step tutorial, we&#8217;ll build a cloud application in just 30 minutes. We will:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 1: Develop a Responsive Cloud-Native Application<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set up an online MySQL database.<\/li>\n\n\n\n<li>Create tables with a many-to-many relationship.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 2: Create a Data Visualization Chart<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Write an SQL query to fetch data.<\/li>\n\n\n\n<li>Use a chart wizard to visualize this data in the cloud.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3: Validate Data Inputs<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Implement custom display types.<\/li>\n\n\n\n<li>Use regular expressions to ensure data integrity.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 4: Integrate with Slack<\/strong> <strong>(Optional)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set up a Slack webhook.<\/li>\n\n\n\n<li>Configure the app to send notifications to Slack.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 5: Add PDF Reporting (Optional)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a report template.<\/li>\n\n\n\n<li>Include data from the SQL database in the PDF report for easy access<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Plus using Five you can also build so much more.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sounds like a lot? <strong>You&#8217;ll be surprised how quickly we can build a simple cloud application in Five! <\/strong>Before we continue, <a href=\"https:\/\/preview-php85.dzine.org\/five\/get-started\/\">make sure to sign up for free access to the Five development environment<\/a> to start building your cloud application today.<\/p>\n\n\n\n<div style=\"background-color: #001524;\"><hr style=\"height: 5px;\">\n<pre style=\"text-align: center; overflow: hidden; white-space: pre-line;\"><span style=\"color: #f1ebda; background-color: #4588d8; font-size: calc(18px + 0.390625vw);\"><strong>Get Free Access to Five<br><\/strong><span style=\"font-size: 14pt;\">Rapidly Build &amp; Deploy Cloud Web Applications<\/span><\/span><\/pre>\n<p style=\"text-align: center;\"><a href=\"https:\/\/preview-php85.dzine.org\/five\/get-started\/\" target=\"_blank\" rel=\"noopener\"><button style=\"background-color: #f8b92b; border: none; color: black; padding: 20px; text-align: center; text-decoration: none; display: inline-block; font-size: 18px; cursor: pointer; margin: 4px 2px; border-radius: 5px;\"><strong>Get Instant Access<\/strong><\/button><br><\/a><\/p>\n<hr style=\"height: 5px;\"><\/div>\n\n\n<div class=\"root-eb-toc-ei7na wp-block-essential-blocks-table-of-contents\"><div class=\"eb-parent-wrapper eb-parent-eb-toc-ei7na \"><div class=\"eb-toc-container eb-toc-ei7na  eb-toc-is-not-sticky eb-toc-not-collapsible eb-toc-initially-not-collapsed eb-toc-scrollToTop style-1 list-style-none\" data-scroll-top=\"false\" data-scroll-top-icon=\"fas fa-angle-up\" data-collapsible=\"false\" data-sticky-hide-mobile=\"false\" data-sticky=\"false\" data-scroll-target=\"scroll_to_toc\" data-copy-link=\"false\" data-editor-type=\"\" data-hide-desktop=\"false\" data-hide-tab=\"false\" data-hide-mobile=\"false\" data-itemcollapsed=\"false\" data-highlight-scroll=\"false\"><div class=\"eb-toc-header\"><h2 class=\"eb-toc-title\">Table of Contents<\/h2><\/div><div class=\"eb-toc-wrapper \" data-headers=\"[{&quot;level&quot;:2,&quot;content&quot;:&quot;Goals and Objectives: Build a Cloud Application&quot;,&quot;text&quot;:&quot;Goals and Objectives: Build a Cloud Application&quot;,&quot;link&quot;:&quot;goals-and-objectives-build-a-cloud-application&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Resources and Downloads: Build a Cloud Application&quot;,&quot;text&quot;:&quot;Resources and Downloads: Build a Cloud Application&quot;,&quot;link&quot;:&quot;resources-and-downloads-build-a-cloud-application&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;CSV File&quot;,&quot;text&quot;:&quot;CSV File&quot;,&quot;link&quot;:&quot;csv-file&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;SQL Query&quot;,&quot;text&quot;:&quot;SQL Query&quot;,&quot;link&quot;:&quot;sql-query&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;JavaScript Function&quot;,&quot;text&quot;:&quot;JavaScript Function&quot;,&quot;link&quot;:&quot;javascript-function&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Theme&quot;,&quot;text&quot;:&quot;Theme&quot;,&quot;link&quot;:&quot;theme&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Report Template&quot;,&quot;text&quot;:&quot;Report Template&quot;,&quot;link&quot;:&quot;report-template&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Step-by-Step Guide: Building a Cloud Application from Scratch&quot;,&quot;text&quot;:&quot;Step-by-Step Guide: Building a Cloud Application from Scratch&quot;,&quot;link&quot;:&quot;step-by-step-guide-building-a-cloud-application-from-scratch&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 1: Creating a New Cloud Application&quot;,&quot;text&quot;:&quot;Step 1: Creating a New Cloud Application&quot;,&quot;link&quot;:&quot;step-1-creating-a-new-cloud-application&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 2: Running Your Cloud-Based Application&quot;,&quot;text&quot;:&quot;Step 2: Running Your Cloud-Based Application&quot;,&quot;link&quot;:&quot;step-2-running-your-cloud-based-application&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 3: Creating Database Tables with Table Wizard&quot;,&quot;text&quot;:&quot;Step 3: Creating Database Tables with Table Wizard&quot;,&quot;link&quot;:&quot;step-3-creating-database-tables-with-table-wizard&quot;},{&quot;level&quot;:4,&quot;content&quot;:&quot;Creating the Product Table&quot;,&quot;text&quot;:&quot;Creating the Product Table&quot;,&quot;link&quot;:&quot;creating-the-product-table&quot;},{&quot;level&quot;:4,&quot;content&quot;:&quot;Creating the Orders Table&quot;,&quot;text&quot;:&quot;Creating the Orders Table&quot;,&quot;link&quot;:&quot;creating-the-orders-table&quot;},{&quot;level&quot;:4,&quot;content&quot;:&quot;Creating the ProductOrders Table&quot;,&quot;text&quot;:&quot;Creating the ProductOrders Table&quot;,&quot;link&quot;:&quot;creating-the-productorders-table&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 4: Using the Database Modeler&quot;,&quot;text&quot;:&quot;Step 4: Using the Database Modeler&quot;,&quot;link&quot;:&quot;step-4-using-the-database-modeler&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 5: Importing Data from a CSV&quot;,&quot;text&quot;:&quot;Step 5: Importing Data from a CSV&quot;,&quot;link&quot;:&quot;step-5-importing-data-from-a-csv&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 6: Creating Forms with Form Wizard&quot;,&quot;text&quot;:&quot;Step 6: Creating Forms with Form Wizard&quot;,&quot;link&quot;:&quot;step-6-creating-forms-with-form-wizard&quot;},{&quot;level&quot;:4,&quot;content&quot;:&quot;Creating the Product and Orders Forms&quot;,&quot;text&quot;:&quot;Creating the Product and Orders Forms&quot;,&quot;link&quot;:&quot;creating-the-product-and-orders-forms&quot;},{&quot;level&quot;:4,&quot;content&quot;:&quot;Creating the ProductOrders Form&quot;,&quot;text&quot;:&quot;Creating the ProductOrders Form&quot;,&quot;link&quot;:&quot;creating-the-productorders-form&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 7: Enhancing Forms by Adding Pages&quot;,&quot;text&quot;:&quot;Step 7: Enhancing Forms by Adding Pages&quot;,&quot;link&quot;:&quot;step-7-enhancing-forms-by-adding-pages&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Second Checkpoint: Build Your Cloud Application&quot;,&quot;text&quot;:&quot;Second Checkpoint: Build Your Cloud Application&quot;,&quot;link&quot;:&quot;second-checkpoint-build-your-cloud-application&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 8: Validating Data on a Form&quot;,&quot;text&quot;:&quot;Step 8: Validating Data on a Form&quot;,&quot;link&quot;:&quot;step-8-validating-data-on-a-form&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 9: Using Five&apos;s End-User GUI&quot;,&quot;text&quot;:&quot;Step 9: Using Five&apos;s End-User GUI&quot;,&quot;link&quot;:&quot;step-9-using-fives-end-user-gui&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 10: Writing SQL Queries in Five&quot;,&quot;text&quot;:&quot;Step 10: Writing SQL Queries in Five&quot;,&quot;link&quot;:&quot;step-10-writing-sql-queries-in-five&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 11: Creating Charts For Your Cloud Application&quot;,&quot;text&quot;:&quot;Step 11: Creating Charts For Your Cloud Application&quot;,&quot;link&quot;:&quot;step-11-creating-charts-for-your-cloud-application&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 12: Visual &gt; Reports: Generating a PDF Report&quot;,&quot;text&quot;:&quot;Step 12: Visual &gt; Reports: Generating a PDF Report&quot;,&quot;link&quot;:&quot;step-12-visual-reports-generating-a-pdf-report&quot;},{&quot;level&quot;:1,&quot;content&quot;:&quot;Report&quot;,&quot;text&quot;:&quot;Report&quot;,&quot;link&quot;:&quot;report&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 13: Visual &gt; Menus: Adding Menu Items to Your App&quot;,&quot;text&quot;:&quot;Step 13: Visual &gt; Menus: Adding Menu Items to Your App&quot;,&quot;link&quot;:&quot;step-13-visual-menus-adding-menu-items-to-your-app&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Third Checkpoint: Ensuring Your App Functions Correctly&quot;,&quot;text&quot;:&quot;Third Checkpoint: Ensuring Your App Functions Correctly&quot;,&quot;link&quot;:&quot;third-checkpoint-ensuring-your-app-functions-correctly&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 14: Logic &gt; Code Editor: Creating a JavaScript Function&quot;,&quot;text&quot;:&quot;Step 14: Logic &gt; Code Editor: Creating a JavaScript Function&quot;,&quot;link&quot;:&quot;step-14-logic-code-editor-creating-a-javascript-function&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 15: Visual &gt; Forms: Associating a Function with an Event&quot;,&quot;text&quot;:&quot;Step 15: Visual &gt; Forms: Associating a Function with an Event&quot;,&quot;link&quot;:&quot;step-15-visual-forms-associating-a-function-with-an-event&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 16: Applications: Enabling Multiuser Functionality&quot;,&quot;text&quot;:&quot;Step 16: Applications: Enabling Multiuser Functionality&quot;,&quot;link&quot;:&quot;step-16-applications-enabling-multiuser-functionality&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Fourth Checkpoint: First Login&quot;,&quot;text&quot;:&quot;Fourth Checkpoint: First Login&quot;,&quot;link&quot;:&quot;fourth-checkpoint-first-login&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 17: Setup &gt; User Roles: Configuring Roles and Permissions&quot;,&quot;text&quot;:&quot;Step 17: Setup &gt; User Roles: Configuring Roles and Permissions&quot;,&quot;link&quot;:&quot;step-17-setup-user-roles-configuring-roles-and-permissions&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 18: Setup &gt; Themes: Customizing the Appearance of Your App&quot;,&quot;text&quot;:&quot;Step 18: Setup &gt; Themes: Customizing the Appearance of Your App&quot;,&quot;link&quot;:&quot;step-18-setup-themes-customizing-the-appearance-of-your-app&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Step 19: Setup &gt; Instances: Applying a Theme and Customizing the UI&quot;,&quot;text&quot;:&quot;Step 19: Setup &gt; Instances: Applying a Theme and Customizing the UI&quot;,&quot;link&quot;:&quot;step-19-setup-instances-applying-a-theme-and-customizing-the-ui&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Congratulations: You&apos;ve Built Your Cloud Web Application&quot;,&quot;text&quot;:&quot;Congratulations: You&apos;ve Built Your Cloud Web Application&quot;,&quot;link&quot;:&quot;congratulations-youve-built-your-cloud-web-application&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Exploring User Roles&quot;,&quot;text&quot;:&quot;Exploring User Roles&quot;,&quot;link&quot;:&quot;exploring-user-roles&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Finding Help in Five&quot;,&quot;text&quot;:&quot;Finding Help in Five&quot;,&quot;link&quot;:&quot;finding-help-in-five&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Deploying Your App&quot;,&quot;text&quot;:&quot;Deploying Your App&quot;,&quot;link&quot;:&quot;deploying-your-app&quot;}]\" data-visible=\"[true,true,true,true,true,true]\" data-delete-headers=\"[{&quot;label&quot;:&quot;Goals and Objectives: Build a Cloud Application&quot;,&quot;value&quot;:&quot;goals-and-objectives-build-a-cloud-application&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Resources and Downloads: Build a Cloud Application&quot;,&quot;value&quot;:&quot;resources-and-downloads-build-a-cloud-application&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;CSV File&quot;,&quot;value&quot;:&quot;csv-file&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;SQL Query&quot;,&quot;value&quot;:&quot;sql-query&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;JavaScript Function&quot;,&quot;value&quot;:&quot;javascript-function&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;Theme&quot;,&quot;value&quot;:&quot;theme&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;Report Template&quot;,&quot;value&quot;:&quot;report-template&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;Step-by-Step Guide: Building a Cloud Application from Scratch&quot;,&quot;value&quot;:&quot;step-by-step-guide-building-a-cloud-application-from-scratch&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 1: Creating a New Cloud Application&quot;,&quot;value&quot;:&quot;step-1-creating-a-new-cloud-application&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 2: Running Your Cloud-Based Application&quot;,&quot;value&quot;:&quot;step-2-running-your-cloud-based-application&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 3: Creating Database Tables with Table Wizard&quot;,&quot;value&quot;:&quot;step-3-creating-database-tables-with-table-wizard&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Creating the Product Table&quot;,&quot;value&quot;:&quot;creating-the-product-table&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Creating the Orders Table&quot;,&quot;value&quot;:&quot;creating-the-orders-table&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Creating the ProductOrders Table&quot;,&quot;value&quot;:&quot;creating-the-productorders-table&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 4: Using the Database Modeler&quot;,&quot;value&quot;:&quot;step-4-using-the-database-modeler&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 5: Importing Data from a CSV&quot;,&quot;value&quot;:&quot;step-5-importing-data-from-a-csv&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 6: Creating Forms with Form Wizard&quot;,&quot;value&quot;:&quot;step-6-creating-forms-with-form-wizard&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Creating the Product and Orders Forms&quot;,&quot;value&quot;:&quot;creating-the-product-and-orders-forms&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Creating the ProductOrders Form&quot;,&quot;value&quot;:&quot;creating-the-productorders-form&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 7: Enhancing Forms by Adding Pages&quot;,&quot;value&quot;:&quot;step-7-enhancing-forms-by-adding-pages&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Second Checkpoint: Build Your Cloud Application&quot;,&quot;value&quot;:&quot;second-checkpoint-build-your-cloud-application&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 8: Validating Data on a Form&quot;,&quot;value&quot;:&quot;step-8-validating-data-on-a-form&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 9: Using Five&apos;s End-User GUI&quot;,&quot;value&quot;:&quot;step-9-using-fives-end-user-gui&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 10: Writing SQL Queries in Five&quot;,&quot;value&quot;:&quot;step-10-writing-sql-queries-in-five&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 11: Creating Charts For Your Cloud Application&quot;,&quot;value&quot;:&quot;step-11-creating-charts-for-your-cloud-application&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 12: Visual &gt; Reports: Generating a PDF Report&quot;,&quot;value&quot;:&quot;step-12-visual-reports-generating-a-pdf-report&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Report&quot;,&quot;value&quot;:&quot;report&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;Step 13: Visual &gt; Menus: Adding Menu Items to Your App&quot;,&quot;value&quot;:&quot;step-13-visual-menus-adding-menu-items-to-your-app&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Third Checkpoint: Ensuring Your App Functions Correctly&quot;,&quot;value&quot;:&quot;third-checkpoint-ensuring-your-app-functions-correctly&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 14: Logic &gt; Code Editor: Creating a JavaScript Function&quot;,&quot;value&quot;:&quot;step-14-logic-code-editor-creating-a-javascript-function&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 15: Visual &gt; Forms: Associating a Function with an Event&quot;,&quot;value&quot;:&quot;step-15-visual-forms-associating-a-function-with-an-event&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 16: Applications: Enabling Multiuser Functionality&quot;,&quot;value&quot;:&quot;step-16-applications-enabling-multiuser-functionality&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Fourth Checkpoint: First Login&quot;,&quot;value&quot;:&quot;fourth-checkpoint-first-login&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 17: Setup &gt; User Roles: Configuring Roles and Permissions&quot;,&quot;value&quot;:&quot;step-17-setup-user-roles-configuring-roles-and-permissions&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 18: Setup &gt; Themes: Customizing the Appearance of Your App&quot;,&quot;value&quot;:&quot;step-18-setup-themes-customizing-the-appearance-of-your-app&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 19: Setup &gt; Instances: Applying a Theme and Customizing the UI&quot;,&quot;value&quot;:&quot;step-19-setup-instances-applying-a-theme-and-customizing-the-ui&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Congratulations: You&apos;ve Built Your Cloud Web Application&quot;,&quot;value&quot;:&quot;congratulations-youve-built-your-cloud-web-application&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Exploring User Roles&quot;,&quot;value&quot;:&quot;exploring-user-roles&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Finding Help in Five&quot;,&quot;value&quot;:&quot;finding-help-in-five&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Deploying Your App&quot;,&quot;value&quot;:&quot;deploying-your-app&quot;,&quot;isDelete&quot;:false}]\" data-smooth=\"true\" data-top-offset=\"\"><div class=\"eb-toc__list-wrap\"><ul class=\"eb-toc__list\"><li><a href=\"#goals-and-objectives-build-a-cloud-application\">Goals and Objectives: Build a Cloud Application<\/a><li><a href=\"#resources-and-downloads-build-a-cloud-application\">Resources and Downloads: Build a Cloud Application<\/a><li><a href=\"#step-by-step-guide-building-a-cloud-application-from-scratch\">Step-by-Step Guide: Building a Cloud Application from Scratch<\/a><ul class=\"eb-toc__list\"><li><a href=\"#step-1-creating-a-new-cloud-application\">Step 1: Creating a New Cloud Application<\/a><li><a href=\"#step-2-running-your-cloud-based-application\">Step 2: Running Your Cloud-Based Application<\/a><li><a href=\"#step-3-creating-database-tables-with-table-wizard\">Step 3: Creating Database Tables with Table Wizard<\/a><ul class=\"eb-toc__list\"><li><a href=\"#creating-the-product-table\">Creating the Product Table<\/a><li><a href=\"#creating-the-orders-table\">Creating the Orders Table<\/a><li><a href=\"#creating-the-productorders-table\">Creating the ProductOrders Table<\/a><\/li><\/ul><li><a href=\"#step-4-using-the-database-modeler\">Step 4: Using the Database Modeler<\/a><li><a href=\"#step-5-importing-data-from-a-csv\">Step 5: Importing Data from a CSV<\/a><li><a href=\"#step-6-creating-forms-with-form-wizard\">Step 6: Creating Forms with Form Wizard<\/a><ul class=\"eb-toc__list\"><li><a href=\"#creating-the-product-and-orders-forms\">Creating the Product and Orders Forms<\/a><li><a href=\"#creating-the-productorders-form\">Creating the ProductOrders Form<\/a><\/li><\/ul><li><a href=\"#step-7-enhancing-forms-by-adding-pages\">Step 7: Enhancing Forms by Adding Pages<\/a><\/li><\/ul><li><a href=\"#second-checkpoint-build-your-cloud-application\">Second Checkpoint: Build Your Cloud Application<\/a><ul class=\"eb-toc__list\"><li><a href=\"#step-8-validating-data-on-a-form\">Step 8: Validating Data on a Form<\/a><li><a href=\"#step-9-using-fives-end-user-gui\">Step 9: Using Five&#8217;s End-User GUI<\/a><li><a href=\"#step-10-writing-sql-queries-in-five\">Step 10: Writing SQL Queries in Five<\/a><li><a href=\"#step-11-creating-charts-for-your-cloud-application\">Step 11: Creating Charts For Your Cloud Application<\/a><li><a href=\"#step-12-visual-reports-generating-a-pdf-report\">Step 12: Visual &gt; Reports: Generating a PDF Report<\/a><li><a href=\"#step-13-visual-menus-adding-menu-items-to-your-app\">Step 13: Visual &gt; Menus: Adding Menu Items to Your App<\/a><\/li><\/ul><li><a href=\"#third-checkpoint-ensuring-your-app-functions-correctly\">Third Checkpoint: Ensuring Your App Functions Correctly<\/a><ul class=\"eb-toc__list\"><li><a href=\"#step-14-logic-code-editor-creating-a-javascript-function\">Step 14: Logic &gt; Code Editor: Creating a JavaScript Function<\/a><li><a href=\"#step-15-visual-forms-associating-a-function-with-an-event\">Step 15: Visual &gt; Forms: Associating a Function with an Event<\/a><li><a href=\"#step-16-applications-enabling-multiuser-functionality\">Step 16: Applications: Enabling Multiuser Functionality<\/a><\/li><\/ul><li><a href=\"#fourth-checkpoint-first-login\">Fourth Checkpoint: First Login<\/a><ul class=\"eb-toc__list\"><li><a href=\"#step-17-setup-user-roles-configuring-roles-and-permissions\">Step 17: Setup &gt; User Roles: Configuring Roles and Permissions<\/a><li><a href=\"#step-18-setup-themes-customizing-the-appearance-of-your-app\">Step 18: Setup &gt; Themes: Customizing the Appearance of Your App<\/a><li><a href=\"#step-19-setup-instances-applying-a-theme-and-customizing-the-ui\">Step 19: Setup &gt; Instances: Applying a Theme and Customizing the UI<\/a><\/li><\/ul><li><a href=\"#congratulations-youve-built-your-cloud-web-application\">Congratulations: You&#8217;ve Built Your Cloud Web Application<\/a><ul class=\"eb-toc__list\"><li><a href=\"#exploring-user-roles\">Exploring User Roles<\/a><li><a href=\"#finding-help-in-five\">Finding Help in Five<\/a><li><a href=\"#deploying-your-app\">Deploying Your App<\/a><\/li><\/ul><\/ul><\/div><\/div><\/div><\/div><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"resources-and-downloads\">Resources and Downloads: Build a Cloud Application<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"csv-file\">CSV File<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Download the CSV file here.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-079b5d33-dcb9-48b8-8f41-1c0ca47bba8a\" href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/product_data-1.csv\" target=\"_blank\" rel=\"noreferrer noopener\">product_data-1<\/a><a href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/product_data-1.csv\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-079b5d33-dcb9-48b8-8f41-1c0ca47bba8a\">Download<\/a><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"sql-query\">SQL Query<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Download the SQL query here. <\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-f984382b-09df-4622-81ad-72307942bb19\" href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/ProductQuery.txt\" target=\"_blank\" rel=\"noreferrer noopener\">ProductQuery<\/a><a href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/ProductQuery.txt\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-f984382b-09df-4622-81ad-72307942bb19\">Download<\/a><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"java-script-function\">JavaScript Function<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Download the JavaScript function here.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-f3a116a7-4b94-4c84-a981-813b030fc81c\" href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/03\/Slack.txt\" target=\"_blank\" rel=\"noreferrer noopener\">Slack<\/a><a href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/03\/Slack.txt\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-f3a116a7-4b94-4c84-a981-813b030fc81c\">Download<\/a><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"theme\">Theme<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Download the CSS theme here.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-d9efd2eb-45b1-45f3-9758-f2c68e3a7ee9\" href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/PurpleHazeTheme.txt\">PurpleHazeTheme<\/a><a href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/PurpleHazeTheme.txt\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-d9efd2eb-45b1-45f3-9758-f2c68e3a7ee9\">Download<\/a><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h3 class=\"wp-block-heading\" id=\"report-template\">Report Template<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Download the report template or copy the HTML from here.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-a1eac728-16c7-40db-99ed-608c628b1f11\" href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/ProductReport.docx\" target=\"_blank\" rel=\"noreferrer noopener\">ProductReport<\/a><a href=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/ProductReport.docx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-a1eac728-16c7-40db-99ed-608c628b1f11\">Download<\/a><\/div>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step-by-Step Guide: Building a Cloud Application from Scratch<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Creating a New Cloud Application<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1.1.<\/strong> To create a new application in Five, navigate to the &#8220;Applications&#8221; section.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"694\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-7-1024x694-1.png\" alt=\"Creating a New Cloud Application\" class=\"wp-image-3013\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-7-1024x694-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-7-1024x694-1-300x203.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-7-1024x694-1-768x521.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 1.1: Creating a New Cloud Application<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>1.2.<\/strong> Click on the yellow Plus icon to start a new application.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Yellow-Plus-Button-Create-a-New-Application-1024x649-1.png\" alt=\"Build a New Cloud Application in Five\" class=\"wp-image-3014\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Yellow-Plus-Button-Create-a-New-Application-1024x649-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Yellow-Plus-Button-Create-a-New-Application-1024x649-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Yellow-Plus-Button-Create-a-New-Application-1024x649-1-768x487.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 1.2: Build a New Cloud Application in Five<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>1.3.<\/strong> Enter &#8220;My First App&#8221; in the Title field.<br><strong>1.4.<\/strong> Save your application by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"619\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-12-1024x619-1.png\" alt=\"\" class=\"wp-image-3015\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-12-1024x619-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-12-1024x619-1-300x181.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-12-1024x619-1-768x464.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 1.3: Saving a New Application<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Running Your Cloud-Based Application<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can run and preview your cloud application at any time. Click on the &#8220;Deploy to Development&#8221; button in the top navigation bar. The initial deployment may take a while as Five sets up a cloud-hosted instance for your app.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"259\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-4-1024x259-1.png\" alt=\"Deploy your application to development\" class=\"wp-image-3016\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-4-1024x259-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-4-1024x259-1-300x76.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-4-1024x259-1-768x194.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 2.1.: Deploying your application to development<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">After deployment, the &#8220;Deploy to Development&#8221; button will change to a &#8220;Run \u25b6\ufe0f&#8221; button. Click &#8220;Run \u25b6\ufe0f&#8221; to open a new window showing the current state of your application.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img width=\"1024\" height=\"576\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Run-Your-Application-1-1024x576.png\" alt=\"Running Your Application\" class=\"wp-image-3017\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Run-Your-Application-1-1024x576.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Run-Your-Application-1-300x169.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Run-Your-Application-1-768x432.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Run-Your-Application-1.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 2.2: Running Your Application<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Creating Database Tables with Table Wizard<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s start building our cloud application. Return to the development environment to continue.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.1.<\/strong> Click on the blue &#8220;Manage&#8221; button.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img width=\"1024\" height=\"576\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Manage-Your-Application-1024x576.png\" alt=\"Accessing Five's development environment\" class=\"wp-image-3018\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Manage-Your-Application-1024x576.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Manage-Your-Application-300x169.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Manage-Your-Application-768x432.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Manage-Your-Application.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 3.1: Accessing Five&#8217;s development environment<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>3.2.<\/strong> To add tables to Five&#8217;s integrated MySQL database, go to &#8220;Data&#8221; &gt; &#8220;Table Wizard.&#8221;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"518\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-9-1024x518-1.png\" alt=\"Accessing Five's Table Wizard\" class=\"wp-image-3019\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-9-1024x518-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-9-1024x518-1-300x152.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-9-1024x518-1-768x389.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 3.2: Accessing Five&#8217;s Table Wizard<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">We will create three tables: Products, Orders, and ProductOrders.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Creating the Product Table<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.3.<\/strong> Name your table &#8220;Product&#8221; in the Name field. Add fields by clicking the Plus \u2795 icon.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.4.<\/strong> Ensure your Product table fields match this structure:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Data Type<\/th><th>Required<\/th><th>Size<\/th><th>Default Display Type<\/th><\/tr><\/thead><tbody><tr><td>Name<\/td><td>Text<\/td><td>\u2714\ufe0f<\/td><td>100<\/td><td>_Text<\/td><\/tr><tr><td>SKU<\/td><td>Text<\/td><td><\/td><td>100<\/td><td>_Text<\/td><\/tr><tr><td>Price<\/td><td>Float<\/td><td><\/td><td><\/td><td>_Currency<\/td><\/tr><tr><td>Rating<\/td><td>Float<\/td><td><\/td><td><\/td><td>_RatingFloat<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Save the table by clicking the Tick \u2714\ufe0f icon and confirm in the Table Upgrade dialog.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"551\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-50-1024x551-1.png\" alt=\"Creating the Product Table\" class=\"wp-image-3020\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-50-1024x551-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-50-1024x551-1-300x161.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-50-1024x551-1-768x413.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 3.3: Creating the Product Table<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\">Creating the Orders Table<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.5.<\/strong> Repeat steps 3.3 and 3.4 for the Orders table. Ensure it looks like this:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Name<\/th><th>Data Type<\/th><th>Required<\/th><th>Size<\/th><th>Default Display Type<\/th><\/tr><\/thead><tbody><tr><td>OrderStatus<\/td><td>Text<\/td><td>\u2714\ufe0f<\/td><td>100<\/td><td>_Text<\/td><\/tr><tr><td>OrderDate<\/td><td>Date<\/td><td><\/td><td>100<\/td><td>_Date<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Save by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"550\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-51-1024x550-1.png\" alt=\"\" class=\"wp-image-3021\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-51-1024x550-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-51-1024x550-1-300x161.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-51-1024x550-1-768x413.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 3.4: Creating the Orders Table<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\">Creating the ProductOrders Table<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">The ProductOrders table links Products and Orders in a many-to-many relationship and contains only the Foreign Keys of these tables.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.7.<\/strong> Open the Table Wizard and name the table &#8220;ProductOrders.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.8.<\/strong> Click the Right Arrow &gt; to proceed.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"627\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-13-1024x627-1.png\" alt=\"\" class=\"wp-image-3022\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-13-1024x627-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-13-1024x627-1-300x184.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-13-1024x627-1-768x470.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 3.5: The ProductOrders Table<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>3.10.<\/strong> Add relationships by clicking the Plus \u2795 icon in the Relationships area, linking to both Product and Orders tables. Tick the Required box for both.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.12.<\/strong> Save the relationships and the table by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"651\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-14-1024x651-1.png\" alt=\"\" class=\"wp-image-3023\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-14-1024x651-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-14-1024x651-1-300x191.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-14-1024x651-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 3.6: Adding Relationships to the ProductOrders Table<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Using the Database Modeler<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4.1.<\/strong> Verify your database setup by navigating to &#8220;Data&#8221; &gt; &#8220;Database Modeler.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4.2.<\/strong> Arrange your tables to form a visual Entity-Relationship Diagram (ERD). Ensure relationships are correct, with &#8220;crows&#8217; feet&#8221; pointing to the ProductOrders table.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-15-1024x649-1.png\" alt=\"\" class=\"wp-image-3024\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-15-1024x649-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-15-1024x649-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-15-1024x649-1-768x487.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 4.1: Database Modeler with ERD<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\">Step 5: Importing Data from a CSV<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5.1.<\/strong> To import a CSV file into your database table, go to &#8220;Data&#8221; &gt; &#8220;Tables.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5.2.<\/strong> Click on the &#8220;Import CSV into Table \ud83d\udce5&#8221; button.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Data-Import-1024x650-1-1.png\" alt=\"\" class=\"wp-image-3025\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Data-Import-1024x650-1-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Data-Import-1024x650-1-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Data-Import-1024x650-1-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 5.1: Importing CSV into a Table<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>5.3.<\/strong> Select the Product table from the dropdown.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5.4.<\/strong> Choose the CSV file to import. Set ProductKey to &#8220;Generated.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5.5.<\/strong> Five will map your database fields to the CSV columns. Confirm by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"627\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-36-1024x627-1.png\" alt=\"\" class=\"wp-image-3026\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-36-1024x627-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-36-1024x627-1-300x184.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-36-1024x627-1-768x470.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 5.2: Mapping CSV Columns to Database Fields<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 6: Creating Forms with Form Wizard<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6.1.<\/strong> To create forms, go to &#8220;Visual&#8221; &gt; &#8220;Form Wizard.&#8221;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Form-Wizard-1024x650-2.png\" alt=\"\" class=\"wp-image-3027\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Form-Wizard-1024x650-2.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Form-Wizard-1024x650-2-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-Form-Wizard-1024x650-2-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 6.1: Accessing the Form Wizard<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\">Creating the Product and Orders Forms<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6.2.<\/strong> Select &#8220;Product&#8221; as the Main Data Source in the Form Wizard and save.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6.4.<\/strong> Repeat the process for the Orders table.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"628\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-16-1024x628-1.png\" alt=\"\" class=\"wp-image-3028\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-16-1024x628-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-16-1024x628-1-300x184.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-16-1024x628-1-768x471.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 6.2: Creating the Product Form<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\">Creating the ProductOrders Form<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6.5.<\/strong> Select &#8220;ProductOrders&#8221; as the Main Data Source in the Form Wizard.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6.6.<\/strong> Toggle off &#8220;Add Menu Item.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6.7.<\/strong> Click the Right Arrow &gt; to proceed.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"627\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-17-1024x627-1.png\" alt=\"\" class=\"wp-image-3029\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-17-1024x627-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-17-1024x627-1-300x184.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-17-1024x627-1-768x470.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 6.3: Defining the ProductOrders Form<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>6.8.<\/strong> Tick the &#8220;List&#8221; box for both fields: ProductKey and OrdersKey, then save.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"627\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-18-1024x627-1.png\" alt=\"\" class=\"wp-image-3030\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-18-1024x627-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-18-1024x627-1-300x184.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-18-1024x627-1-768x470.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 6.4: Settings for the ProductOrders Form<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 7: Enhancing Forms by Adding Pages<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7.1.<\/strong> Go to &#8220;Visual&#8221; &gt; &#8220;Forms.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7.2.<\/strong> Select the Orders form.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7.3.<\/strong> Click on &#8220;Pages&#8221; and then the Plus \u2795 icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"622\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-20-1024x622-1.png\" alt=\"\" class=\"wp-image-3031\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-20-1024x622-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-20-1024x622-1-300x182.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-20-1024x622-1-768x467.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 7.1: Adding a Page to the Orders Form<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>7.5.<\/strong> Set the Page Type to &#8220;List,&#8221; caption it as &#8220;Products,&#8221; and select &#8220;ProductOrders (Form)&#8221; as the Action.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>7.7.<\/strong> Save the new page by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"621\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-22-1024x621-1.png\" alt=\"\" class=\"wp-image-3032\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-22-1024x621-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-22-1024x621-1-300x182.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-22-1024x621-1-768x466.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 7.2: Page Type and Field Settings<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"second-checkpoint-run-your-application\">Second Checkpoint: Build Your Cloud Application<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It&#8217;s time to run your application to see what we have developed so far. As shown in Step 2 above, you can always preview your application by clicking on the <strong>Run \u25b6\ufe0f <\/strong>icon in the top right corner.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here&#8217;s what your app should look like:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"651\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/image-54-1024x651.png\" alt=\"\" class=\"wp-image-2442\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/image-54-1024x651.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/image-54-300x191.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/image-54-768x488.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/image-54-1536x976.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/02\/image-54.png 1770w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 8: Validating Data on a Form<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">8.1. Go to <strong>Setup &gt; Display Types.<\/strong><br>8.2. Click on the yellow <strong>Plus \u2795 <\/strong>button to create a new display type.<br>8.3. Fill in the following fields:<br>&#8211; For <strong>Name, <\/strong>type in <strong>SKU<\/strong>.<br>&#8211; For <strong>Display Type, <\/strong>select <strong>Text<\/strong>.<br>&#8211; Now go down to the bottom of the display type form, and toggle <strong>Regular Expression<\/strong>.<br>&#8211; For <strong>Mask,<\/strong> type or paste this regular expression: <code>^[A-Z]{3}-\\d+$<\/code><br>&#8211; Last, for <strong>Error Message, <\/strong>type in the error message that users will see if they fill in an invalid SKU, such as &#8220;Please enter a valid SKU.&#8221;<br>8.4. Click on the <strong>Tick \u2714\ufe0f <\/strong>icon to save your display type.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"525\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-8-1024x525-1.png\" alt=\"\" class=\"wp-image-3033\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-8-1024x525-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-8-1024x525-1-300x154.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-8-1024x525-1-768x394.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 8.1: Creating a New Display Type<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>8.5.<\/strong> Apply this display type to the SKU field in the Products form under &#8220;Visual&#8221; &gt; &#8220;Forms&#8221; &gt; &#8220;Pages&#8221; &gt; &#8220;General&#8221; &gt; &#8220;Fields.&#8221;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"525\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-9-1024x525-1.png\" alt=\"\" class=\"wp-image-3034\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-9-1024x525-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-9-1024x525-1-300x154.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-9-1024x525-1-768x394.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 8.2: Applying the Display Type to a Field<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>8.8.<\/strong> Change the Display Type of the SKU field to SKU and save.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"521\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-10-1024x521-1.png\" alt=\"\" class=\"wp-image-3035\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-10-1024x521-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-10-1024x521-1-300x153.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-10-1024x521-1-768x391.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 8.3: SKU Field with Display Type Applied<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 9: Using Five&#8217;s End-User GUI<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>9.1.<\/strong> In the end-user application, add some dummy data to the Orders table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>9.2.<\/strong> Add products to your orders via the Plus \u2795 icon in the Products page.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-56-1024x650-1.png\" alt=\"\" class=\"wp-image-3047\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-56-1024x650-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-56-1024x650-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-56-1024x650-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 9.1: Adding Dummy Data in End-User GUI<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">9.5 Repeat these steps until you have several orders stored in your database. As shown in Image 8.1, your orders will appear in a list. In Image 9.1, this list contains a <strong>New, Pending, Pending <\/strong>and <strong>Shipped <\/strong>order.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 10: Writing SQL Queries in Five<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Now let&#8217;s create a SQL query in Five, so let&#8217;s go back into our development environment. We will write a query that returns some of the data you created previously.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>10.1.<\/strong> Go to &#8220;Data&#8221; &gt; &#8220;Queries.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>10.2.<\/strong> Add a new query by clicking the yellow plus and name it &#8220;ProductQuery.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>10.4.<\/strong> Click on &#8220;Click to add&#8221; to open the Query Editor.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-37-1024x649-1.png\" alt=\"\" class=\"wp-image-3048\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-37-1024x649-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-37-1024x649-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-37-1024x649-1-768x487.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 10.1: Accessing the Query Editor<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>10.5<\/strong>. Click on <strong>SQL<\/strong>.<br><strong>10.6<\/strong>. Paste the SQL into the SQL Editor. Make sure to have some orders in your Orders table. Otherwise, the query will not produce any results! To test your query, click on the <strong>Run <\/strong>\u25b6\ufe0f icon.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#282c34\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"SELECT\n  `Product`.`Name`,\n  `Product`.`Price`,\n  `Orders`.`OrderDate`\nFROM\n  `Product`\n  INNER JOIN `ProductOrders` ON (\n    `ProductOrders`.`ProductKey` = `Product`.`ProductKey`\n  )\n  INNER JOIN `Orders` ON (\n    `ProductOrders`.`OrdersKey` = `Orders`.`OrdersKey`\n  )\" style=\"color:#abb2bf;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki one-dark-pro\" style=\"background-color: #282c34\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #C678DD\">SELECT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #98C379\">`Product`<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #98C379\">`Name`<\/span><span style=\"color: #ABB2BF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #98C379\">`Product`<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #98C379\">`Price`<\/span><span style=\"color: #ABB2BF\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #98C379\">`Orders`<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #98C379\">`OrderDate`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #C678DD\">FROM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #98C379\">`Product`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #C678DD\">INNER JOIN<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #98C379\">`ProductOrders`<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #C678DD\">ON<\/span><span style=\"color: #ABB2BF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    <\/span><span style=\"color: #98C379\">`ProductOrders`<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #98C379\">`ProductKey`<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #56B6C2\">=<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #98C379\">`Product`<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #98C379\">`ProductKey`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  )<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #C678DD\">INNER JOIN<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #98C379\">`Orders`<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #C678DD\">ON<\/span><span style=\"color: #ABB2BF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    <\/span><span style=\"color: #98C379\">`ProductOrders`<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #98C379\">`OrdersKey`<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #56B6C2\">=<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #98C379\">`Orders`<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #98C379\">`OrdersKey`<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  )<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>10.7.<\/strong> Save your query by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-38-1024x650-1.png\" alt=\"\" class=\"wp-image-3049\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-38-1024x650-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-38-1024x650-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-38-1024x650-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 10.2: SQL Query Editor<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 11: Creating Charts For Your Cloud Application<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>11.1.<\/strong> Navigate to &#8220;Visual&#8221; &gt; &#8220;Chart Wizard.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>11.2.<\/strong> Fill in the required fields (marked with an asterisk *) and select your X Value Column and Y Value Column.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>11.3.<\/strong> Save the chart settings by clicking tick in the top right<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-23-1024x649-1.png\" alt=\"\" class=\"wp-image-3050\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-23-1024x649-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-23-1024x649-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-23-1024x649-1-768x487.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 11.1: Creating a Bar Chart<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 12: Visual &gt; Reports: Generating a PDF Report<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">12.1. Begin by navigating to Visual &gt; Reports to create a PDF report from your database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12.2. Click the yellow Plus icon to start a new report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12.3. Enter &#8220;Product Report&#8221; into the Title field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12.4. Select the Data Sources option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"652\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-24-1024x652-1-1.png\" alt=\"\" class=\"wp-image-3051\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-24-1024x652-1-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-24-1024x652-1-1-300x191.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-24-1024x652-1-1-768x489.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 12.1: A report requires a title and data source before it can be created.<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">12.5. Click the Plus \u2795 icon to add a new data source.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12.6. Choose &#8220;Product (Table)&#8221; as your Data Source.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12.7. Save by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-25-1024x650-1.png\" alt=\"\" class=\"wp-image-3052\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-25-1024x650-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-25-1024x650-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-25-1024x650-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 12.2: Adding the Product (Table) as a data source for your report.<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">12.8. Return to the General tab.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12.9. In the Template field, click &#8220;Click to add&#8221; to open Five&#8217;s report template editor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">12.10. Click the &lt;\/&gt; icon to open the HTML editor.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-26-1024x650-1.png\" alt=\"\" class=\"wp-image-3053\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-26-1024x650-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-26-1024x650-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-26-1024x650-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 12.3: Opening the HTML report editor by clicking the &lt;\/&gt; icon.<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">12.11. Clear the existing code in the editor and replace it with the following HTML:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#282c34\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"&lt;style&gt;\n    .demo tr {\n      background-color: lightgrey\n    }\n        \n&lt;\/style&gt;\n\n&lt;div&gt;&lt;img src=&quot;data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKMAAAAtCAYAAADC1tsoAAAABmJLR0QA\/wD\/AP+gvaeTAAAHlklEQVR42u2cbWxTVRjHLxvv8hJQM1HRgdB2dLyE3rYMQizQtRs4hA8V1iIqiQu+EBK\/EAHZ5YOsiwtRfIkjSIIGWW9AhX2g3YAFPhiNiy8gbEMmuHUImYKArN0YOz6nux13d\/d2ve29t3M7\/+SfLO2559777JfnnOeck1LUABCiqLQWs7kgaKUrKCIiMeWX\/vak2hAGLSZXk4W+0GyhEfgnEnUiUTm89d\/keutrwZudu89PVqrf80bjyKCFXt9sMV3kIIz6NIk6kahySxvKAETEOZRbWs\/aSy7aKYSGJdpnk9X8SrOZbhFAyNlUSaJOJA5jSf1GHox8N8B3W5a9ey5Dbp8AXak4iNjmgyTqRKLCWVACxqg7Hd66agDTZWNqhscFI01bpGAMWsyfkKgTiSqvpC6zHxj5boFh3AsAT++naBkG4F2RyIxeEnUiUTEMSgPIwjKAxL6Ps6Xd27A+Z3fzGNF5o4XeLQYjfL6NRJ1Iet7ora+TCSPfN+2lDeVOb8Ncfp8tNL1IYqh+k0ScKMa8saEyCRj5rnWU1BXZmPPj8PqiWEWNl3tIxIkktbTswtMAkUkpL9tVp4sUMmb6o77DtGkViTiRbKGt2RnJXB+0mpb0zYzzl5LIEskD8R1DDtqhW51UHy5XOlTP1\/kw\/mGdbyLRJZKREbOmoGJ9I2JmTEi2Lxiqy3tlR6t1psKPi3eK1oK3aODHBPd+ClzEs5RywKNS+C\/FMVoS4\/s08ErBu6hlGSAymaMBxO9RsU6Rbbsmq8nBh\/F3qzVD4UDjF0QaWZjVCwTfi8kGDoFPgCekAMSR4APc870u0aZMwxjKgLFY\/xkYIUa\/QZEsa7MNBwhbe4DMyRmjcLDLBzCMc8C3eN+f5bKpVpoEPsW7\/32wS6TdDwMORsTo3uJA7ERvz3hUqYgEzfR+DsYOFQLOh\/EfcK2KzpIJ43jwcUGbP8G0BiBOA18Q3PsqeLZI21pemxvgRhUdF4h2APEeB+MpJaMC5xlXcDC2qgzjMY2HwHiGabyfv1fQ7l\/w8yo+lxl8TXDPWFmZDyOT2oKFMWQChK0RELF3GDYp2X+tyTQCquobAGPjEIQxWkDgf3IXr20nVxQpLbyOe1fwXFX9zFcHBoyIMY4DAM89AFHfhbY9M1Xp+zRb6S9UOuX9f4AxqpfA7YJryrnsqYQ2c\/NCfv\/7wCP6yxcphxGfroEhme0BMTJEG75T415450XqlHeH3zhXIRjPcEWGWh6bJIxYeNH\/puA6f5KVdjp4j6DPLhlg8WH8ADxdRUtVzoadvUDszoxqDB3UZZtttPBgLao2TQwFjIfCAWNXyG98dRBW01Iygq8Irv0FnMiI9BD4qKCvMLhQzkwqpdU0FCyrIkOyEMbter1ambhpAb0y+ndbddYCgLARjDh3tvuN7iECI8UtoAuXVFrA85Ps4y\/wYrnT+pTBiLbPzALwbvUBkdGfVXVaAGuOiHWlA3RbAL4OHogPgAxkrxkiMEaz2jFBH3fAzyWYXS+BdYnUmCmBEQqWyQDdpT4gRmzYqSaMbYHsqeFA9mkRCPnGkBYkCONJlec7oxSGMTrf+1DQD66034hxzTKReee34ETXhrWaM2Y+ANFFpQN0x8VBxJlx5rwVB92TsJUGsb0qezXMD\/\/uB8So28OBWfmDsJqWWwljMNIE7V7GNZ+gHQtOZmdL+2oaMuL7kiAW6y9H2+X5PHuch9YtVuSelaaxANfeOCHku7nt5NwnhhCMWPiUVJugz6+4Kj66VoniAHZgwwjHwV6MASL2e9G2ziPrpjh97tY8n5txwRwv4Wzon2UEqM7GCd89cG24yugN+7PsqMY2fIhlxqgWglsF\/eLlti8Fn+HsuEGhe2oHI2KyFkBWDMeEkTEs5F\/j9Hk2ApDIyRbW5B\/xyPoJFISoYQBWEfhuDPju94Yvc\/QQWPSOV3h+VRejCLgNzlfwfnwYr1Jq7u\/DMs6OyLEwRt8mDqL+KmIEqR6Agsx4MgKkz30zr8LtiuetbtfoHgHIjkkAiJdyyturZrlunzA8rFAgByOMWPinZk6LgBgEz1P4XtpX05EChtFNh73nAsiEDD6zCDBeB38s9oTLK9boAMQQByRyVrg\/L6gsGiv1RlCgLAXYgj3w+Y2tUD2zOEuGAnOmqQTEYIWR4qr3g7z+fwar8UNdB6iBcoQMbZoheQoZINzaA2M3kL8uZz29jiHh+V0okM0AdHcAvmq8jtgRmG3qk23VEV77c3FepDGMGRyQUashXLjg3ZSNVN\/tSKU0nqvmvSp7V1JPaQPQnKz7Rz6QDp+7DT7b3D0fpdLwumCoavaziDWOpIiI1FQu654HEN7rlSG7fViNNUkiophy+grLRGDEw\/aVXJ9nEYkQkXYzdShcAL5LokBC1sRrkqA0EikijbKjewm4SwJIhJeCcg+tfZxEikgrIPdLwcj52sqjG8aTSBGpLjvrmgjAtUjD6PGRKBFpWcy8IAFjp+NwoYFEiEjr4fprIYwOn+dTEhkizYULFbxnzV8Il3uggohIMTlY92s9lXSFp4REhChlwuuKcMTsTCRDsq7JJCJEKVUeu04f3acmIupP\/wHYJhviTK\/+pwAAAABJRU5ErkJggg==&quot; style=&quot;&quot;&gt;&lt;\/div&gt;\n&lt;div&gt;&lt;br&gt;&lt;\/div&gt;\n&lt;h1&gt;Report&lt;\/h1&gt;\n&lt;table style=&quot;letter-spacing: 0.00938em; width: 100%; font-size: 1rem;&quot; class=&quot;demo&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr style=&quot;border-bottom: 2px solid black;&quot; class=&quot;fiveReportHeaderRepeat-Level1&quot;&gt;\n            &lt;td style=&quot;width: 28.1305%; background-color: rgb(153, 153, 153); color: rgb(255, 255, 255); text-align: left;&quot;&gt;Name&lt;\/td&gt;\n\n            &lt;td style=&quot;width: 50.97%; background-color: rgb(153, 153, 153); color: rgb(255, 255, 255); text-align: left;&quot;&gt;SKU&lt;\/td&gt;\n\n            &lt;td style=&quot;width: 18.254%; text-align: left; background-color: rgb(153, 153, 153); color: rgb(255, 255, 255);&quot;&gt;Price&lt;\/td&gt;\n        &lt;\/tr&gt;\n\n        &lt;tr class=&quot;fiveReportHelper&quot; contenteditable=&quot;false&quot;&gt;\n            &lt;td class=&quot;fiveReportHelper&quot;&gt;{{#each @root.[Product].[Records] as | Product |}}&lt;\/td&gt;\n            &lt;td&gt;&lt;br&gt;&lt;\/td&gt;\n            &lt;td&gt;&lt;br&gt;&lt;\/td&gt;\n        &lt;\/tr&gt;\n        &lt;tr class=&quot;&quot; contenteditable=&quot;false&quot;&gt;\n\n            &lt;td style=&quot;text-align: left;&quot;&gt;{{Product.[Name]}}&lt;\/td&gt;\n\n            &lt;td style=&quot;text-align: left;&quot;&gt;{{Product.[SKU]}}&lt;\/td&gt;\n\n            &lt;td style=&quot;text-align: left;&quot;&gt;{{Product.[Price]}}&lt;\/td&gt;\n        &lt;\/tr&gt;\n        &lt;tr class=&quot;fiveReportHelper&quot; contenteditable=&quot;false&quot;&gt;\n            &lt;td class=&quot;fiveReportHelper&quot;&gt;{{\/each}}&lt;\/td&gt;\n            &lt;td&gt;&lt;br&gt;&lt;\/td&gt;\n            &lt;td&gt;&lt;br&gt;&lt;\/td&gt;\n        &lt;\/tr&gt;\n\n    &lt;\/tbody&gt;\n&lt;\/table&gt;\n&lt;div&gt;&lt;br&gt;&lt;\/div&gt;\n\n&lt;div style=&quot;text-align: center;  display: flex; justify-content: center; align-items: center;&quot;&gt;\n    &lt;div style=&quot;width: 150mm; height: 125mm; border: 1px dashed black; display: flex; justify-content: center; align-items: center;&quot;&gt;&nbsp; &nbsp;{{{_Chart 'ProductChart'}}}&lt;\/div&gt;\n&lt;\/div&gt;\n&lt;div&gt;&lt;br&gt;&lt;\/div&gt;\n&lt;div&gt;&lt;br&gt;&lt;\/div&gt;\n&lt;div&gt;&lt;br&gt;&lt;\/div&gt;\n&lt;div&gt;&lt;br&gt;&lt;\/div&gt;\n\n&lt;table class=&quot;fiveReportFooter-everyPage&quot; style=&quot;width: 100%; height: 10mm;&quot;&gt;\n    &lt;tbody&gt;\n        &lt;tr&gt;\n            &lt;td style=&quot;text-align: right;&quot;&gt;&lt;span style=&quot;font-size: 12px;&quot;&gt;&lt;em&gt;Page&nbsp;&lt;five.pageNumber.current.arabic&gt; of&nbsp;&lt;five.pageNumber.total.arabic&gt;&lt;\/em&gt;&lt;\/span&gt;&lt;\/td&gt;\n\n        &lt;\/tr&gt;\n    &lt;\/tbody&gt;\n\n\n&lt;\/table&gt;\" style=\"color:#abb2bf;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki one-dark-pro\" style=\"background-color: #282c34\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">style<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    <\/span><span style=\"color: #D19A66\">.demo<\/span><span style=\"color: #C678DD\"> <\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\"> {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">      background-color: lightgrey<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        <\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;\/<\/span><span style=\"color: #E06C75\">style<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">img<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">src<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKMAAAAtCAYAAADC1tsoAAAABmJLR0QA\/wD\/AP+gvaeTAAAHlklEQVR42u2cbWxTVRjHLxvv8hJQM1HRgdB2dLyE3rYMQizQtRs4hA8V1iIqiQu+EBK\/EAHZ5YOsiwtRfIkjSIIGWW9AhX2g3YAFPhiNiy8gbEMmuHUImYKArN0YOz6nux13d\/d2ve29t3M7\/+SfLO2559777JfnnOeck1LUABCiqLQWs7kgaKUrKCIiMeWX\/vak2hAGLSZXk4W+0GyhEfgnEnUiUTm89d\/keutrwZudu89PVqrf80bjyKCFXt9sMV3kIIz6NIk6kahySxvKAETEOZRbWs\/aSy7aKYSGJdpnk9X8SrOZbhFAyNlUSaJOJA5jSf1GHox8N8B3W5a9ey5Dbp8AXak4iNjmgyTqRKLCWVACxqg7Hd66agDTZWNqhscFI01bpGAMWsyfkKgTiSqvpC6zHxj5boFh3AsAT++naBkG4F2RyIxeEnUiUTEMSgPIwjKAxL6Ps6Xd27A+Z3fzGNF5o4XeLQYjfL6NRJ1Iet7ora+TCSPfN+2lDeVOb8Ncfp8tNL1IYqh+k0ScKMa8saEyCRj5rnWU1BXZmPPj8PqiWEWNl3tIxIkktbTswtMAkUkpL9tVp4sUMmb6o77DtGkViTiRbKGt2RnJXB+0mpb0zYzzl5LIEskD8R1DDtqhW51UHy5XOlTP1\/kw\/mGdbyLRJZKREbOmoGJ9I2JmTEi2Lxiqy3tlR6t1psKPi3eK1oK3aODHBPd+ClzEs5RywKNS+C\/FMVoS4\/s08ErBu6hlGSAymaMBxO9RsU6Rbbsmq8nBh\/F3qzVD4UDjF0QaWZjVCwTfi8kGDoFPgCekAMSR4APc870u0aZMwxjKgLFY\/xkYIUa\/QZEsa7MNBwhbe4DMyRmjcLDLBzCMc8C3eN+f5bKpVpoEPsW7\/32wS6TdDwMORsTo3uJA7ERvz3hUqYgEzfR+DsYOFQLOh\/EfcK2KzpIJ43jwcUGbP8G0BiBOA18Q3PsqeLZI21pemxvgRhUdF4h2APEeB+MpJaMC5xlXcDC2qgzjMY2HwHiGabyfv1fQ7l\/w8yo+lxl8TXDPWFmZDyOT2oKFMWQChK0RELF3GDYp2X+tyTQCquobAGPjEIQxWkDgf3IXr20nVxQpLbyOe1fwXFX9zFcHBoyIMY4DAM89AFHfhbY9M1Xp+zRb6S9UOuX9f4AxqpfA7YJryrnsqYQ2c\/NCfv\/7wCP6yxcphxGfroEhme0BMTJEG75T415450XqlHeH3zhXIRjPcEWGWh6bJIxYeNH\/puA6f5KVdjp4j6DPLhlg8WH8ADxdRUtVzoadvUDszoxqDB3UZZtttPBgLao2TQwFjIfCAWNXyG98dRBW01Iygq8Irv0FnMiI9BD4qKCvMLhQzkwqpdU0FCyrIkOyEMbter1ambhpAb0y+ndbddYCgLARjDh3tvuN7iECI8UtoAuXVFrA85Ps4y\/wYrnT+pTBiLbPzALwbvUBkdGfVXVaAGuOiHWlA3RbAL4OHogPgAxkrxkiMEaz2jFBH3fAzyWYXS+BdYnUmCmBEQqWyQDdpT4gRmzYqSaMbYHsqeFA9mkRCPnGkBYkCONJlec7oxSGMTrf+1DQD66034hxzTKReee34ETXhrWaM2Y+ANFFpQN0x8VBxJlx5rwVB92TsJUGsb0qezXMD\/\/uB8So28OBWfmDsJqWWwljMNIE7V7GNZ+gHQtOZmdL+2oaMuL7kiAW6y9H2+X5PHuch9YtVuSelaaxANfeOCHku7nt5NwnhhCMWPiUVJugz6+4Kj66VoniAHZgwwjHwV6MASL2e9G2ziPrpjh97tY8n5txwRwv4Wzon2UEqM7GCd89cG24yugN+7PsqMY2fIhlxqgWglsF\/eLlti8Fn+HsuEGhe2oHI2KyFkBWDMeEkTEs5F\/j9Hk2ApDIyRbW5B\/xyPoJFISoYQBWEfhuDPju94Yvc\/QQWPSOV3h+VRejCLgNzlfwfnwYr1Jq7u\/DMs6OyLEwRt8mDqL+KmIEqR6Agsx4MgKkz30zr8LtiuetbtfoHgHIjkkAiJdyyturZrlunzA8rFAgByOMWPinZk6LgBgEz1P4XtpX05EChtFNh73nAsiEDD6zCDBeB38s9oTLK9boAMQQByRyVrg\/L6gsGiv1RlCgLAXYgj3w+Y2tUD2zOEuGAnOmqQTEYIWR4qr3g7z+fwar8UNdB6iBcoQMbZoheQoZINzaA2M3kL8uZz29jiHh+V0okM0AdHcAvmq8jtgRmG3qk23VEV77c3FepDGMGRyQUashXLjg3ZSNVN\/tSKU0nqvmvSp7V1JPaQPQnKz7Rz6QDp+7DT7b3D0fpdLwumCoavaziDWOpIiI1FQu654HEN7rlSG7fViNNUkiophy+grLRGDEw\/aVXJ9nEYkQkXYzdShcAL5LokBC1sRrkqA0EikijbKjewm4SwJIhJeCcg+tfZxEikgrIPdLwcj52sqjG8aTSBGpLjvrmgjAtUjD6PGRKBFpWcy8IAFjp+NwoYFEiEjr4fprIYwOn+dTEhkizYULFbxnzV8Il3uggohIMTlY92s9lXSFp4REhChlwuuKcMTsTCRDsq7JJCJEKVUeu04f3acmIupP\/wHYJhviTK\/+pwAAAABJRU5ErkJggg==&quot;<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">h1<\/span><span style=\"color: #ABB2BF\">&gt;Report&lt;\/<\/span><span style=\"color: #E06C75\">h1<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">table<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;letter-spacing: 0.00938em; width: 100%; font-size: 1rem;&quot;<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">class<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;demo&quot;<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    &lt;<\/span><span style=\"color: #E06C75\">tbody<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;border-bottom: 2px solid black;&quot;<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">class<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;fiveReportHeaderRepeat-Level1&quot;<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;width: 28.1305%; background-color: rgb(153, 153, 153); color: rgb(255, 255, 255); text-align: left;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;Name&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;width: 50.97%; background-color: rgb(153, 153, 153); color: rgb(255, 255, 255); text-align: left;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;SKU&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;width: 18.254%; text-align: left; background-color: rgb(153, 153, 153); color: rgb(255, 255, 255);&quot;<\/span><span style=\"color: #ABB2BF\">&gt;Price&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;\/<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">class<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;fiveReportHelper&quot;<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">contenteditable<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;false&quot;<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">class<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;fiveReportHelper&quot;<\/span><span style=\"color: #ABB2BF\">&gt;{{#each @root.[Product].[Records] as | Product |}}&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;\/<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">class<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;&quot;<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">contenteditable<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;false&quot;<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;text-align: left;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;{{Product.[Name]}}&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;text-align: left;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;{{Product.[SKU]}}&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;text-align: left;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;{{Product.[Price]}}&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;\/<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">class<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;fiveReportHelper&quot;<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">contenteditable<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;false&quot;<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">class<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;fiveReportHelper&quot;<\/span><span style=\"color: #ABB2BF\">&gt;{{\/each}}&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;\/<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    &lt;\/<\/span><span style=\"color: #E06C75\">tbody<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;\/<\/span><span style=\"color: #E06C75\">table<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;text-align: center;  display: flex; justify-content: center; align-items: center;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    &lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;width: 150mm; height: 125mm; border: 1px dashed black; display: flex; justify-content: center; align-items: center;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;\u00a0 \u00a0{{{_Chart &#39;ProductChart&#39;}}}&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">br<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">div<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;<\/span><span style=\"color: #E06C75\">table<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">class<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;fiveReportFooter-everyPage&quot;<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;width: 100%; height: 10mm;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    &lt;<\/span><span style=\"color: #E06C75\">tbody<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">            &lt;<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;text-align: right;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">span<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">style<\/span><span style=\"color: #ABB2BF\">=<\/span><span style=\"color: #98C379\">&quot;font-size: 12px;&quot;<\/span><span style=\"color: #ABB2BF\">&gt;&lt;<\/span><span style=\"color: #E06C75\">em<\/span><span style=\"color: #ABB2BF\">&gt;Page\u00a0&lt;<\/span><span style=\"color: #E06C75\">five.pageNumber.current.arabic<\/span><span style=\"color: #ABB2BF\">&gt; of\u00a0&lt;<\/span><span style=\"color: #E06C75\">five.pageNumber.total.arabic<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">em<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">span<\/span><span style=\"color: #ABB2BF\">&gt;&lt;\/<\/span><span style=\"color: #E06C75\">td<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">        &lt;\/<\/span><span style=\"color: #E06C75\">tr<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    &lt;\/<\/span><span style=\"color: #E06C75\">tbody<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">&lt;\/<\/span><span style=\"color: #E06C75\">table<\/span><span style=\"color: #ABB2BF\">&gt;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">12.12. Click on the <strong>Tick \u2714\ufe0f <\/strong>icon to save your HTML.<br>12.13. Click on the <strong>Tick \u2714\ufe0f <\/strong>icon to save your report.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 13: Visual &gt; Menus: Adding Menu Items to Your App<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">13.1. Navigate to Visual &gt; Menus.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.2. Click the yellow Plus icon to add a new menu.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.3. Create a parent menu called &#8220;Charts &amp; Reports.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.4. Enter &#8220;Charts &amp; Reports&#8221; into the Caption field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.5. Set the Menu Order to 3.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.6. Save by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-40-1024x650-1.png\" alt=\"\" class=\"wp-image-3054\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-40-1024x650-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-40-1024x650-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-40-1024x650-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 13.1: Creating the Charts &amp; Reports Menu Item<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Next, we need to create new menu items for the chart and report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.7. Click the yellow Plus icon.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.8. For the Chart menu, fill in Caption, Action, and Parent Menu as shown in Image 11.2.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.9. Save by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-30-1024x650-1.png\" alt=\"\" class=\"wp-image-3055\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-30-1024x650-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-30-1024x650-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-30-1024x650-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 13.2: Creating the Chart Menu Item with ProductChart as an Action<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">13.10. For the Report menu, fill in Caption, Action, and Parent Menu as shown in Image 11.3.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">13.11. Save by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-31-1024x650-1.png\" alt=\"\" class=\"wp-image-3056\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-31-1024x650-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-31-1024x650-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-31-1024x650-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 13.3: Creating the Report Menu Item with ProductReport as an Action<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Third Checkpoint: Ensuring Your App Functions Correctly<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Run your application to verify that the forms, charts, and reports are functioning as expected. When you select the Chart from the menu, the corresponding chart should appear. Additionally, test the report to confirm that a PDF document is generated within your application.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img width=\"1024\" height=\"652\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-33-1024x652-1.png\" alt=\"\" class=\"wp-image-3057\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-33-1024x652-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-33-1024x652-1-300x191.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-33-1024x652-1-768x489.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 14: Logic &gt; Code Editor: Creating a JavaScript Function<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To integrate your application with Slack using a webhook, follow these steps to create a function that sends a message to a Slack channel whenever a new order is submitted.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14.1. Navigate to Logic &gt; Code Editor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14.2. Click the Plus \u2795 icon to add a new function.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img width=\"1024\" height=\"654\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-41-1024x654-2.png\" alt=\"\" class=\"wp-image-3059\" style=\"width:840px;height:auto\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-41-1024x654-2.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-41-1024x654-2-300x192.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-41-1024x654-2-768x491.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 14.1: Adding a new function by clicking the Plus button in the Code Editor<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">14.3. Enter &#8220;Slack&#8221; into the Function ID field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14.4. Keep JavaScript selected as the language.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14.5. Click Okay.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">14.6. Delete the existing code and replace it with the following JavaScript function:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#282c34\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"function Slack(five, context, result) {\n  const client = five.httpClient();\n  const form = context.Transactions[0].Values;\n  five.log(JSON.stringify(form));\n  client.setContentType(&quot;application\/json&quot;);\n  client.setContent(`{\n        &quot;text&quot;: &quot;A Customer has made an order, \\n Date: ${form.OrderDate} \\n Status ${form.OrderStatus}&quot;\n    }`);\n\n  try {\n    \/\/ Slack Webhook\u2b07\ufe0f\n    const httpResult = client.post(\n      &quot;https:\/\/hooks.slack.com\/services\/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&quot;\n    );\n    five.log(JSON.stringify(httpResult))\n    if (httpResult.isOk() === false) {\n      return five.createError(httpResult);\n    }\n  } catch (err) {\n    five.log(err);\n  }\n  return five.success(result);\n}\" style=\"color:#abb2bf;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki one-dark-pro\" style=\"background-color: #282c34\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #C678DD\">function<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #61AFEF\">Slack<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #E06C75; font-style: italic\">five<\/span><span style=\"color: #ABB2BF\">, <\/span><span style=\"color: #E06C75; font-style: italic\">context<\/span><span style=\"color: #ABB2BF\">, <\/span><span style=\"color: #E06C75; font-style: italic\">result<\/span><span style=\"color: #ABB2BF\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #C678DD\">const<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #E5C07B\">client<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #56B6C2\">=<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #E5C07B\">five<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">httpClient<\/span><span style=\"color: #ABB2BF\">();<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #C678DD\">const<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #E5C07B\">form<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #56B6C2\">=<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #E5C07B\">context<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #E06C75\">Transactions<\/span><span style=\"color: #ABB2BF\">[<\/span><span style=\"color: #D19A66\">0<\/span><span style=\"color: #ABB2BF\">].<\/span><span style=\"color: #E06C75\">Values<\/span><span style=\"color: #ABB2BF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #E5C07B\">five<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">log<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #E5C07B\">JSON<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">stringify<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #E06C75\">form<\/span><span style=\"color: #ABB2BF\">));<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #E5C07B\">client<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">setContentType<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #98C379\">&quot;application\/json&quot;<\/span><span style=\"color: #ABB2BF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #E5C07B\">client<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">setContent<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #98C379\">`{<\/span><\/span>\n<span class=\"line\"><span style=\"color: #98C379\">        &quot;text&quot;: &quot;A Customer has made an order, <\/span><span style=\"color: #56B6C2\">\\n<\/span><span style=\"color: #98C379\"> Date: <\/span><span style=\"color: #C678DD\">${<\/span><span style=\"color: #E5C07B\">form<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #E06C75\">OrderDate<\/span><span style=\"color: #C678DD\">}<\/span><span style=\"color: #98C379\"> <\/span><span style=\"color: #56B6C2\">\\n<\/span><span style=\"color: #98C379\"> Status <\/span><span style=\"color: #C678DD\">${<\/span><span style=\"color: #E5C07B\">form<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #E06C75\">OrderStatus<\/span><span style=\"color: #C678DD\">}<\/span><span style=\"color: #98C379\">&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #98C379\">    }`<\/span><span style=\"color: #ABB2BF\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #C678DD\">try<\/span><span style=\"color: #ABB2BF\"> {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    <\/span><span style=\"color: #7F848E; font-style: italic\">\/\/ Slack Webhook\u2b07\ufe0f<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    <\/span><span style=\"color: #C678DD\">const<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #E5C07B\">httpResult<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #56B6C2\">=<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #E5C07B\">client<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">post<\/span><span style=\"color: #ABB2BF\">(<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">      <\/span><span style=\"color: #98C379\">&quot;https:\/\/hooks.slack.com\/services\/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&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    );<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    <\/span><span style=\"color: #E5C07B\">five<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">log<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #E5C07B\">JSON<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">stringify<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #E06C75\">httpResult<\/span><span style=\"color: #ABB2BF\">))<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    <\/span><span style=\"color: #C678DD\">if<\/span><span style=\"color: #ABB2BF\"> (<\/span><span style=\"color: #E5C07B\">httpResult<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">isOk<\/span><span style=\"color: #ABB2BF\">() <\/span><span style=\"color: #56B6C2\">===<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #D19A66\">false<\/span><span style=\"color: #ABB2BF\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">      <\/span><span style=\"color: #C678DD\">return<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #E5C07B\">five<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">createError<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #E06C75\">httpResult<\/span><span style=\"color: #ABB2BF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  } <\/span><span style=\"color: #C678DD\">catch<\/span><span style=\"color: #ABB2BF\"> (<\/span><span style=\"color: #E06C75\">err<\/span><span style=\"color: #ABB2BF\">) {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">    <\/span><span style=\"color: #E5C07B\">five<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">log<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #E06C75\">err<\/span><span style=\"color: #ABB2BF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #C678DD\">return<\/span><span style=\"color: #ABB2BF\"> <\/span><span style=\"color: #E5C07B\">five<\/span><span style=\"color: #ABB2BF\">.<\/span><span style=\"color: #61AFEF\">success<\/span><span style=\"color: #ABB2BF\">(<\/span><span style=\"color: #E06C75\">result<\/span><span style=\"color: #ABB2BF\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ABB2BF\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">14.7. Click on the <strong>Tick \u2714\ufe0f <\/strong>icon to save your function.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 15: Visual &gt; Forms: Associating a Function with an Event<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">15.1. Navigate to Visual &gt; Forms.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">15.2. Select your Orders form.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">15.3. Go to the Events section.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">15.4. Assign the Slack function to the DoComplete event.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">15.5. Save by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-42-1024x649-1.png\" alt=\"\" class=\"wp-image-3060\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-42-1024x649-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-42-1024x649-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-42-1024x649-1-768x487.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 15.1: Associating the Slack function with the DoComplete event.<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Now, whenever a new order is submitted, your Slack channel will receive a notification. Ensure you replace the webhook URL in the JavaScript function with your own Slack webhook URL for testing<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 16: Applications: Enabling Multiuser Functionality<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To add user management and login features to your app, follow these steps:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">16.1. Click on Applications (My First App) in the top navigation bar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">16.2. Toggle the Multiuser switch to on to enable login and user management features.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">16.3. Save by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-44-1024x650-1.png\" alt=\"\" class=\"wp-image-3061\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-44-1024x650-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-44-1024x650-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-44-1024x650-1-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 16.1: Enabling Multiuser to add login functionality.<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Fourth Checkpoint: First Login<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Run your application again, and you should now see a login screen. Use the default admin credentials (username: admin, password: admin) to log in.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img width=\"1024\" height=\"720\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-45-1024x720-1.png\" alt=\"\" class=\"wp-image-3062\" style=\"width:547px;height:auto\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-45-1024x720-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-45-1024x720-1-300x211.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-45-1024x720-1-768x540.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 17: Setup &gt; User Roles: Configuring Roles and Permissions<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">17.1. Navigate to Setup &gt; Roles to create user roles and permissions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">17.2. Click the yellow Plus icon to add a new role.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">17.3. Enter &#8220;Manager&#8221; into the Name field, select ChartsReports (Charts &amp; Reports) as the Menu, and grant full Create, Read, Update, and Delete permissions for the Default Query Permissions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">17.4. Save by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-46-1024x649-1.png\" alt=\"\" class=\"wp-image-3063\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-46-1024x649-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-46-1024x649-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-46-1024x649-1-768x487.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 17.1: Configuring the Manager user role.<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 18: Setup &gt; Themes: Customizing the Appearance of Your App<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">18.1. Navigate to Setup &gt; Themes to create a new theme.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">18.2. Click the yellow Plus icon.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">18.3. Enter &#8220;MyTheme&#8221; into the Name field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">18.4. Click &#8220;Click to edit theme&#8221; to open the theme editor.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"648\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-47-1024x648-1.png\" alt=\"\" class=\"wp-image-3064\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-47-1024x648-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-47-1024x648-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-47-1024x648-1-768x486.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 18.1: Using Five&#8217;s theme editor to customize your app&#8217;s appearance.<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">18.5. Select Advanced at the top of the theme editor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">18.6. Visit <a href=\"https:\/\/preview-php85.dzine.org\/five\/themes\">Five&#8217;s Themes<\/a>, download your preferred theme, and replace the existing code in the Advanced theme editor with the new theme code.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">18.7. Save the theme by clicking the Tick \u2714\ufe0f icon.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">18.8. Confirm the changes by clicking the Tick \u2714\ufe0f icon again.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 19: Setup &gt; Instances: Applying a Theme and Customizing the UI<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">19.1. Navigate to Setup &gt; Instances to apply a theme to your application.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">19.2. Select the default instance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">19.3. Choose MyTheme from the Theme dropdown. If using Five&#8217;s cloud version (free trial version), stop the deployment first by clicking the Stop \u23f9\ufe0f button in the top right corner.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">19.4. Click the \u270f\ufe0f icon on Logo and select an image or SVG as your logo.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">19.5. Select between the Boston or New York user interfaces under User Interface.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"531\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-49-1024x531-1.png\" alt=\"\" class=\"wp-image-3065\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-49-1024x531-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-49-1024x531-1-300x156.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/image-49-1024x531-1-768x398.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Image 19.1: Setting up Themes, Logos, and UI.<\/em><\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Congratulations: You&#8217;ve Built Your Cloud Web Application<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You&#8217;ve successfully built your first cloud-based application! Recap: you created a database, wrote a query, added forms, charts, and a PDF report, integrated with Slack, added logins and authentication, and customized the front end.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Exploring User Roles<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Try out the Manager role you created. Run your app, log in as a manager, and observe the restricted access. Managers can view charts and reports but not forms, demonstrating the granular permissions Five offers for multi-user apps.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Finding Help in Five<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you encounter any issues, here are some resources to assist you:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Five&#8217;s User Community:<\/strong> Visit <a href=\"https:\/\/five.org\" rel=\"nofollow noopener\" target=\"_blank\">Five.org<\/a> for questions or inspiration from other users.<\/li>\n\n\n\n<li><strong>Five&#8217;s Documentation:<\/strong> Access documentation at <a href=\"https:\/\/help.five.org\" rel=\"nofollow noopener\" target=\"_blank\">help.five.org<\/a>.<\/li>\n\n\n\n<li><strong>Five&#8217;s In-App Help:<\/strong> Utilize the in-app help available in the top right corner or on most fields.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Deploying Your App<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Well done you&#8217;ve completed How to Build a Cloud Application. Deploy your application with unlimited end-users for just US$29.99 per month. This plan includes a custom URL for online access.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/preview-php85.dzine.org\/five\/order-payment\/\"><strong>Subscribe Now<\/strong> to take your application live!<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi and welcome to our step-by-step guide on building your first cloud web application with Five. Goals and Objectives: Build a Cloud Application In this step-by-step tutorial, we&#8217;ll build a cloud application in just 30 minutes. We will: Step 1: Develop a Responsive Cloud-Native Application Step 2: Create a Data Visualization Chart Step 3: Validate [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":3012,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[21],"tags":[],"class_list":["post-3010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"uagb_featured_image_src":{"full":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-How-to-Build-a-Cloud-Application.png",1280,720,false],"thumbnail":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-How-to-Build-a-Cloud-Application-150x150.png",150,150,true],"medium":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-How-to-Build-a-Cloud-Application-300x169.png",300,169,true],"medium_large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-How-to-Build-a-Cloud-Application-768x432.png",768,432,true],"large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-How-to-Build-a-Cloud-Application-1024x576.png",1024,576,true],"1536x1536":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-How-to-Build-a-Cloud-Application.png",1280,720,false],"2048x2048":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/06\/Five.Co-How-to-Build-a-Cloud-Application.png",1280,720,false]},"uagb_author_info":{"display_name":"Ryan Forrester","author_link":"https:\/\/preview-php85.dzine.org\/five\/author\/f1v5_ed9_au\/"},"uagb_comment_info":0,"uagb_excerpt":"Hi and welcome to our step-by-step guide on building your first cloud web application with Five. Goals and Objectives: Build a Cloud Application In this step-by-step tutorial, we&#8217;ll build a cloud application in just 30 minutes. We will: Step 1: Develop a Responsive Cloud-Native Application Step 2: Create a Data Visualization Chart Step 3: Validate&hellip;","_links":{"self":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/3010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/comments?post=3010"}],"version-history":[{"count":0,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/3010\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media\/3012"}],"wp:attachment":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media?parent=3010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/categories?post=3010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/tags?post=3010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}