Hi all,
Has anyone managed to do this?
Specifically after mirroring a custom date field when its changed from child to parent or parent to child if either is updated.
Thanks in advance!
@Keith Hmm I tried this but it doesn't work:
when custom field "Mobile Number" is set, find the first card linked in the attachments, lookup a card with link "{triggercardlink}", and set custom field "Mobile Number" to "{{%Mobile Number}}
I thought that you might be able to look up the card to get a reference to the custom fields on it and set the value on the found card but doesn't look like it.
This Trellinator function will do it:
https://gist.github.com/iaindooley/a4c37292a1db16ddf5d40afdf136ca7c
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
thanks I'll give Trellinator a go
looks like i've hit a rate limit. Can I control this?
And I've noticed a lot of updates, can we tweak this?
In a day I've gone through all of my monthly allotted Trello "command runs"
@Keith hey, congrats on getting it set up regarding the updates I think the issue might be that the cards are reciprocally linked, so each time it updates one it updates the linked card and then goes around again, you can trigger only when it's not the Trellinator user that updates, here's a tweaked version:
However if you set this up under your own Trello api key/token that would preclude it from working when you change also. That "notTrellinator()" method is most useful when you have created a separate bot account.
Regarding the rate limit, you might find that once you add the "notTrellinator()" call you don't hit the limit anymore, but if you do then you can always just put a:
Utilities.sleep(1000);
in. I sometimes have to do that if I'm running a thing that, for example, imports a spreadsheet into custom fields because the custom fields API is so HTTP API call heavy.
If you have Butler commands triggered on custom field updates then having the thing bounce back and forth between reciprocally linked cards is probably what caused that, if you prevent it from triggering when Trellinator makes the change, that'll stop it from exhausting your Butler commands. Note, though that Trellinator isn't constrained by the same Butler quotas, it's only constrained by Google Apps Script execution quotas (which are very very large by comparison) and the API rate limits which are pretty generous; I rarely run into them unless I'm doing the aforementioned spreadsheet import.
Sorry I should probably have grokked that you were going to have reciprocally linked cards and realised that the code needed to avoid triggering itself
It looks like you're new here. Sign in or register to get started.
