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.