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...
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...
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...
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...
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 ...
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
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...
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!
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...
