I am using a LINKTOFILTEREDVIEW action when a user clicks on a row. It displays a view with data filtered to the key of the selected row.
LINKTOFILTEREDVIEW(“Sections”, [Parent Task ID] = [Task ID])
That all works fine. The issue is that now a user is in this new filtered view “Sections” and wants to create a new record, how do I reference the filtered/data key that they are currently within?
E.g. One of the rows in this Section view is an ENUM that display a list of sections to select from. This list should only present sections that have not already been created within this filtered view. How do I reference what the current filtered view in this formula?