Airtable: track user reported bugs

Understand how fast you're solving user reported bugs.

The process

Try It for Yourself

What do I get out of it?

Solve bugs faster and improve your customer satisfaction.

How does it work?

  1. You import your Airtable data with your bug tracker in an Actiondesk sheet.
  2. You create a calculated column to return the time it takes to fix a bug.
  3. You create a dashboard in a new sheet to know the percentage of bugs that have been fixed in a day, in less than 3 days, etc.
  4. That's it! You can track how fast you fix your bugs.

Detailed tutorial

First, let's get the data we'll work with in this example:

  1. Download this Bug tracker template.
  2. Go to the "Bugs and issues" table.
  3. At the right of the table, add a column. Rename the field and call it "Fixed date".
  4. Click on the column header and pick "Customize field type" in the dropdown.
  5. Choose "Formula" as your field type.
  6. In the Formula tab, write: =DATEADD({Opened date},{Opened date},'day')
  7. In the Formatting tab, uncheck "Include a time field".
  8. It will automatically fill all the rows of your new column with the day's date when a bug is fixed.

Now, let's understand how fast you're solving user reported bugs:

  1. Create an Actiondesk sheet called "Airtable bugs".
  2. Import the Airable table "Bugs and issues" in Actiondesk. See how here.
  3. Add a calculated column to return the time it takes to fix a bug. To do this, just create a column called "Time to fix" and use the formula =#Fixed date - #Opened date
  4. Add a calculated column to return the periods of time it takes to fix a bug. To do this, just create a column called "Time to fix bracket" and use the formula =IFS(#Time to fix<1, "<1="" day",="" #time="" to="" fix<="3," "1-3="" days",="" fix="">3, "3+ days")</1,>
  5. Create a new sheet called "Bugs Dashboard".
  6. In "Dashboard", in B2 to B4, write:
  7. To calculate the time to fix and only count bugs that have been fixed, we add a condition Status=Complete. In C2, write the formula =COUNTIFS(Airtable bugs!#Time to fix,B2,Airtable bugs!#Status,"Complete")
  8. Then, copy and paste this formula in C3 and C4.
  9. In D2, write the formula =C2/SUM($C$2:$C$4)
  10. Then, apply the percentage format on D2


Good job 👍 You now have a good understanding of how fast you fix your bugs. If you have too many bugs fixed in more than 3 days (>5%), you may want to revisit the way your prioritize bugs.

What do I get out of it?

Solve bugs faster and improve your customer satisfaction.

How does it work?

  1. You import your Airtable data with your bug tracker in an Actiondesk sheet.
  2. You create a calculated column to return the time it takes to fix a bug.
  3. You create a dashboard in a new sheet to know the percentage of bugs that have been fixed in a day, in less than 3 days, etc.
  4. That's it! You can track how fast you fix your bugs.

Detailed tutorial

First, let's get the data we'll work with in this example:

  1. Download this Bug tracker template.
  2. Go to the "Bugs and issues" table.
  3. At the right of the table, add a column. Rename the field and call it "Fixed date".
  4. Click on the column header and pick "Customize field type" in the dropdown.
  5. Choose "Formula" as your field type.
  6. In the Formula tab, write: =DATEADD({Opened date},{Opened date},'day')
  7. In the Formatting tab, uncheck "Include a time field".
  8. It will automatically fill all the rows of your new column with the day's date when a bug is fixed.

Now, let's understand how fast you're solving user reported bugs:

  1. Create an Actiondesk sheet called "Airtable bugs".
  2. Import the Airable table "Bugs and issues" in Actiondesk. See how here.
  3. Add a calculated column to return the time it takes to fix a bug. To do this, just create a column called "Time to fix" and use the formula =#Fixed date - #Opened date
  4. Add a calculated column to return the periods of time it takes to fix a bug. To do this, just create a column called "Time to fix bracket" and use the formula =IFS(#Time to fix<1, "<1="" day",="" #time="" to="" fix<="3," "1-3="" days",="" fix="">3, "3+ days")</1,>
  5. Create a new sheet called "Bugs Dashboard".
  6. In "Dashboard", in B2 to B4, write:
  7. To calculate the time to fix and only count bugs that have been fixed, we add a condition Status=Complete. In C2, write the formula =COUNTIFS(Airtable bugs!#Time to fix,B2,Airtable bugs!#Status,"Complete")
  8. Then, copy and paste this formula in C3 and C4.
  9. In D2, write the formula =C2/SUM($C$2:$C$4)
  10. Then, apply the percentage format on D2


Good job 👍 You now have a good understanding of how fast you fix your bugs. If you have too many bugs fixed in more than 3 days (>5%), you may want to revisit the way your prioritize bugs.

Read more
Create My First Report
see all Airtable use cases
The Advantages

Key Benefits

Eliminate the need for expensive third-party connectors and laborious copy-pasting.

Seamlessly import, organize, filter, and manipulate your Airtable data. Analyze it alongside data from other sources, and build custom Airtable dashboards and reports.

View and organize your Airtable data within a familiar spreadsheet interface.

Seamlessly import, organize, filter, and manipulate your Airtable data. Analyze it alongside data from other sources, and build custom Airtable dashboards and reports.

Feel confident in knowing that your data is always accurate and up-to-date.

Thanks to real-time cloud-based updates, any changes to your data made from within Airtable are automatically reflected in your Actiondesk spreadsheet.

Save time to analyze your data and make better decisions for your business
Create My First Report
Learn More

Our Use Cases

Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.