Integrations that Incorporate Custom Fields?


#1

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:

****never mind – I think I’ve got it sorted.


#2

Well I think I’ve got it sorted!


#3

@hafidha Super! I think your experience will help some other folks, too. Could you tell us what you ended up figuring out?


#4

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.


#5

Sounds like a good way to maximize the power of Google sheets and Asana together!


#6

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!


#7

thanks @MattBram, I will keep an eye out.


#8

with custom fields you can pretty much use Asana for ANYTHING.

with custom fields-- asana pretty much becomes a de-facto “programming language”

you can know realistically use asana as a functioning CRM with the fields…

now, fields + boards = mind blown


#9

It look like Zapier added custom field support 2 days after your last message :slight_smile:
See https://zapier.com/zapbook/updates/856/asana-custom-fields-support/


#10

I still don’t get it ;-). What did you do ?

My very simple goal is to totalize custom field values whan in a project or when in a view

for instance, i search on a criteria, I then get 10 tasts as a result and want to know the total value of that 10 tasks custom field are

Just like when you add “[#]” in a tasks name and selecte multiple, the pane on the right shows the totals of that

regards

Edwin


#11

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.


#12

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. (:confused: 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!

Headache central.


#13

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?


#14

Hi Alistair,

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 @Allen) and the Dev Rel team at Asana (@Matt_Bramlage and @Jeff_Schneider) will be happy to help!


#15

You might want to take a look at the Screenful add-on, which can create out-of-the-box dashboards using data from custom fields. Here’s how it works:

https://screenful.com/asana/custom-fields/


#16

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.