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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

How can I extract checklists items names in trello ? Edited

Hello, 

I am using zapier in order to extract data from trello cards and store them in a googlesheet spreadsheet.

I mostly used regular expressions and it works very well, but one thing remains complicated for me. I'm trying to get the names of the checked items on a checklist. The only things I can use seem to be : 

 

- check item states

- ID checklists

- badge check items

- badge check items checked

I used the last two, but I'd really like the name of those items and not the total number.

By any chance, do you know how I can do that ? 

If what I am saying is not clear, don't hesitate to ask me!

 

Thank you very much for your help !

 

 

 

 

1 answer

1 accepted

0 votes
Answer accepted
Iain Dooley Community Leader Aug 17, 2020

@Hana ha when you get the check item states, does it return the item ids or item names along with the state? 

@Iain Dooley  thank you for your answer. When I try to get the check item states it just says 'no data' and nothing is returned. But I have 5 items checked though...

Iain Dooley Community Leader Aug 18, 2020

@Hana ha hmmm I don't know how else you would do it in Zapier. This Trellinator function would append a row to a spreadsheet whenever a card is moved to the "Export" list with a link to the card, its name and a list of all checklists on the card along with their completed items:

https://gist.github.com/iaindooley/4682199a988a330cf77b85e734f21930

You can read more about Trellinator here:

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

Thank you very much @Iain Dooley , I will try with Trellinator !

Like Iain Dooley likes this
Iain Dooley Community Leader Aug 19, 2020

@Hana ha cool free to ask if you have any questions, you can see lots of examples here:

https://gist.github.com/iaindooley

and more docs here:

http://docs.trellinator.com/

Suggest an answer

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

📹 What is Trello?

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...

836 views 14 30
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