It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Organizing inventory for rentals

Hi Trello Community :)

 

So - I'm looking for a power-up, where i can manage my rentals

 

This might in some sort of calendar view, but i'm open for suggestions.

Lets say i have 250 of a specific item - 100 of them are rented out from a given date to a given date - Then another customer wants to rent 175 items in the same period - I need to see that its not in stock, and see how many items i can rent to customers in that given period.

Don't know if my example makes sense, but ask me, and i'll try to be more spcific

 

Regards

 

Dan 

1 answer

0 votes
Iain Dooley Community Leader Oct 02, 2019

@Dan Andersen I don't know of any power up but here's how I would design the system:

1) One board is your stock control board, you have one list per item type, one card per item, each item has a due date set on when it will become available

2) Another board is your orders board, you create one card per customer order. This card has custom fields for start and end date of rental, and another custom field for desired amount

3) An API automation then loops through all cards in the stock board to find any cards that either have no due date (not rented out) or those that have a date that falls due within that period, giving you the total that will become available during that period AND then another figure which is the total available at the *start* of that period.

This automation wouldn't be something you could create with Butler, but you could create it with Trellinator which would be simpler and cheaper than coding the API calls directly:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,499 views 12 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you