Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to move incomplete checklist items to another checklist using a trigger?

Lilia October 4, 2019

For each week, I have 7 checklists where I put daily to-dos.

Is there a way to automatically move the incomplete checklist items to the "next day" to-dos checklist?

1 answer

1 accepted

0 votes
Answer accepted
Iain Dooley
Community Champion
October 5, 2019

@Lilia this Trellinator function would move all incomplete checklist items from a checklist named with yesterday's day name to a checklist with today's day name on a card called "My ToDos" on a board called "Your Board" (update the name in the init() function before calling it):

https://gist.github.com/iaindooley/aa06c086b38360196764b927682fc241

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

Once you install it you can run the init() function from the script editor and thereafter it will execute daily at 5am.

Deleted user October 11, 2019

I got this error when it started to initialize the sheets:

["Getting Trello member ID invalid token","Webhook registration failed - HTTP:401:invalid key","Trellinator Initialization SyntaxError: Unexpected token: i"]

Iain Dooley
Community Champion
October 12, 2019

@Lilia hmm looks like the key/token aren't entered correctly in the Configuration tab

Deleted user October 12, 2019

I tried to generate and enter the token a few times but got the same error every time. What do you mean by entered correctly? I entered the token in the correct spreadsheet cell.

Iain Dooley
Community Champion
October 12, 2019

@[deleted] the error seems to suggest differently. The first error says that the token is invalid when fetching the member ID, then it's failing to register the webhook with "invalid key" then the last error shows that it's trying to parse a JSON response and getting a syntax error, unexpected token "i" presumably that's because the response is "invalid token". So my diagnosis here is that the api key and token aren't in the correct cells in the configuration sheet.

Lilia October 12, 2019

Ah sorry, I missed the key. It works now. Thanks.

Like Iain Dooley likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events