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?
Accepted Solutions
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!
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!
