It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Project Requests

I am using trello to track request's from internal clients and can see that you can e-mail a card in. 

Is there a way i can set up a request form and then users would input there request into this, hit complete, and automatically create a card in my board, in my "Ice-Box" (Unopened requests) list?

 

Thanks

L

2 answers

1 accepted

1 vote
Answer accepted
Iain Dooley Community Leader Mar 06, 2019

@Lewis Turner one option would be to have your request form in Google Forms, and set it to wrote the response to a sheet.

You can then set up a trigger in the sheet to execute a function "onEdit" (ie. when a new row is appended to the sheet) to create the card in the required list via the Trello API.

I've created an open source framework for automating Trello with Google Apps Script you can read more about here, that would make it pretty simple to set this automation up from a Google Sheet:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

Alternatively, as @marc said you could use a tool like Zapier to achieve this. Zapier's major downfall is immediacy -- even on their highest paid plan you have to wait 5 minutes for Zaps to run, but on their starter plan it takes 15 mins so getting things to run quickly can be a real hassle.

The way to get around this with Zapier is to use either their webhook or email parsers, both of which cause zaps to be executed instantly. Most form creation tools will allow you to deliver notifications of new form entries either as emails or to a webhook end point, so you can plug this into Zapier, extract the output you want, then create a card in Trello.

Depending on the volume of requests you're expecting, you might find that you can get away with Zapier's free plan and still get instantaneous execution.

Hi @Iain Dooley Thanks! I done it through google forms as you stated with a onFormSumbit trigger.

 

I'm having an issue with it though which i posted on stackoverflow, is this something you could help with as well?

Trello is creating 2 cards off the back of it and i cant figure out why?

 

https://stackoverflow.com/questions/55059940/google-scripts-e-mail-showing-2-trello-cards

Iain Dooley Community Leader Mar 08, 2019

@Lewis Turner weird ... not sure why it would be triggering twice, but you could just validate the data and only send the email if it's got some content in it.

@Iain Dooley  any advice on where/ how to start with that?

0 votes
marc Community Leader Mar 06, 2019

@Lewis Turneryes, that is possible with e.g zapier.  I'm also working on a power-up which can do this.  Would love to talk about your use case, you can contact me through the link in my profile.

Hi @marc 

I looked into Zapier first but there website wouldn't work for me. Don't know if there are issues going on but I need a reliable connection and whenever I tried to set up a Zap I would get stuck on a loading screen or would give me a webiste error. Left it for a few days and tried again thinking the issues would be fixed but i got the same result. 

I have done it through google API script.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,499 views 12 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you