Zero experience and looking to dip my toe in the water with Glide. I have a bunch of data and calculations in Google sheets that make a tool for users of a mobile game. One sheet in particular generates a rankings table depending on selection criteria the user inputs. The input is via drop downs in separate cells. The output is a table of adjustable length (controlled by input parameters). That table is generated by a query function. Ideally, I would like to make an app that lets users specify some selection criteria, and display tables accordingly in a mobile friendly format. Currently, everything needs to be run on a full browser version of Sheets in a personal copy so the user has edit rights.
There are plenty of basic guides out there, but since I’m just in the ideation phase I want to make sure I’m heading down the right path. Please forgive if I’ve missed some basics in my quick searches and reading, but here are some potential issues I’m seeing with what I have.
- blank rows and columns need to be eliminated…
There are blank rows currently because the size of the pool read grows weekly, so I had room for extras. If that’s an issue, I can easily delete extra rows. The length of the output table is not the same as the data table within the target sheet. So, the entire row isn’t filled/some columns are one length while others are shorter. This could be solved by changing the format/making a new sheet that features a fixed length list ordered and not having variable table length. Alternatively, I could just fill the empties with a value, I guess. Seems like a bad idea, though.
- all data has to be in one sheet…
I can make a sheet that is all the forward facing info and have it built via referencing other sheets though, right? If so, that’s not a big deal.
- my current format requires all users to download their own copy so they can gain edit rights…
This is due to making the output of the rankings customizable. I didn’t want to make iterative tables. This game really has no one set way to play it, so customizable rankings are almost a must, imo. This is performed by query of data within that sheet, but that data is read from another sheet (is that a problem?). If someone inputs their selection, it edits the sheet. If needing to edit the sheet itself is a no-no, I could have the tables made up in advance for presumed popular input values, have them referenced by an input within the app, and have the app display the table (if that’s all possible). If the edit rights are an issue, I guess I could maintain a separate one nobody has a link to that is open to editing tied to the app. Not sure how that would work if multiple users were on simultaneously.
Like I said…totally just thinking out loud and seeing if I’m barking up the right tree. Any suggestions, links to resources, or comments would be greatly appreciated. If I’m off base here, sorry but totally green with anything related to code or app/software dev.
If I broke any forum rules, put this in the wrong place, or anything else, let me know and I’ll remove/repost or edit.