Hello, We would like to Map an address field pulled from an indirect table. The result of the select is of type List. How can the single select result be converted to an item of type address?
=SELECT(JobSites[JAddress], [Key]=[_THISROW].[JobSite]) [JAddress]
More broadly, can type conversion be acheived in AppSheet?