I want to mirror subitems on Monday between 2 boards, so that whenever a subitem is created or updated in one board, the same is applied on the other board (both ways). I’m having difficulty doing this because of the way subitems are mapped on Make and because there isn’t a dedicated search module for subitems.
I’ve tried multiple approaches and I feel like I’m close to solving this now, but I’m stuck. I plan to build 2 scenarios, both mirroring in either direction between the 2 boards.
The scenario is currently built in this way:
List Board Items - Board ID is linked to Board 1. Show Parent ID and Subitem ID are both ticked as Yes
Iterator - I’ve mapped the subitem array from List Board Items
Get an Item - ID is the ID output from the Iterator
Parse JSON - there are 4 subitem columns, and this module parses the json from 1 of them
Parse JSON - does the same to another one of the columns
Set variable - i’ve inputted the full json output here for all 4 subitems and used the output from previous modules to map specific values. The 4 columns are a status column, a timeframe column, an address column and a text column.
Search Items in the board by column values - this is where I’m stuck. I’m trying to input mapping for subitem IDs and am getting error messages despite trying all subitem id mapping that is available to me.
Then I plan to use a router with 2 paths:
Path 1 - Subitem already exists - this will lead to a subitem column update
Path 2 - subitem doesn’t exist - this will lead to a subitem creation
Any suggestions will be appreciated. And if additional screenshots would be useful, please ask