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?
What do you have currently?
Try with this…
SELECT(TableName[Order],AND([NAME]=[_THISROW].[NAME],[DATE]=[_THISROW].[DATE])) in Valid_If.
@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!
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |