Solved: More noobish questions about a Pokemon project (di... - Page 2

Vladcik · 07-01-2023 07:40 AM

Hi !

Sorry if these question seems weird, but I'm trying to work on an app that would allow me to keep track of my Pokemon data caught in the games. I'm progressing well, got a base of what i've wanted. But before going further into the final version of my personal app, I've a few issues to tackle and I struggle to find the right way for this :

First, in the detailed view. I'd like to have a different, more customized display. As displayed on the screen right under, I'd like for example the IV information to be displayed in one line. But I can't like create only one data on my sheet since i'll want to filter the data A LOT. That's a minor one but I'm still curious if it's doable

Now it's a tricky question. On my google sheet, I've multiple sheets with the same structure of data. But the content of it is different. I'm adding them as data on my appsheet the same way for each. But my goal would have a view that would allow to fuse these data in only one view. There'd still have separate view but i'd need one to have the 3 sheets together. Is possible based on the fact the structure of the data is the same for each

Sorry if i'm not clear enough,

Thanks a lot ❤️

dbaum

@Vladcik wrote:

That will not make any issue for filtering IVs in my app ?

No. Retain the existing individual columns for purposes like filtering. Use the new combined column for purposes like display.

@Vladcik wrote:

more work / stuff to take care

I'm not sure what incremental effort you're envisioning. To be clear: the additional column would be automatically (i.e., not manually) populated.

@Vladcik wrote:

That's not really good at all either.

I don't follow your explanation of why, but that's certainly fine and your reasoning may indeed be sound. Nonetheless, in case you're not already aware, "multiple sheets with the same structure of data" is generally not conducive to efficient data maintenance nor app design. If you decide to experiment with collapsing your multiple sheets into one and encounter challenges specific to "image link", "missing Pokemon", or other complications you foresee, post a new question with the specifics and someone in the community may be able to advise.

If your app is only for viewing (i.e., not editing) data, one technique to consider would be to create an additional sheet that combines all the other sheets using functionality available within Google Sheets rather than trying to combine the various tables within AppSheet. Then, you could add that combined sheet as one more table in your app.

View solution in original post

More noobish questions about a Pokemon project (displaying and filtering data issues)