I have a table with user names, and a notes column. On another canvas page, I have a single select field so that I can pick the user’s name. On the canvas (not in a table), I would like to write a formula to lookup (and display) what is in the Notes field of that selected user.
I have successfully used a Lookup formula before to achieve this setup, but I think it only worked because the value I wanted to lookup was the display column.
Is there a variation on a Lookup, or a Filter that I can use to show the note of a user selected on the canvas?
Yes, you can do that. Sample doc below. Copy the doc and check out the formula.
Only because you are asking to do so, I have put your lookup on a canvas from the 2nd table. I would normally put functionality like that on a page (Lookup page is included in the doc)