I am confused as to how you make the LINKTOFILTEREDVIEW Show anything. I am trying to show some rows from another table in a form but I cannot get anything but I grayed out text box to show.
LINKTOFILTEREDVIEW is a deeplink generating expression. It’s for navigation, it doesn’t show records. I think you want FILTER(). Or possibly you just need to set up a reference.
https://help.appsheet.com/en/articles/2357308-filter
https://help.appsheet.com/en/articles/961426-references-between-tables
Blah, I have tried all these and cant get any of them, I would take the link if it would work but it just goes to a blank page.
So Filter returns the key values, how do I get the whole row to return?
This fomula returns all 606 entries from the complete list, I just need to get it to only show the company from the form.
Is [Company Name] the key column on the table where you’re putting this expression? Presumably that table is the left side of your first screenshot, but it’s cut-off so I can’t see much.
Then neither ref_rows or a reference is the way to go. Stick with the FILTER(), it should return as a List type with base-type Ref, which will display as an inline view.
@Marc_Dillon Comes through again, thank you so much!