nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I deal differently with the information of two checklists ?

Hana ha

Hello !

I am using Zapier to extract data from trello and store them in a google spreadsheet. I did 2 different checklists on trello and I would like to have :

- the number of checked items in the 1st checklist in a cell

- the number of checked items in the 2nd checklist in another cell

But I don't know how to dissociate checklists on trello. Indeed, I can have the total of checked items but for all checklists.

So, is there a way to separate data according to the checklists? I tried with 'Code by Zapier' in Python but I didn't know where to start.

I want something like, if the checklist' name is AMO in the card (id:xxxx), then count the nomber of checked items and write it in the spreadsheet.

Also, all my cards will have a checklist named AMO and another one named DECO but the data will be different in these checklists, depending on the card.

If someone have an idea of how I can do that, it would be great. Thank you very much!

Accepted answers

All comments

milynnus

@Hana ha I can almost guess where Zapier gets the values. You would have noticed that card badges for checklist does not differentiate between checklists.

I have developed a generic Butler add-on which returned httpresponse.amo and httpresponse.deco and their values will be the completed count using Butler Http Request.

If you need to gather all these values and write them to spreadsheet, you probably need to do some programming. Can it be done with "Code by Zapier"? I do not know but it can be done with other tools. Most of my work including those above are based on py-trello on Wayscript.

Will check out "Code By Zapier" sounds interesting.

Hana ha

@milynnus Thank you for your quick answer. Indeed, what you wrote is very interesting and seem to be a big step in what I am trying to achieve.

I guess it can be done with 'Code by Zapier', but as I don't have the data I want to work with yet, I can't test it. However it's very useful for many other things

But I am sorry I don't really know what is Wayscript or py-trello... do I have to develop a generic Butler add-on too ?

milynnus

@Hana ha I just sign up to Zapier to take a look at Code by Zapier with Python. To what extent you can embed a py-trello program is unclear. Zapier cautioned that there are runtime and memory limits. What is interesting to me it that it can be using to invoke a request to an external endpoint to GET, PUT, POST stuff. Will try one a bit later. Will keep you posted.

Usually what can be describe simply in words need not mean to automate it is easy. That is why we have zapiers, wayscript, py-trello library....trying to make it simpler for different types of users. The add-on is developed by me to help users who wanted something Butler cannot do.

Let me say, to update a specific cell in Google Sheet is not trivial as there are many cards on the board and you cannot be sure no one moves things around on Google Sheet.

milynnus

@Hana ha Looks like there are real limitations in terms what libraries you can use with Code By Zapier because I cannot get past line 1 which is to get some libraries which will allow my program to be a client to Trello to get the data. Will try call to external endpoint next.

from trello import TrelloClient
client = TrelloClient(
api_key='14a2c67.............1d7',
api_secret='5578....................56027a4',
token='be9...........................cb4',
)
out_dict = {}
for board in client.list_boards():
out_dict[board.name] = board.id
output = out_dict

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

trello

checklist

zapier