Speaker 1: In this video, I'll create a web-based data management system in under 10 minutes. And as a starting point, I have data tables for customer data, product data, and sales forecast data. I'll give our employees a way to securely access and manage this data using web applications. And we'll wrap all that up into a data management portal, all in about 10 minutes. Of course, if you have any questions about any part of this process, leave a comment below the video and I'll answer it. Sound good? All right, let's get started. I'll be using our low-code development platform, Empower, as it simplifies the process. Let's get right into it. I already have data in some database tables, and I'm using MySQL, but you can really use any type of relational database. I'm just using MySQL today. So what I want to do is create web apps over some of these tables to maintain this data. And I'll start with the customer data. I'll just need to give this application a name and choose a template. And a template provides the basic layout and features for the app, but can still be customized however you want later on. Now I'll just need to choose my database table, which in this case is the customer table, and select the fields I want to include. So moving right along, I now just need to tell Empower how to sort this data. And I'll sort this data by customer number and move on. So now I'm pretty much done. Sure, I could do more to this, like add calculated fields, filters, custom logic, and really much more, but I don't need to do that this time, so I'll just go ahead and build it. Now I just showed you a very basic build process, but there's so much more I could do. In fact, I could add custom code, call APIs, or even dive in and edit at the code level. There's no limit to what you can do here. I'm just making a basic application for sake of time. Okay, so it's built now. Let's check it out. It's pulling directly from the customer database table and displaying everything here. It has some nice features built in too, like pagination up here, sorting, filtering. I can even add new records to my database table if I'd like, or edit existing records. If I were to make any changes to this form, it would update the database. Now one thing, I'm not in love with this form layout here, and I'd like to change it. I'll dive into mPainter, which is where I'd customize this application. I can customize any aspect of this, even at the code level if necessary, but I just need to change this form. So I'll open up the form designer and make some changes. Now the form designer is a really simple way to edit your forms. I can move fields around, remove fields, or add fields. Once I'm done, I'll just save this and go back into my application and load that form again. There, it looks much better now. So let's say I need to edit this customer's data. I'll make a change, save the form, and then you'll see it now appears in my database table. So that's the first application in my data management system. For this video, I'll just create a couple more, one for products and one for sales forecasts. But creating those is the exact same process as you just saw, just over different database tables. I won't walk you through those because it would be repetitive. I'll just create them in the background and skip ahead. There, now we have three different web apps to manage different database tables, and this is nice. I can now give these to employees who are responsible for managing this data. But there are a couple things I need to do to make this better. First I need security. I don't want just anyone being able to change my database tables, right? So I've just enabled security, and now I'm adding a few users. This will ensure that my applications are behind a login form and cannot be accessed by anyone who isn't one of these users that I've set up. There's a lot more I could do with security. For instance, I could add multi-tenant security so users can access the same application yet only see data they're authorized to see. Or I could secure it by individual application and much more, really. Okay, so now I have some users in here. Let's pull up one of these applications. As you can see, I'm now forced to log in using one of the users that I set up. Okay, so that's good. Now only users that I've authorized can make database changes. But I could still make this better. I'd like to put all of these applications in a portal. That way, I don't need to send different URLs to my users. I can just send them to the portal and access everything. And then, even better, I can easily add more applications to this portal later on. Okay, so I just set up one of my portal options. And I'm going to set up the other two in the background as it's the exact same process and then skip ahead. Alright, so I just added these applications to my portal. And you may have noticed that I assigned each application to specific roles. That means that only users with those roles can see that option in the portal. I'll just add roles to my users here to specify who can access which ones. So now I have my portal set up and my user roles assigned. Let's log in as an admin first to show you what it looks like. You'll see that I have all of my options to manage different database tables. Okay, so that works as it should. Now let's log out and log in as the sales manager. Now you see that I can only manage the sales forecast data and customer data. And that's what I want. And finally, if we log in as the product director here, I can only manage the product data. Okay, so there we have it. I've created a basic web-based data management system in under 10 minutes. I can maintain different database tables which are easily accessible in a data management portal and even have security to make sure that only specific users can get in. And this works as it should, but really I'm just scratching the surface here. There's so much more I could do. I mean, I could add workflow processes, join tables or applications together, add custom logic, customize these applications in any way, and really so much more. But for sake of time, I won't do any of that in this video. If you'd like to see more or just set up a demo, visit us on the web at mrc-predictivity.com. Thanks for watching.