Hi @lvnenchak Thanks for reaching out about your use case!
It looks like this isn't currently possible to do in Retool 
I checked internally & I see that we are working on a beta feature that would help with this, but we don't have a distinct timeline yet.
I will move this post to our feature requests section for the time being! Definitely keep an eye out for this feature on our updates