I’m looking for the best (any?) way to handle one-to-many relationships in a table using data binding. See the image below for an example, where each (full) row is a user, and a user may have 0 or more ‘roles’ assigned (possibly a minimum of 1).
My first thought was to use a multi-select cell type, but that doesn’t seem to exist yet, and the few existing user-created solutions I found were outdated and non-functional for my environment. I know there’s cell merging functionality available, but I don’t see how that would work with data binding - or at least not without a ton of extra work. Is there any existing quick and easy solution for what I need?
Using mergeCells functionality is what came to my mind at first also, but as you mentioned it might be problematic with data binding. Unfortunately, we don’t have any easy-to-go solution for that kind of problem, so the custom solution might be the only way here at the moment.
I have to post under a new account as my workplace changed the login details on the other for security reasons, but we ended up going a different direction with this piece. I’m sure I could’ve figured out a solution with either text processing as you suggested, or a custom renderer with a bit more work if needed. Your help is much appreciated.