I’m trying to extract the city description from a field that contains a geographic address. I’m using the EXTRACT function which is supposed to return a text result. I’m adding this result to another field that is a TEXT type being a LIST .
Sometimes the city name is extracted correctly and captured in this field. But sometimes, instead of the correct value, I see “(object) (object)” in the field.
All the necessary API settings for Google have been input as required.
My users are using addresses in Hebrew.
What do you think the problem is and how can it be solved?
By the way, following a suggestion from elsewhere in the forum, I’ve embedded an invisible map object in the page, to which I pass the result of the search field where I’m searching for a geographic address, and from there I pull the address. This also didn’t solve the problem.
Thank you!!