You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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 !
@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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.