Airtable - pull labels from primary field instead of record ID?

Looker Q&A Looker Studio
1

Hi folks,

New user here. I’m trying to create a dashboard for data collected in Airtable, and I can’t seem to get Looker to label the data using the primary field; it gives me the record ID’s instead, which renders the charts un-readable.

Example:

Screenshot 2025-01-17 095159.png
Screenshot 2025-01-17 095159.png678×559 25.4 KB

Those record ID’s should be the names of platforms where we advertise: Craigslist, Google, etc.

Any help configuring the chart properties so the labels are readable would be appreciated.

Thank you,

Shawn

2

If the field you need to display is misisng in the schema consider using Case formula.

https://support.google.com/looker-studio/answer/10471275?hl=en#zippy=%2Cin-this-article

Regards
Arkady

1 Like
3

That looks more complicated than the solution I used, which was to simply add a name column to the table and use that for the label.