Hello,
As a user searching for records that have parent relations,
I want on a search component to search directly for the child record with a connection field format,
So that I can use the “is” predefined function and look for exactly my record.
I’ve already figured out how to auto-populate the parent field with the parent of a child when the child is selected. when using a form component.
Populate parent field with related parent record of child
Now I want to see if it’s also possible to do this in a search component. However, I need the child component to be searchable.
Scenario: I have Ideas and Projects. Projects (child) are connected to Ideas (parent). On a search component, I want to be able to search projects within the field, select it, and the Idea field is automatically populated in my search app.
My attempted solution is to add a connection field that is set to it’s record ID via a table rule. However, I’m failing to get this to properly work.
Rule: Project ID (Join) to a Record Value of Record ID (Id)
Any ideas?