Lookup of single text type returns array

Topic Labels: API
2212 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.