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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.