Dynamically load sheet in Google sheets resource

[dgates]

I have a list collection that displays each sheet available in a spreadsheet. I want to create an event handler that will navigate to another screen containing a collection of the data from the selected sheet. A nested collection that is dynamically queried. The number of sheets will not be constant.

I used the additional scope feature to pass the name of the sheet selected into a query and placed it in the sheet name field but it seems to add a / at the end that ruins the format.

Is there a way to fix this or is there another way to achieve this?

Thanks

[Paulo]

Hey @dgates if you're still looking into this, our Office Hours could be a good format for getting ideas for how to build this functionality in a group including Retool Community Support Engineers and other experts from the community

If you do join an Office Hours session, please share learnings back here as a Solution . I'm sure that'd be useful for others searching for how to build similar functionality!