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

(Eric Schwartz) #1

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 :slight_smile:

(Aleksi Alkio) #2

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

(Eric Schwartz) #3

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

(Aleksi Alkio) #4

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

(Praveen Seshadri (AppSheet)) #5

Alternative syntax:

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

Similar to VLOOKUP in a spreadsheet formula