Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Lookup of single text type returns array

Topic Labels: API
1632 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,
im having a table of locations that which record has location name( which is a single text type) and other parameters.
im having a columnn in another table which is a Look Up for the location’s name. The records in this column are arrays,even if records contain only single location name.
How can i change the type of the lookup column to be only single text and not returning the location name as a list/array?

1 Reply 1

The easiest way to do this would be to create another field that is a formula to coerce the “Location” into a string:

{Location Lookup Field} & ""

By pulling in the looked up “location” array, and then concatenating it with an empty string, it will coerce that array into becoming a string. Then you can reference that formula field from any other fields or API’s that you need to work with strings.