- My goal: I want the tables inside a collapsible container to run their queries and respond to triggers, even when the container starts out hidden or collapsed.
Welcome to the community, @Saujanya_Waikar! Thanks for reaching out.
The behavior you're describing isn't yet supported, as I'm sure you've surmised. We generally freeze the state of non-visible components but are tracking a request that would make them more dynamic. I've added your 
to the internal ticket and will provide an update here as soon as I have news to share.
HI @Saujanya_Waikar ,
When a table is inside a collapsible container, it won’t automatically execute queries if the container is hidden.
To ensure the query runs regardless of visibility, trigger the query manually.
//syntex:
{{queeyname.trigger()}}
set your eventhandler on page load so it will always trigger your function even if it is hidden.
or
You can try This:
App → Event Handlers → On page load → Run query → queery