A couple of years ago (before Tulip Tables had fully launched), I build an inventory system for The Public Radio using Tulip, Google Sheets, and an awkward cron task. It worked, but it’s been neglected (having multiple systems stitched together was annoying to maintain) and now that Tulip Tables are public, I’d like to port the whole thing over.
Using the guide that @kevin.kononenko wrote here, I set up a quick inventory app with a single table and a few different methods of interacting in the app. Users can receive new inventory via a form step, or edit the quantity on hand by typing in an accurate part count, or remove kits from inventory (one of part X, three of part Y - a default configuration based on the way our assembly process works) via a single button. It’s all very ugly to interact with, but it works perfectly well and can easily be integrated into our broader system.
My question is: Our contract manufacturer uses physical kanban cards for inventory alerts, which is great but doesn’t give me real time visibility from my office. I’d rather not check our inventory dashboard manually, so I’m hoping to set up automated email alerts to tell me when stock gets below some critical level.
I can do this in the app itself by checking on completion whether any table record’s “quantity on hand” number is less than its “threshold” number, but we have a couple different apps that will access the table and I’d prefer to set the alerts up globally and then not have to remember which app touches which part of inventory.
Is it possible to set up email alerts directly from tables? Or perhaps better yet, can I set up a webhook that fires anytime a row’s “quantity on hand” number is less than its “threshold” number and then use it in, for example, a Zapier trigger?