Thanks for reaching out!
One option is to use a transformer, similar to the linked convo, but it will display the wrong data first & then refactor to the correct data shortly after
I would recommend actually using a column type of Button, instead of a modal type. Then, I would trigger a query on click. The query would select the row & open a separate modal component that is hidden on the canvas, as described in this workaround