Yep, that’s the idea 
Then you add a single value column to retrieve the rank name via the query column.
OK, what I got back so far is the correct image for the rank (which was the 2nd column). No idea what happened to the first column (Level) or the rest. How do I control which column gets returned? It’s what your last sentence was trying to tell me, but I am not following. (sorry, I AM learning, though!)
Ooo, I found it!
I need row three, but it is coming back blank for some reason.
Yes. The query just establishes a link. If you need actual values from the Ranking table, you use a single value column to fetch those via the query.
I got the right row finally, though I don’t understand how it numbers them…lol
Thanks so much!!! This is only Day 2 building this for my English class, and the tutorials are old that I’ve been following. Obviously before Query was released.
Excellent
Sounds like you’re making good progress. Don’t be shy in reaching out if you need any more help.
1 Like
Thanks again. I hope I am not building something that I won’t be able to use because I will crash into a pay wall. I still don’t understand what I have to do to stay free. Just 2 versions of the same app. 100 students or less this year. What are the limits? Is it users? Can I afford to do xp and gold transactions in app w/o outgrowing it?
The main limiting factors are users, updates and row count.
You should have a good look at the Glide Pricing Page.
If you expect 100 users, then you’ll need at least a Starter Plan.
If this is for a school, then you might qualify for an Education/Non-Profit discount, but you won’t get it for free. If you scroll down to the FAQ section at the bottom of the pricing page, you’ll find a link to apply for that.
1 Like
This is very helpful information. It looks like I have to have a paid subscription already to even apply for the discount. I wish I had some idea of how many lines and updates I would produce in a month. This year, I would be doing about 90 students, but next year, it could be closer to 180. If I only use Glide data sources, do the updates still count?
Yes, updates count no matter what your data source is. The only difference with native tables is that you don’t incur additional updates for data syncs.
It can be difficult to predict how many updates your App might use, but there are strategies you can adopt to minimise them. Things like avoiding custom filters, custom forms, etc.
You can read more below:
1 Like
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.