Hi everyone!
Started using Glide a few weeks ago to make a storage management system for my employer. It’s working quite well, but I have some challenges I was wondering if you could help me address.
I have a large Google Sheet that functions as the database. Here I have all positions pallets and boxes can be stored in our facility. Then with the app I can add information, pictures, order# etc. I have built actions to move items between positions, delete items, and create items.
Now I am making a system for automatic creation of Pallet Labels. I have made a Python script with a freelancer, and with Zapier we can automatically generate several Pallet Labels in one go, and have all of them be sent as a PDF file to a certain e-mail.
However, the way I was thinking to solve this was having an own Checklist page in the Glide App, where the user checks all the items they need PalletLabels for. Whenever the user checks an item, it would check the “Print?” Column in the Google Sheet.
What I would like, is whenever they press the “Print” -button, it would activate an action checking for all checked rows in the Google Sheet, and copying some of the column data into a temporary table. Then this table could be linked to Zapier, and “Copy all rows” can be used to send the data to Python for Pallet Label creation.
Is this a bad way of doing it? Any help or recommendations would be much appreciated!
