Adding to Inventory

skarkhoff

I'm sure this is simple, but I've searched for a while and haven't found anything similar! 

I have a sheet set up to track each piece of marketing collateral.  It starts w/ the beginning quantity (say 100 pieces) and deducts the number of pieces that have been requested (through a SS form on another sheet), then another column calculates the quantity remaining.

I have a notification set up to our marketing team to reorder each item once it reaches a certain threshold, but is there a way to send either the marketing team or vendor an update request to input the total amount ordered, and have that amount automatically added to the current inventory available?

Paul Newcome

You could create a second form either on the first sheet or a different sheet for ordering. Then you could just use a SUMIFS to figure out how many piece have been requested and subtract that from a SUMIFS to figure out how many have been ordered.

 

If the forms are on the same sheet, you could use a hidden field with a default value to specify whether it is a request or an order.

 

In the message body of the Low Level Alert, you would just include the link to the order form.

Paul Newcome

Happy to help! 👍️

Paul Newcome

You could create a second form either on the first sheet or a different sheet for ordering. Then you could just use a SUMIFS to figure out how many piece have been requested and subtract that from a SUMIFS to figure out how many have been ordered.

 

If the forms are on the same sheet, you could use a hidden field with a default value to specify whether it is a request or an order.

 

In the message body of the Low Level Alert, you would just include the link to the order form.

skarkhoff

thank you!

Paul Newcome

Happy to help! 👍️