I’m looking for a database that integrates with Asana to hold client data. If you have a solution I’d love to hear it. We’re a distributed team of 20 people so it needs to be a cloud solution.

One platform to manage work. With 100+ integrations, you can bring together everything your team needs to communicate, collaborate, and coordinate work, start to finish. For time tracking. Set up project budgets, track hours, and more in Asana. Microsoft Teams. Asana for Windows. Asana’s native desktop app removes distractions so you can focus on what’s important. Just download according to your OS, login with your email on the web, and you’ll be guided to your new favorite app. The Desktop Quick Start Guide gets you up to speed. Download (64-bit) Download (32-bit). Asana supports OAuth 2. Asana handles some of the details of the OAuth flow for you. Create a client using your OAuth Client ID and secret.

The Problem:
Where do you store the client’s name, telephone numbers, web address, email address, address, name of key people from the company and their contact information and a host of other information?

Asana Client Portal

Setting up a Client Template. After I had all my ducks in a row, I opened up Asana and started creating a client template. This client template is set-up for my brand and web design package. Since this is my largest package, it allows me to create a template once and subtract any steps that don’t apply in my smaller packages. Manage Your Client Lists with Asana for Better Results. There are other options that may suit your business better, but ideally, what a client management system in Asana will do is free you from the burden of tracking down client information in emails, notepads, and a variety of other platforms through which your team communicates.

Asana custom fields as the solution:
To me, this is like saying that a professional chef should simply use one of the blades on a swiss army knife for cook prep – while it may work you’re sacrificing when you shouldn’t. The simple truth is that Asana’s custom fields aren’t implemented in a way they should be for this use. If you could switch between a form and list (spreadsheet) view, show them all on one page, do complex sorting and filtering, etc. then it would make sense. As they are currently implemented, it’s a kludge at best. Furthermore, you need a one-to-many relationship so that contacts are attached to a company and projects to a company. Right now you have to create a separate project and call is a database of your clients with no way to attach these to your projects.

Background and the issue:
We’ve been using Asana as a project management tool for years and just upgraded to the Premium version but I find the program still lacking some VERY basic features. We started with Basecamp (and still use it for client communication), moved to Trello and finally to Asana but no matter which project management tool we use, they are ALL missing this one basic feature – client data.

Thoughts/Suggestions?
Anyone have a solution they’re using OTHER than Google Sheets, Excel, etc. that doesn’t cost a fortune? I tried Airtable but found it to be terrible. Ideally, a solution which could handle client communication as well would be wonderful. Most CRM applications are focused more on the sales pipe rather than taking care of current clients so the ones I’ve tested have never worked well.

Asana Client Access

Asana Client

Ideas anyone?