I’m fairly new with Glide and have no prior programming experience. I’m trying to set up an app to be used within our company for keeping track of inventory.
I set up data tables with the info, now i want to build a workflow where if an item in the inventory drops below a certain value, a new row will be created in the orders tab with the item that would need to be ordered. Also an email/notification will be sent to user/admin. Is this possible? If yes, how? i asked the AI to help me but it kept giving me triggers that weren’t available.
Hello, welcome to the Glide community, you can explore some inventory templates already available and make small changes according to your needs, you will need an explorer account or a more advanced one according to your needs.
In the case that you are detailing, you can create a column that indicates the minimum quantity and then create an if column validating if the current quantity is above the minimum quantity, once you can achieve this, you can return to the community or inquire on yt about how to create a pdf and send the email you need.
Yes, definitely possible. Here’s how I would set it up:
In your table of unique inventory, create a minimum threshold column.
I assume that you have some sort of action that will allow you to edit your current quantity? Or perhaps you have a transaction table that’s keeping a log of your inventory changes? Regardless, you’re gonna have some sort of number that indicates your current quantity in an action that lets you adjust that number.
Once that action has been completed, you will need a follow up action that compares the current quantity to your minimum threshold. (there’s a few ways to do this depending upon your set up).
You can tie any sort of communication or integration to that action. (send an email, send a Slack message, etc.).
It would be helpful to know where and how you are tracking your current inventory. Can you give us a bit more detail?
Thank you for your reply.
Currently i have a data table with a column of the current amount in inventory. In the layout i have an inventory tab and when clicked on the product there is an edit button to edit the amoun in inventory. I want to build in some kind of automation for this too. Something like scan qr code of product and enter the value or maybe even when scanned that the amount drops by 1.
i haven’t figured that out yet.
I did add a column for the minimum threshold. And i added a scheduled workflow with a conditional workflow. if amount is equal or lower than threshold → add row in “orders” tab and send email. This seems to be working now