I'm trying to use a de-reference to look up a...

(Joshua Giles) #1

I’m trying to use a de-reference to look up all inputs from a specific user on a certain date.

I’ve had the user input their name, and the date they are looking up and I would like a drop down list of all orders filled by them filtered by the previous columns of name and date. Any help?

(Steven Coile) #2

What do you have currently?

(Aleksi Alkio) #3

Try with this…

SELECT(TableName[Order],AND([NAME]=[_THISROW].[NAME],[DATE]=[_THISROW].[DATE])) in Valid_If.

(Joshua Giles) #4

@Aleksi_Alkio You’re seriously the best!

@Steven_Coile the above solution worked. I do know that lookup functions like this have performance drawbacks. So if you have any solutions that strictly uses appsheet’s de-reference abilities, that would be cool to. For now this method works!