I am using Airtable as a data source for an app on AppSheet. Everything seems to work well except for values from linked tables. As shown in the image below, when a value is coming from a linked table, it is showing the record ID instead of the actual value. How can I fix this?
Hi @Sidney_ML - I haven’t used Airtable in the way you describe, as a source for AppSheet, but as AppSheet will be using the Airtable API to get data from Airtable, this is the “expected” behaviour - the API returns the ID of the linked field, not its value. The simple way to fix this is to add another field to your base which turns the link into a string:
This is a formula field with formula:
link & ''
You can see in the API docs that this passes through the string value:
So you could just map this new string field to the appropriate field in AppSheet.
The possible downside, as you can see, is that a record with multiple links will comma-separate the values, which may or may not be what you want.
If this answers your questions, please consider marking it as the "solution". If not, please post again for more help. Thanks!
Thank you so much! This was super helpful.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.