Hello, I found the way to make a Glide application, totally with data obtained from a Mysql database.
I wanted to know if any of you are working on something similar to share experiences.
The use case is an application that sends orders by WhatsApp for a company that has a wholesale distribution of food, with 10 sellers and about 250 orders per day, we will have prices updated in real time. (Argentina, changes the prices of products almost weekly)
In a second stage we will visualize the current accounts, which are integrated into the app-
And the improvement in the future is to be able to work with the stock in real time.
It opens up a lot of opportunities to be able to work with most of the management systems and platforms.
I have worked on a warehouse management system for a company whose core ERP is SAP.
Their complete data lives on MySQL
I am pulling that data using a JDBC connection into a spreadsheet and then using a GlideApp for warehouse management.
Thanks for your answer.
In my case it also serves me periodically.
In the future I have a case where we will carry the stock in real time, it is impossible for me to update with each modification, since there will be about 2500/3000 per day.
So I’m thinking of making a virtual stock in the app.
since it is the only means of sale, it will be reflected as they sell.
As I use a specific user column and it does not write to me in the Google sheets I am trying to do it in the data with the new functions.
I’m trying to do it right now
Yeah I did have this requirement and hence I maintained a separate stock in my Google Sheet with some adjustments but if you find a better way, I would love to know it.
Copying user specific columns to Google sheets is now possible using the new compound actions. You can use the user profile sheet and “set columns” action in any click through your app which automatically transfers all user specific columns in your Google Sheet.