Project Requests

Lewis Turner_862wn7

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

Iain Dooley

@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 -Collabello--Phase Locked- 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.