Emmanuel Katto Dubai : Setting Rules for Objects Associated with Multiple Items

Hi Everyone, I’m Emmanuel Katto from Dubai, United Arab Emirates (UAE) I’m facing a situation I haven’t encountered before, and I’d like to get your thoughts on it.

Here’s the scenario:

I have an object, a “hairbrush,” that is associated with two companies: “hairstrait” and “kindahairy.” Essentially, it’s a many-to-many relationship, where a hairbrush can be linked to multiple companies.

Previously, the table looked something like this:

Company Object
hairstrait hairbrush
kindahairy hairbrush

In this setup, if a hairbrush was “used,” I’d set a flag in the record to mark it as used. Once marked, the object no longer appeared in the grid.

Now, I’ve updated the system to allow multiple companies to be associated with a single object (like the hairbrush), so I can have several companies linked to one object. But here’s where I need help:

The rule I currently have states that when an object (like the hairbrush) is marked as “used,” it’s flagged in the table as “used.” What I want to achieve now is more specific: I only want the record to be marked as “used” when both companies linked to the hairbrush are marked as “used.”

For example, if the hairbrush is linked to both “hairstrait” and “kindahairy,” I would only flag the record when both companies have been marked as “used.”

So, let’s say this is my table:

Company Object
hairstrait hairbrush
kindahairy hairbrush

If I mark only “hairstrait” as used, the grid would still show the “kindahairy” company for the hairbrush. But if I mark both companies as used, then the hairbrush would be flagged as “used” in the table and would no longer appear in the grid.

I could come up with a workaround for this, but I’m curious to know if there’s a way to set this up directly in the system. Any thoughts?

Thanks!
Regards
Emmanuel Katto

Hi @emmanuelkatto24, how about a count field on the object record that counts the number of company objects that are not used.
Then you can pass that value through an equation field to the company objects table, and filter your grids where count is higher than 0.

Let me know what you think!