Details page conditional filter for both internal team and client access

Hi Softr Community! :waving_hand:

I’m building an internal client portal and running into a permissions/access challenge. Would love some expert input.

My current setup:

  • I have a Grid block that lists all our clients (internal use only)
  • Clicking a client opens a Details page filtered to show only that client’s data using a conditional filter based on the current record’s client name
  • This works perfectly for our internal team

What I’m trying to do:
I want to give clients direct access to the Details page so they can view their own organization’s information without seeing any other client’s data.

Current challenge:

  • The Details page currently relies on the current record context passed from the grid click. If a client accesses the page directly (not via the grid), there’s no record context to drive the filter.
  • The detail page visibility settings can only assign per user group and I’m unsure if this would even work with what I’m trying to do

Users are managed and invited directly in Softr (not via an Airtable Users table), so there’s currently no field in Airtable that links a client record to a Softr user.

Any advice on the recommended architecture here would be really appreciated. Thanks!