Hey everybody, I was thrilled about Custom Fields being added, and have been utilizing them (it’s what prompted me to bump up to Premium). The problem I’m having is that none of the integrations I’m using or have looked at take Custom Fields into account (not even Zapier!). Is this because it’s such a recent feature?
In any event, I want to be able to run reports based on custom fields without fiddling with Google Sheets (if I can avoid that). Specific examples of what I want to be able to visualize:
I ended up doing my custom field sorts via Search, requesting a CSV file, then uploading it into a google sheet, and creating charts from there. I had to figure out how to use charts but it was worth my while.
Hey, @hafidha, I just wanted to drop a note to say that there are a few integrations that are using our custom fields - Unito was a launch partner who tied Asana to Github - but you’re correct, that the newness of the feature is why they’re not quite built into many other integrations. On the bright side, many of them are actively working to get them implemented. Zapier is one of them, so keep an eye out for when they get that built!
Hi @Edwin_Rooijakkers. There’s a solution for this! It’s the same functionality as the “[#] task name” hack. Just add a custom field with a numerical value. Multi select the tasks and it will show you the numerical total of all the custom fields.
Quick update here – I just spent 2 days setting up a Zapier zap to create new tickets in Asana and input data into custom fields. All my fields kept coming up blank until I fixed 2 things:
1- If your Custom Fields are dropdown, then you have to send the 15-digit selection ID to Asana, not the textual name. ( I wish this weren’t the case @Asana_team) As a workaround, you can use the ‘Formatter’ step to setup a custom lookup list per field. FUN if you have multiple dropdowns… https://zapier.com/help/how-use-formatter-functions/#using-the-lookup-table
2- If ANY of the input data items are wrong, then ALL of the custom fields end up blank, not just the one that is incorrect. Have fun troubleshooting!
Hi Alexis, I’m looking to create that sum (ours is task time allocation), but using the API to pull a list of all tasks assigned to the user “unassigned” so we can display this on a screen in our office and sum the custom field to create a total amount of time.
Is it possible to use the feature you mention via API? How would I go about doing this?
Great question! This is the perfect question for our developer section of the community! I suggest that you post this question in #developers:api-tips (<-- just click the link). Our Community developers (including @LenSantos) and the Dev Rel team at Asana (@Matt_Bramlage and @Jeff_Schneider) will be happy to help!
Bridge24 for Asana works great with custom fields. The grid view allows you to display custom fields, group/sort on them, and even export them along with your tasks to Excel or CSV format.