It’s a good question and yes this is most likely achievable in custom-coded Ops Hub actions. There’s a trade-off between using an app that has already figured that all out, versus building a low-code/no-code “app” in Ops Hub.
Reach out to Connor Jeffers and his team at Hapily the creators of Associ8, as they are also gurus with Ops Hub and will have solved associations there before getting to the point of building the app.
best, Pete.