# Creating a gamified in-app store/inventory **URL:** \ **Category:** Ask for Help\ **Created:** [February 3, 2020, 4:56pm UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225 "2020-02-03T16:56:37Z")\ **Posts on this page:** 14\ **Page:** 2
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 14, 2020, 2:30am UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/23 "2020-02-14T02:30:40Z")
Ooo…I like how you switched the button to be “greyed out” with the label “purchased”. I might just have to do something similar with purchased items or unavailable items…it might look cleaner than the emoji/rich text that I’m currently using. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 14, 2020, 2:35am UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/24 "2020-02-14T02:35:47Z")
Wait a minute…how did you get a button that does nothing when clicked? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2020, 2:59am UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/25 "2020-02-14T02:59:01Z")
I have a template column called PurchasedLink that simply contains the # character. It’s used as a URL Link action. # links are typically used to link to other locations on the same page. Since it’s a # by itself, it basically links back to itself, so the button doesn’t do anything. Credit goes to @ionamol for this trick. > [@Glide Translator and Gas Prices](https://community.glideapps.com/t/glide-translator-and-gas-prices/2578): > > Hello everyone, I just want to share these simple tests I’m creating because I think they can help the community. I created an app called Minimaker Labs, is just a sandbox to test some ideas and Glide features. [https://thelab.glideapp.io](https://thelab.glideapp.io) Right now I have 2 pages running: Transend - Translate text and send it to any telephone number via SMS or Whatsapp I used the Google Sheet function “GOOGLETRANSLATE” to translate (obviously) the text the user inputs. To send SMS with the body using the tra… ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 14, 2020, 3:25am UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/26 "2020-02-14T03:25:14Z")
Ah…yes the # html anchor. Perfect! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 14, 2020, 6:41pm UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/27 "2020-02-14T18:41:09Z")
## ⏫ Update! My gamified Glide app now includes the following features: 1. Player Profile Pages with option to follow other players 2. Guilds and guild leaderboards 3. Player leaderboards ## [itemstore.glideapp.io](http://itemstore.glideapp.io) ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [February 19, 2020, 11:05pm UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/28 "2020-02-19T23:05:18Z")
@Robert_Petitto this thread inspired me to do a few things I had been procrastinating on. I have a gamified app with in-game currency as well, all of the transactions are being calculated in the sheet of course, and was hitting the same problem with the lagginess of Glide updating potentially allowing a spend that wasn’t actually avail to the user anymore, sending balance into negative. Just sat down and using some relational columns, Glide look ups, a new check column with dummy data sent when a transaction is made, and some scripting, I’ve got a nice little “Please wait while your account cools down” alert while users wait for balances to sync up. I also began the longer task of replacing VLOOKUPS with Glide lookup techniques for instant UI updating for the user. Some of my VLOOKUP logic is a bit more complicated than what Glide can do unfortunately, but was able to replace enough of them for a more immediate experience for the user on most submitted data that’s reflected in the app. Anyway, just wanted to stop by and say thanks Robert and @Jeff_Hager. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 20, 2020, 2:00am UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/29 "2020-02-20T02:00:21Z")
Hey, that’s great to hear! Yeah, a VLOOKUP or QUERY is SO much easier than the Glide alternatives, but so much laggier which results in poor user experience. Would love to take a look some time! ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [February 20, 2020, 5:27am UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/30 "2020-02-20T05:27:35Z")
Certainly! I’m about 3 weeks away from a closed beta and I’ll give you a peek once things are moving along. Yeah… I have three different sheets that use QUERY to duplicate three other sheets so that I can have non editable versions of content for the community to read and the same versions that users can edit if they own it. It’s terribly cumbersome, a little nerve wracking as any small mistake on my part and those QUERY sheets will render as #REF and the loss of all the columns for the few minutes I’m trying to correct it could destroy huge portions of the app cause Glide deletes components of it can’t find the column anymore. And of course a lag for pretty much all of my public content. Not to mention the thousands of redundant cells digging into my 25k quota and 5M cell sheets total… And it could all be fixed with just the smallest feature: visibility conditions on that little edit pencil. But patience, I guess. This product is developing pretty fast. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 20, 2020, 11:15am UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/31 "2020-02-20T11:15:48Z")
Precisely. What I did was create the new columns in Glide first and ensured that they matched my vlookups/queries before deleting them from the sheet…cumbersome, but worth it. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 20, 2020, 5:41pm UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/32 "2020-02-20T17:41:08Z")
# **⏫ Update!** 1. Award users points for chatting [https://youtu.be/dDVZKQXAQ\_Y](https://youtu.be/dDVZKQXAQ_Y) 2. Award users points for completing daily challenges. [https://youtu.be/OqqfL8ObRy0](https://youtu.be/OqqfL8ObRy0) 3. Create an onboarding experience (only allow users access once they’ve completed a profile). [https://youtu.be/AZoLJOAfe5k](https://youtu.be/AZoLJOAfe5k) All these videos are also now available within the app. Find them in the Challenges section. After watching, you can submit a feedback form to earn XP within the app. 🤩 ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 5, 2020, 4:55pm UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/33 "2020-03-05T16:55:10Z")
How did you integrate the badge within the image on the profile page? ![glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/07ea45136155a4c399d7bc612d5374eeb17e292d.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 5, 2020, 4:58pm UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/34 "2020-03-05T16:58:15Z")
Neat little trick I developed using the Cloudinary platform. Take a look atmy posts: > [@Cloudinary: Image Filters and Overlays in Glide!](https://community.glideapps.com/t/cloudinary-image-filters-and-overlays-in-glide/4917): > > Thanks to @ionamol for keying me into Cloudinary for on the fly, URL based image editing! This awesome resource allowed me to gray out badges that haven’t yet been earned by the user— Started by uploading the image into Cloudinary and then using the built in tools to generate the new URL. Used this URL schema to create this formula: Then, simply created an if/then in Glide. If the badge was owned by the user, then use the colored URL, i… You’ll notice that the color ring matches your rank badge too! ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [March 5, 2020, 5:31pm UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/35 "2020-03-05T17:31:50Z")
This is impressive! Thank you ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 6, 2020, 3:28am UTC](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225/36 "2020-04-06T03:28:03Z")
By request, the app now has the ability to limit users from purchasing if they don’t meet rank requirements. Love this “unlocking” mechanic! ### I have silver rank with 19 gold. ![Screen Shot 2020-04-05 at 11.19.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e6439e469137f3b7dd1c233161ea4db4497acb95.png) ### Shop shows rank required: ![Screen Shot 2020-04-05 at 11.18.55 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d48892f36088645177f570fa16cfaf02778b114b.jpeg) ### This is an item I can buy (I have funds and rank): ![Screen Shot 2020-04-05 at 11.19.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/21cb90416baa51dd0bfb1b700fa29cb8444e901b.png) ### I am unable to buy this one (I have funds but not rank): ![Screen Shot 2020-04-05 at 11.19.16 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/ca4373d3c00c59f3960312ffd9ce42a6ce047a2c.png) [Previous page](https://community.glideapps.com/t/creating-a-gamified-in-app-store-inventory/4225.md?page=1)