Pivot Chart Block & Block Webhook

• 

  using sales CRM

• 

  using elmawkaa base

• 

  airtable block webhook

Inspiration

Pivot Chart Block: In our company airtable base, I wanted to get the prices for each products for the past 2 months in order to be able to tell our sales team estimates for the pricing so that they can answer our customers directly by phone or on chat, without telling them to wait for the prices from our vendors

Airtable Block Webhook: Another custom block I made is airtable block webhook which opens the possibility for anyone to use their custom webhooks and send specific records fields to do whatever they want here's the github link: https://github.com/mahmouds12/airtable-blocks-webhook

What it does

Pivot Chart Block: Getting statistical data (minimum, maximum, mean, median, sum) for specific numerical field (y-axis) grouped by specific field (x-axis) and show them combined on a bar chart to better visualize your data

Airtable Block Webhook: Enables airtable user to connect to their custom webhooks to do whatever they want with the data sent. examples: press a button to send sms/whatsapp/email to a contact (by selecting the records) to remind him of the next action using your favorite service provider send data from selected records for analysis and get back the results on another field

How I built it

Using react and js

Challenges I ran into

Thinking of idea that is simple but beneficial from the business point of view was a challenging one. I wanted to build something that we can make use of in our business airtable base, not just for the contest

Accomplishments that I'm proud of

Time to learn, practice, and apply was limited for me as I knew about the contest late. But I am glad that I was able to learn and apply in this limited time.

What I learned

I learned a lot from airtable custom block creation process thanks to the documentation and examples... it's a very important feature and will make us more hooked to airtable.

What's next for Pivot Chart Block

improving it to contain a lot of advanced chart features Airtable Block Webhook: Making it more customizable to different needs, and handling responses for general purposes

Built With

• chartjs
• javascript
• npm
• react