Cards automation from Zapier

Brazilian Bakery Cafe

I started importing data from a FORMS app into trello using zapier. The data is basically a customer order of food for a specific date and time. 

Scenario 1) I imagine my trello board being composed of the following boards: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, Following Weeks. Is there any way for me to import the card speficially to any of these cards automatically? Specially the "Following Weeks". 

Scenario 2) There are no boards on Trello, but as soon as an order is received with a specific date a card/board would be created and if more than one card are created for the same day they would just stack on the same board with the WEEKDAY showing on the top. Basically creating a infinite number of boards (I would just have to archive older boards or automate that). Eliminating this way the board "Following weeks" from scenario 1.

 

Mike - Dreamsuite Consulting

Just a quick summary of Trello Hierarchy

 

Workspace contains...

      Boards, which contain

               Lists, which contain 

                     Cards, which contain

                             Checklists

 

Scenario 1)  So for  this I think you are talking about having 1 Trello board where you have lists titled Monday, Tuesday, Wednesday and so on... In terms of using Zapier, so long as you have some kind of indicator from your form being imported in the card on Trello, you can use automation to post-process it to the correct list.  In Zapier the date field could link either to a date custom field in Trello or the Trello due date.  The automation would work as, when a card with due date set is added to the board, move the card to {cardduedate~dddd}.  Take a look at this help to explain why you need the ~dddd part:

Arithmetic and formatting in date variables | Trello | Atlassian Support

 

Scenario 2) I think you are talking about cards, where 1 submission on your form creates a new card, which routes to the correct list for day of the week.  You could use automation to manage the flow of cards to the correct day of the week on a week by week basis. So you could add cards that aren't due this week to a queue.  You could set a scheduled automation to run on Sunday night that clears down that weeks cards from the lists and places all of the cards due the following week into the correct list.  

 

 

One thing to consider is whether you can use the power or Trello to set the board up in a workflow style, so instead of having the days of the week you could set your lists like:

New Order > Order Accepted > Preparing > Boxing > Delivery

You can use due dates, labels and filters to be able to set up views that would give you the same information as you have by doing the lists based on days of the week. It is definitely worth considering.  I find Trello works best when things are moving through a process