Search subitem and update

Platform discussions monday apps & integrations
, , ,
1

Hi there
I currently have 3 boards. One main and 2 “slave” boards for a warranty handling system.

The main board is an overview of machinery with serial numbers.

The slave boards are updating the main board with warranty requests and repairs.

1st slave board is creating a subitem (request) based on a serial number found as an item in the main board by search function in make. Subitem is created from make with serial number as main item and project number as identifier in subitem.

When a repair is done I need to identify the serial number which is found in a column in the main board (so far it is complete)
Trouble starts when I want to find the subitem with the request and update with repair.

When both files, request and repair exists in the same subitem the case is closed and main item is updated.

Any ideas?

1 Like
2

I think this might be a similar scenario to what Mr. Stian shared.
I have subitems with columns. Example:
If I had a Bakery. Item is a Client. Subitem is the type of item baked. And a subitem column is an ingredient in the item baked. Different clients might order baked items, but the only fruit options we have are Apple, Blueberry, Cherry. I want to know how many times Apple shows up on our Monday.com subitem columns. For instance
Client A. Subitem Pie. Subitem column Ingredient Apple.
Client B. Subitem Muffin. Subitem column Ingredient Apple.
Client C. Subitem Pie. Subitem column Ingredient Cherry.