The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hey Y’all,
Is anyone familiar with Google Data Studio?
Context:
I’m playing with an idea of archiving data from Airtable.
To do that, I’m routinely exporting the JSON output from the API, and appending a CSV in Google Cloud Storage.
I’m using that...
Happy 2021 everyone! A new year, brings new projects to manage. And where would project managers be without their handy burndown charts? Well, with a bit of scripting and the vega-lite app, you can now make a burndown chart in Airtable!
For the unini...
Sometimes you import some data that looks like this:
But you want table data that looks like this:
This script does that:
let settings = input.config({
title:'Table Optimizer',
description: "Converts data that's stored over many fields, int...
I’ve gotten Car fever and want to start doing research on used cars that fit my price range. I tried some of the consumer sites, but was really left wishing I had a place to look at all my research at once and compare things like average price and mi...
The Scripting block is a powerful game changer for Airtable, though you don’t need to be a developer to use it. Before using the scripting block, the most experience I had was writing a couple of Macros in Excel (but even that isn’t necessary knowled...
Hi Rosie - Welcome!
From the explanation of your example, I would say yes. I’d use .getView() to curate the list of parts you’d like to bulk add to a product.
So glad this helped! The below section in the script is where i think you can change the values for the quartiles. You can even remove some if you’d like.
const q25 = arr => quantile(arr, .25);
const q50 = arr => quantile(arr, .50);
const q75 = arr...
@Alter345 and @CPC_Center - both great questions and this is totally doable. I updated the script in the example base so that you can choose between the Webinar or Party Template