@jason.patton if you're still looking into this, joining our Office Hours could be a good option to discuss use cases/what's possible in Retool with a small group of Retool users, community experts and Retool employees!
If you did find a better solution for this in the meantime, or learn one during office hours, please do feel free to share it here in case others could learn from it too! Thanks 