Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Cards automation from Zapier

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.

 

1 answer

0 votes
Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Feb 23, 2023

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events