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
