• Skip to primary navigation
  • Skip to main content
  • Skip to footer

Chintu Gudiya Foundation

  • What We Do
    • Blog
  • Who We Fund
  • Projects
  • Grants
  • Financials
Project Tech4Dev

Tech4Dev Project Tracker using Airtable

You are here: Home / Blog / Tech4Dev Project Tracker using Airtable

twitter sharing button Share this on Facebook

Tech4Dev Project Tracker using Airtable


October 10, 2019 by Kurund Jalmi
Leave a Comment

We were looking for a tool that can give us a top-line analysis of all the projects in the pipeline, including past, present and future projects. It should allow us to get a snapshot of the status of all projects at any point in time. This allows us to follow up on projects that are behind schedule or over budget. Note that all documents will be stored on Google Drive.

We evaluated a few project management tools and also ticketing systems. Most of them worked quite well for the individual project but we were not able to get the data that we needed for our purpose. Here is the document that covers our requirements:
https://docs.google.com/document/d/1JMki14I3Zguz98LZatbGadYLX_TiWDVB9KpOouAOiA0/edit?usp=sharing

Someone recommended us Airtable. It looked very promising and we were quickly able to get basic data structure in place. We have 3 main entities:
* Projects
* Contacts
* Activity

One slick feature of the Airtable is you can create different views of the same data. For eg. we created a form to collect weekly status for ongoing projects.

Weekly Status Report

Our next challenge was to send the reminders if the weekly status report is not filled. Fortunately, Airtable has excellent API support. We have written a node application for the same. Code is available at https://github.com/tech4dev-india/project-tracking-with-airtable. Currently, we have started a pilot with few projects and have started collecting the data.

Overall, Airatable is very impressive and can be used as a prototyping tool before actual project implementation.

Category iconBlog Tag iconTech4Dev Project Updates

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recommended reading

    Tech4Dev Project Implementation Process

    Here is the process that we typically use for any Tech4Dev project and we are following the same for the Medha STPC project. Prepare a scope document based on the project proposal that is submitted by NGO to Tech4Dev and after discussions with the NGO.Once the scope is agreed by NGO, we create a detailed project

    March 9, 2020 by Kurund Jalmi

    CRM Project Framework

    We were analyzing past Tech4Dev projects including the project in the last 2 cohorts and found that there were few projects which were CRMish in nature. Hence, we thought if there was a basic framework/tools/CRM app it would help and save a lot of initial work done by various implementing partners. Hence, we had a code

    December 29, 2019 by Kurund Jalmi

    SeSTA FMS project completion

    We have completed the work on the SeSTA FMS platform which enables the FPO to manage their shareholders, loan management and also allows tracking of the activities carried out by the Community Service Providers (CSP). The project has been tested and deployed on SeSTA’s production server. Key features implemented in the application: Role-based Access Control User-specific dashboards (Users can

    October 9, 2020 by Kurund Jalmi

Tags

#Tech4Good 66A analysis analytics architecture ASHWINI Avni conference Coronavirus COVID-19 crm-platform dataexplorer design research Discounts freespeech FundImpact github badges Glific Google governance hasiru dala ideation internetfreedomfoundation Jan Swasthya Sahyog Koha Koha Challenges Koha configuration Koha features Lastmilesupport library medha-stpc openchs opencity opendata open source Partnerships sesta Social Change Software Team Collaboration tech Tech4Dev Project Updates whatsapp Work from Home Yenepoya

Categories

  • Blog
  • Essays
    • 2015
    • 2016
    • 2017
    • 2018
  • Focus Areas
    • Organisations Funded
      • Education
      • Environment
      • Health
      • India
      • Open Source Software
      • Other
      • Philanthropy
      • Sanitation
      • Sports
      • Women Empowerment
    • Tech Work
  • Projects
  • Pune 2018 Unconference
  • Tech4Dev Project Report
  • Uncategorized

Footer

  • What We Do
    • Blog
  • Who We Fund
  • Projects
  • Grants
  • Financials

Copyright © 2021 Chintu Gudiya Foundation. All rights reserved. | Photo Credits