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?

=CONCATENATE(LOOKUP(USEREMAIL(), NurseIDs, Email, ID),[NextNum])

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.