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-b06...
Anyone have any insight?
Try with this format… LOOKUP([_THISROW].[Title], Messages, Title, Message)
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.
Not sure what the actual sheet structure is… but you could try [TITLE].[MESSAGE] if deref expression is the correct way.
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…
You’re welcome
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |