Matthew_Chattwo - profile

Matthew_Chattwo · Aug 12, 2022

I’m trying to create a basic badging award system for volunteers as they progress within an outreach program. And I’m wondering if I’ve finally reached the point where I need to learn JavaScript to do what I want in Airtable. The Basics: Match Log ta...

Matthew_Chattwo · Aug 04, 2022

Hello community! I’m trying to implement a simple badge system within an volunteer program. Basically, when volunteers pass certain checkpoints I’d like to award them a badge e.g. ran workshop X >> badge 1ten total workshops >> badge 2 The pivot tabl...

Matthew_Chattwo · Mar 29, 2021

Hello community! I am using an automation that triggers when an Airtable field is updated. The action is to update attendees field in an Outlook calendar but testing returns an error of ‘Cannot read property “timeZone” of undefined’. See image for wh...

Matthew_Chattwo · Feb 26, 2021

I’m trying to calculate and then visualize Net Promoter Score (NPS) from a table of evaluation scores submitted through a form. NPS = (% promoters - % detractors) / total number respondents Where: promoter values = 9-10 detractor values = 1-6 total...

Matthew_Chattwo · Jun 23, 2017

I have an inventory tracking challenge that I’m having difficulty with In my line of work clients order resources. Each resource contains a number of items from my stock room. I want to track inventory of items automatically based on resource orders ...

Matthew_Chattwo · Aug 08, 2022

Hi @Adam_TheTimeSavingCo, thank you very much for suggesting a solution for this. I’ve definitely got more of an idea of what to do now. All the best, Alex

Matthew_Chattwo · Aug 05, 2022

Thanks @Adam_TheTimeSavingCo I think you have me part the way there. My base is structured a little different to what you suggested, so here are those screenshots Volunteers are linked to workshops by a table called Match. This Match table is how vol...

Matthew_Chattwo · Apr 12, 2021

Hi @Rose_K - thanks for your response. You were right - I didn’t have a field to record the Outlook event ID. Once I included that and reconfigured the automation a little bit, it started working. Thanks for your help!

Matthew_Chattwo · Mar 04, 2021

Figured it out. The key was to transform values [promoter, passive, detractor] into a score [+1, 0, -1] and use “joinaggregate” to create a sum_score that effectively equals the “promoters - detractors” bit of original equation. Rest was easy. Now to...

Matthew_Chattwo · Mar 02, 2021

Thanks for the response, Bill! I’m going to continue to tinker with it when I get the time. Will post any updates to the thread.

User Statistics

User Activity

Should my first script be a badging system?

Badge system w/in training program

Update Outlook Event returns "timeZone" error

Calculate Net Promoter Score in Vega Lite

Subtract single value from each number in a field where cells contain multiple values

Re: Badge system w/in training program

Re: Badge system w/in training program

Re: Update Outlook Event returns "timeZone" error

Re: Calculate Net Promoter Score in Vega Lite

Re: Calculate Net Promoter Score in Vega Lite