So, I can't seem to replicate one of the Exam...

(David Hopkins) #1

So, I can’t seem to replicate one of the Example Apps features using a Lookup()

I have a table…


Title, ref to Messages[Title] Message, text, =LOOKUP([Title], “Messages”, “Title”, “Message”) Valediction, text, =LOOKUP([Title], “Messages”, “Title”, “Valediction”)

But those two fields are not changing when I change the dropdown for Title.

Im replicating this apps function exactly…

Anyone have any insight?

(Aleksi Alkio) #2

Try with this format… LOOKUP([_THISROW].[Title], Messages, Title, Message)

(David Hopkins) #3


Morning Aleksi, I tried the “thisrow” and it didn’t work.

so, it’s all mostly working the way I expect, except that regardless of which Title you select, the Message and Valediction are always selected as the first row in the DB.

Functionally, when I select a Title in the form, the other two fields are populated, just with the wrong data.

(Aleksi Alkio) #4

Not sure what the actual sheet structure is… but you could try [TITLE].[MESSAGE] if deref expression is the correct way.

(David Hopkins) #5


Sometimes, the simplest solution is the best.

That works exactly like i want it to… Way To Go…

Crazy thing is that I thought I tried that… but clearly, not. lol

Thanks so much Aleksi…

(Aleksi Alkio) #6

You’re welcome