I’m considering using Xojo for a driver’s module I need for our company. It will hold basically all the orders they will deliver and they will scan the labels that apply for that order. We currently have all our data in SQL Server 2022 on premise.
My thought process is to create a mobile app that will have a SQLlite database that will hold the sub set of data that they’ll use. They will come to the shop early morning have a button in the app and download the info they need from the on premise SQL DB to SQLlite on their phone.
They will basically scan an update three fields: delivered, driver_name,timestamp. They might take pictures when dropping off an order when there’s no one on the delivery site to accept it. Once they get back to the shop they will press a button and this will update those three fields and add any pictures related to that order to the drop_photos table that’s already created in my SQL DB. This will clear out all the information for the day and rinse and repeat next morning.
Since I’ve never used Xojo before I was wondering if this is something that can be accomplished. My experience is in Visual Basic and SQL Server so I think Xojo would be a great fit for me.
Thank you for any recommendations/suggestions