I have many monthly spreadsheets, each one with 2 tabs. The idea about the app is that the user can have access to any of those spreadsheets based on month/year he chooses. So, i was thinking about having a month and a year spinners and depending on the selecting, the app shows data from the specific spreadsheet for that month/year. Is it possible to do? Any help on that?
Not possible. You can only link your app to one spreadsheet. So multiples are not an option.
Technically, this is sort of possible, but if you have multiple users, then when one user changes the date, it changes it for everybody. You can do this by using IMPORTRANGE (https://support.google.com/docs/answer/3093340?hl=en). Like @George_B said, you can’t point your app to multiple sheets, but if you had a list in your main app sheet of all the monthly sheets, then you could use formulas to build the importrange formula based of date and lookups. Again, this would change for everybody when one person changes the date.
Personally, I would try to get all of your date into one sheet. Then build another sheet (that will be the primary tab) in the app, with just Month/Year combinations. Then create a reference that links the two together. Rather than a spinner, the user can just scroll through the list to the Month/Year they want and then open it up into all of the data for that Month/Year.
Just a warning that IMPORTRANGE will not trigger unless the spreadsheet is open in an interactive browser view. Counting on it is not a viable option in my opinion.
Take at look at this old post from the prior community in which I made that mistake myself.
1 Like
Good to know. Thanks!
Topic appears dormant, archived.