I would love to build an app that allows us to create estimates from our own database of items and then side load it to the android tablets in all of our trucks.
I know I could build it with a web page using our mysql database but I’ve never made and app. This would be a perfect project for me to learn.
It sounds like you want to have both a web app for users in the office and a mobile app for the trucks.
This is totally possible with Wappler. You’ll want to create two projects if you don’t already have the application build for the mysql database you mentioned.
Create a Web project.
This will be where you most of the logic for your app will live (users, authentication, tables related to estimates, etc.)
Create a mobile project.
This will allow you to connect to the remote web project for authentication and loading/modifying data from different tables from the web project’s database.
If you already have the application built and only want to create a mobile app, then this is possible as well as long as your existing application exposes APIs.
If you want to get fancy you could add a SQLite database to the mobile project and sync data by using the Action Scheduler to periodically look for new data. You can also do this with the most recent CouchDB and PouchDB component as well. Just a word of caution, I ran into memory issues using PouchDB, so it may not be ready for production use yet.