How to use a value from the Detail view's record to create a dynamic slice?

[GGL]

Hi,

I have:

1. A table with active jobs
2. Another table with all previous jobs.

When clicking into Detail view for a job from the Active job view, I’d like to have an Action button which opens a view made from a slice of the Previous Jobs table filtered by some job details of the job I’m in Detail view for (or in other words a history of jobs at the currently selected location).

I have an action and “prominent” button set up which links to a sliced view. The only missing part is how to create the view. So for the detail view I’m in, the slice view should show all previous jobs based on that address.

I’ve been playing around with [First Name] = [_THISROW].[First Name] (as a test) but no luck so far.

Any thoughts? I assume this is a common use case.