I am having trouble with the lowest child category being filtered by the highest parent category in a hierarchy. Example: I am working on an app for a civil construction company. We have a “Job” view that displays inside information related to each job. Inside the job view for a specific job there is a “Materials” inline list that conatains 27 different materials that the company uses for its jobs. When I click on one material “category” I need it to display the Material Logs for that specific material and job only. The material logs are submitted through a form button and that information is stored on its own sheet.
What’s happening now is this: I go into Job 1 “Job View” and then go to the materials inline list > I click on Material 1 to display “Material Log” form entries > I am getting Material 1 “Material Log” entries for not only Job 1, but also Job 2, Job 3, Job 4, etc.
I’ve played around with the filter options but no luck. I am unsure as to how an array column might work here, and to be honest I’m no pro when it comes to Glide so my relations may not be setup right. Any help is appreciated!