As far as I know this isn't easily doable I'm afraid
A workaround I sometimes use is to link all of the records to a single record in a helper table. This helper table will have a single field called "Search term" or something
In the original table, I'll use a lookup field to display the value of `Search term`, and I'll create a formula field to see if the record matches the search queries
With reference to your example, the `Search term` would be "2016", and the formula would check whether the `Ticket Item ID` value was 2016
In the Interface, I would have a grid that filters based off of the formula, and I would have a button that would run an automation on click. The automation would take the current record's `Ticket Item ID` value and paste it into the `Search Term` field
The workflow would thus be:
1. Go to the record in Interface
2. Click the button
3. Automation runs and formula updates, grid updates to only display records with the same `Ticket Item ID` value
This is pretty fragile though, and if two users were using the Interface at the same time it would error out
As far as I know this isn't easily doable I'm afraid
A workaround I sometimes use is to link all of the records to a single record in a helper table. This helper table will have a single field called "Search term" or something
In the original table, I'll use a lookup field to display the value of `Search term`, and I'll create a formula field to see if the record matches the search queries
With reference to your example, the `Search term` would be "2016", and the formula would check whether the `Ticket Item ID` value was 2016
In the Interface, I would have a grid that filters based off of the formula, and I would have a button that would run an automation on click. The automation would take the current record's `Ticket Item ID` value and paste it into the `Search Term` field
The workflow would thus be:
1. Go to the record in Interface
2. Click the button
3. Automation runs and formula updates, grid updates to only display records with the same `Ticket Item ID` value
This is pretty fragile though, and if two users were using the Interface at the same time it would error out
Thanks Adam,
It should probably work, but as you close your article, we are several to use the interface at the same time, **bleep** 😞