Usually we have people fill out a Google Form, that info goes into a Google Spreadsheet, and that info automatically makes a card in Trello.
Now they have stopped uploading to Trello. I'm not sure where the connection got lost. Can anyone help?
@Bailey Brown when you write stuff to a Google Sheet, it's added to Trello either via a trigger in Google Apps Script, or by some other automation such as Zapier.
Do you know which automation was being used to create the Trello cards?
I believe it is a trigger. It has to be considered a "new row" in Google Sheets. It happened before and my colleague had said something about the color formatting?? I'm just not sure what that means or how to fix it.
@Bailey Brown well if it's a trigger that was running in Google Apps Script, then it's probably a form submit trigger. These do spontaneously disappear from time to time, and it's a bug that has been causing frustration in the Google Apps Script community for the past 6 years. You can check by opening your spreadsheet and going to Tools -> Script Editor, then you need to look at the project triggers. You will either see the old style editor like this:
Or the new style editor like this:
If you don't see any triggers, then nothing is going to happen when your form is submitted. If you see a trigger, then it should be calling a function, and might show you some errors.
If you don't see the error, then you need to create it again and choose which function to run (there should be a function in the script editor for creating the Trello cards from form submissions) or you'll need to figure out how to fix it.
I can't really do much more than that in this forum, but this is also a service I offer professionally so if you'd like me to fix it for you you can email me on team@benkoworks.com
@Iain Dooley I appreciate this very much! However, when I go to the Script editor, it says that I do not have access to the file so nothing will load. Is there a way to fix this?
It looks like you're new here. Sign in or register to get started.
