Inventory Tracking

Question

I have inventory that leaves our warehouse, goes on a job site, and then returns. I have a trello card per inventory item. I would like to track how many days an item is out of our warehouse. I have a custom field named "Location" where I put the job site name when the item is out and "warehouse" if the item is in. Any ideas? I have about 2500 inventory items.

Sarrah Saunders · Answer

Thank you, @Mike - Dreamsuite Consulting . That would be helpful; although, each list is a package, so I need the cards to stay within the package for selection/design purposes. I have 10 boards (each a package type) with about 25 lists/packages each, so having cards separate out of their package would create too much chaos.

Mike - Dreamsuite Consulting · Answer

Hi @Sarrah Saunders

Create a list called "Booked Out" (change the name to what works for you).

Create a custom field called "Time Booked Out"

Have the following automations

Automation 1 - When location is set to anything other than warehouse

When custom field "Location" is set to "regex:^((?!Warehouse).)*$/", move the card to "Booked Out"

Automation 2 -When location is set to warehouse, move to list Warehouse and log time

When custom field "Location is set to "Warehouse", set custom field  "Time Booked Out" to {cardhoursinlist} and move the card to list "Warehouse"

Note, you can also use {cardminutesinlist}.  If you want days, you can do ({cardhoursinlist} / 24)