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…

MessageTemp

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… https://www.appsheet.com/samples/How-to-use-the-LOOKUP-function?appGuidString=18f54bdc-9d6d-46b8-b063-419a8340da16

Anyone have any insight?

(Aleksi Alkio) #2

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

(David Hopkins) #3

@Aleksi_Alkio

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

@Aleksi_Alkio

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