Allow Users to Select Another Google Sheets File as Data Source

[Turk186]

Hi everyone,

I have developed a customized economic management app for my small non-governmental organization using Google AppSheet. Currently, the app relies on a Google Sheets file named "Gestionale 2023" as its primary data source. However, I would like to provide the flexibility for users to select a different file, such as "Gestionale 2022," as the data source to check the past year countability.

Could anyone guide me on how to implement this functionality in my app? My goal is to empower users to dynamically choose the Google Sheets file they want to use as the data source, without the need for manual changes in the AppSheet project.

Thank you for your help!