Anyone know of a software that Trello can integrate with that allows customers to log into a dashboard to track their order status. We use trello for custom sports clothing production order management and we really need somewhere where customers can login and be given some form of status of their custom order. The order status could even be the title of the List Name and we drag each card(order) down the list as it enter different stages of production which would then update the status of the job in the customer dashboard. Anyone got any thoughts? Maybe Zapier might integrate trello with a particular platform?
@Cam Donald If you're dealing with custom orders, I assume this is not going to be a particularly high traffic web application. As such, a web page deployed using Google Apps Script and integrated with Trello using Trellinator might be suitable. You can read about Trellinator here:
By default, Trellinator doesn't respond to GET requests (ie. if someone just hits the URL) but I've used it for a couple of applications where I wanted people to be able to provide some input and get some basic info out. You can make it look nice, but the only constraint is that it will not cope with more than about 5 concurrent connections so if you have hundreds of customers looking per hour you might find some performance problems.
For example you could present a form that allows people to enter their email and order number in order to get some status info about what's going on in the board.
Another option would be to send email updates directly from the Trello cards, you could use Butler to trigger emails to Zapier. When I do this, I email Zapier's email parser with some structured data, then use Gmail to forward on a properly formatted email:
You could also use my product BenkoDesk, combined with Butler (or Trellinator) to automate emails out to customers with status updates, this would mean that you could also receive replies directly inside Trello and continue the conversation there:
SendBoard also allows you to do shared email in Trello:
Thanks mate, awesome answer. !!
I know a little bit of coding but really want to capitalise on the google apps script. The whole enter order number and email thing sounds good! Is this something you could help with if I email you directly if you have time or maybe there are some good templates out there you know of?
@Cam Donald thanks for accepting my answer and earned me a badge 😊. I had a second look at your question and I think I have a simple enough solution way for you. Wayscript has a Trello module that can search a board. It has a form module where you can accept the query. You can then feed it to that Trello module and return the results via an email. Will prototype it tomorrow. It is similar to the search you do on the board and I used the same using py-Trello in my bot.
Sounds awesome thanks mate! I doing my best to understand your solution haha but it sounds workable! I think I may add one quick thing to my original needs, which is if a customer was to "login" so to speak, would be nice if they could someone see all the jobs associated to them via some form of meta field associated to the job and the customer which pairs them. Maybe this might influence someone to build their own power up as this would be quick handy for a lot of people I imagine ;) ;).
Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristjan Geir Mathiesen - Origo for sharing the picture of Taco having fun with his new friend...
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