Can someone suggest why this statement, used ...

(Daryl Zernick) #1

Can someone suggest why this statement, used exactly as it is below in all my AppSheets, will find a particular USERMAIL() address in some AppSheets but not all, when logged in with that USERMAIL() address?


I’d be happy to share one AppSheet where it does and the other where it does not, but not sure how to do that.

(Aleksi Alkio) #2

The LOOKUP expression will always give you a result with one value. It’s the same than ANY(SELECT(…)) but with simple syntax. It will find the first one from your table.

(Daryl Zernick) #3

I found that there were two NurseIDs tables. One, being older, did not have the new nurse’s ID. Strange thing is, I don’t recall ever creating a second table.