Is there a way to get the joist size from my joist sub item to populate the joist size or vise versa?

๏ปฟ
So I did something like this in PlanSwift. It didn't seem feasible to query the connected databases (lists) without creating a plugin, but because of the nested folder structure of PlanSwift, you could easily reference another template and drill down through the folders to the desired item. The key to this working was that the joist tool had to generate the exact names (technically, the descriptions) of the desired products. This meant fiddling with the joist tool scripts and supplying it with an appropriate naming schema. Because I am mostly interested in lumber and EWP, I came up with "[Size] x [Material Length] [Material][Var]" where "[Material]" was the species and grade and "[Var]" was a possible variant such as pressure treatment. After generating the name of the items, the file path to the product was followed and the GUID retrieved: Result:=GetItem('\Storages\Local\Templates\VT Material\[Material Type]\[Material]\[Description]'). With the GUID in hand, you could easily retrieve the SKUs from the products. Of course, there had to be some handling of errors, so I had PS drill down to both an item of the desired length and a substitute item 2 ft longer in case the desired length wasn't a stock item. Additionally, if it failed to retrieve a SKU it would retrieve the necessary class code for special order in our system.
This sort of attack may or may not work in zz, but I haven't gotten that far yet.
๐2