Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Dec 29, 2021
Is anyone familiar with Google Data Studio?
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 CSV to create a report in Google Data Studio.
I’m at a loss of how to leverage Linked Records in visualizations, which output from the API as an array of Record IDs.
Currently, Data Studio only sees them as strings.
Thanks in advance!
Jan 03, 2022
All the linked records must be duplicated to separate column as formula (as easy as reference the column). By doing that, the data is stored as text.