How to automate the connections between two cards?

[Patrick Eissler]

Hi atlassian-forum,

Situation: 

• One Board that includes all products
• Another Board that includes all suppliers
• Each product has several suppliers and each supplier supplies several products

Goal: 

• Link each product to its respective suppliers
• Link each supplier to its respective products

Problem: 

• How can you do this in an automated way such that only on the cards of the product board the supplier cards of the supplier board are attached manually and then the product cards are automatically attached to the supplier that was attached to that product.
• This saves time and is more flexible to future changes (deleting or adding a supplier to a product should be considered on the respective supplier cards as well)

My qestion: Is there any add-on that solves that problem? I checked 1 or two mirroring apps and tried to build a butler rule, but it didnt work out so far. 

I am thankful for any help :)

Regards,
Patrick

[Dima_D]

Thank you so much Again! 

Here are screenshots. first is original. Second is english variant of the error message. 

[Iain Dooley]

@Dima_D that is really strange. The "app" in question is just a script inside your own Google account. Are you opening the script editor and choosing Publish -> Deploy as Web App? You made a copy of the spreadsheet right? Are you able to use any other Google Apps Script projects? Because the way Trellinator works is that you're just copying a spreadsheet along with code, then deploying it within your own account. I get a warning when I do it from a free Gmail account, but it lets me choose "Advanced" in the bottom left and then proceed. When I do it from G-Suite I see no warnings.

If possible, can you do a complete screencast using useloom.com or something similar of you running through the entire setup? I don't see how else I can troubleshoot this with you because I've not heard of this issue before sorry.

[Dima_D]

Thank you!

I will experiment with fresh google account, with paid account, will install useloom, make video.

also will use another laptops with windows and Linux (currently Os X).

will be back with full report.

Thanks again!

[Iain Dooley]

@Patrick Eissler You won't be able to do this with Butler, but here's a Trellinator function that would do what you're after:

https://gist.github.com/iaindooley/0e810a4625865d9f13b86878a8641b42

The Trellinator user would need to be a member of both boards, and you'd install the above function on the Products board. When you add an item to a checklist named "Suppliers", it will find a card containing that name on the Suppliers board, replace the checklist item text with a link to that supplier card, then add a link to the Product card into a "Products" checklist on the supplier card (unless it already exists).

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

[Dima_D]

As per description it really great solution, but  when I try to Initialize utilities I have to give permissions to App, and then I receive notification "sign in with Google is temporarily disabled for that app. This ass has not yet been verified yes with Googe..." Same warning I receive when I publish script as an app.... 

Am I the only one who, can not use that solution, i wonder? Maybe some fix is needed? 

[Iain Dooley]

@Dima_D I think the issue is that you're doing this from a free Gmail account, so it gives you the "app unverified" warning (even though technically this is an app that you're creating for yourself).

You just need to lick "Advanced" and "Proceed" in the bottom left.

If you do the setup from a paid G-Suite account you don't see that error.

[Dima_D]

Thank you for your help and consideration!!!

Unfortunately there is no ADVANCED links or any other links - just this warning in a window without any further actions possible :-(.... I think that using free gmail account is quite normal, a lot of other apps work with this account without any issues.... Any other ways to solve? :-) 

[Iain Dooley]

@Dima_D can you post a screenshot of the message you're seeing? I tested setting it up with a free Gmail account after your last message and it worked fine. The only problem with free accounts is the quotas are much lower than paid, and when you run out of quota for the day everything stops working. But if you're not that high volume it's not an issue, you can use it. Well, should be able to anyway ... I set it up in a brand new free gmail account under which I've never set it up before with no hassles, so I can't see why it'd be an issue for yours.

[Patrick Eissler]

@Iain Dooley Thank you very much for the help and the quick response :) Now I finally can come back to that topic. 

Do you know if a similiar solution is possible: I already attached the respective suppliers (as trello card attachments) to all products. Working with checklist would unfortunately have a worse usability and would be a lot of work in advance, while I already have the trello cards attached.

So I wonder if your solution is possible with trello card attachments instead of checklists. I would be thankful for hints as well. I already checked the devlopers page, but I am not really experienced in coding. But I might give it a try once I understood the main characteristics and where to add the code.

Regards,
Patrick

[Iain Dooley]

@Patrick Eissler if you already have suppliers attached to products as card attachments, this function would loop through all product cards and add a reciprocal link back the other way:

https://gist.github.com/iaindooley/2ab9763fcd9fe39574877bd0749a7772

[Iain Dooley]

@Patrick Eissler also note that if you want me to work this out for you I can, it's pretty cheap if you can spec your functions similar to Butler commands, link is in my bio.