Hello, We would like to Map an address field ...

[Eric_Schwartz]

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?

Thanks

[Aleksi_Alkio]

If you have only one value, you can convert it to a value with the ANY(SELECT(JobSites[JAddress],[Key]=[_THISROW].[JobSite]))

[Eric_Schwartz]

Much thanks! Found ANY() function description in an article. Does concise function documentation exist?

[Aleksi_Alkio]

The best place is perhaps this help.appsheet.com - EXPRESSIONS | AppSheet Help Center EXPRESSIONS | AppSheet Help Center help.appsheet.com

[pravse]

Alternative syntax:

LOOKUP([_THISROW].[JobSite], JobSites, Key, JAddress)

Similar to VLOOKUP in a spreadsheet formula