Help

Automation question regarding Inventory Tracking

Topic Labels: Automations Data Formulas
479 1
cancel
Showing results for 
Search instead for 
Did you mean: 
krtphr
6 - Interface Innovator
6 - Interface Innovator

Hello,

Was curious if it was possible to set an automation to basically trigger an email if inventory is based on a % of x being low, rather than an exact number?

QTY = < %

So if I have 1000 labels, and I'm running low, and already utilized 50% of that, I'm sent an alert. Is that possible? I may have overlooked the automations, but I couldn't figure out how to submit a "%" in the conditions for "QTY" rather than an exact number.

Thanks for all the help!

1 Reply 1

Hm, could you create a new field called "Original amount" or something where you put in the value of "1000", and then create a formula field with the formula `QTY / Original amount * 100` to get the percentage, and trigger your automation off of that?