# WIP: a challenge app! **URL:** \ **Category:** Project Showcase\ **Created:** [March 28, 2020, 6:02pm UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029 "2020-03-28T18:02:03Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 28, 2020, 6:02pm UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/1 "2020-03-28T18:02:03Z")
I like sharing work in progress stuff. In the Netherlands a lot of sportsclubs do challenges, they want to keep their youth members close and active. This is my attempt to make an app for them. There are more people in this group that will do a fancier job, but I try to make my weakness my strength 😉 Here’s where I am now: [http://30Challenges.glideapp.io](http://30Challenges.glideapp.io) ---
**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 28, 2020, 6:28pm UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/2 "2020-03-28T18:28:59Z")
This is looking really good! ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 28, 2020, 6:37pm UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/3 "2020-03-28T18:37:56Z")
Thanks it is really basic, not a lot of automation, but this seems right for the usecase now. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 29, 2020, 8:11am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/4 "2020-03-29T08:11:33Z")
@Robert_Petitto There’s only one thing I would like automated that isn’t right now. Users go to a next level, get a new badge, every 30 points, or after having completed another 3 challenges. It woul be nice to have that automated. But there ends my spreadsheet knowledge 😉 ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 29, 2020, 10:00am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/5 "2020-03-29T10:00:09Z")
This is what it looks like! ![Challenges overview](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/af7e2c660d544e1f30a482b640022f30b817156d.jpeg) ---
**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 29, 2020, 11:36am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/6 "2020-03-29T11:36:38Z")
Yeah, I can help you with that! Let me know the specifics of how you want them to level up, ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [March 29, 2020, 11:38am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/7 "2020-03-29T11:38:48Z")
Looks great @erwblo! ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 29, 2020, 12:14pm UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/8 "2020-03-29T12:14:50Z")
Would be great! What I do now is this really simple. For every completed challenge you get 10 points. For every 30 points you get a badge. So Level 1 = 30, Level 2 = 60 and so on to Level 10 = 300. For me that’s enough for now, people should modify stuff the way they want. The organiser of the Challenge decide who has completed a level, in my ideal scenario giving out the badges would be automated. I do the points now in the data editor. So ‘If Challenge 1 is not empty, points = 10’. ---
**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 30, 2020, 3:22am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/9 "2020-03-30T03:22:09Z")
Right…I use that logic to automate my Ranks. Basically a big if/then. It used to be a spreadsheet formula that was much cleaner, but it was also much laggier. ![Screen Shot 2020-03-29 at 11.21.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/07da38a1047fcedbdd993ec40241bffccf24ba58.png) ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 30, 2020, 6:45am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/10 "2020-03-30T06:45:46Z")
I seem to be doing something wrong. When I do this I don’t get more than 1 badge in my If than else column. ---
**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 30, 2020, 10:36am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/11 "2020-03-30T10:36:47Z")
I assume somewhere in your app you’re totaling the number of points for each user? ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 30, 2020, 10:39am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/12 "2020-03-30T10:39:01Z")
Yeah I have a column called total where the total amount is calculated. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 30, 2020, 10:40am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/13 "2020-03-30T10:40:54Z")
Now I see the highest level they have, I would hope to get all levels? So that I can make a list and show all the levels someone has? ![Screenshot 2020-03-30 12.39.51](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2f35cfa27918a75569ff6890ad8ade4b01c37ec1.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 30, 2020, 10:45am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/14 "2020-03-30T10:45:06Z")
Yeah, I ran into that same problem too…I wanted to show all ranks earned, not just current rank. Since you’re using points for badges and not ranks, you might need a different, but related, solution. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 30, 2020, 11:23am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/15 "2020-03-30T11:23:45Z")
How did you solve 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:** [March 30, 2020, 11:39am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/16 "2020-03-30T11:39:17Z")
For Rank, I didn’t go through the trouble. For badges, here’s a snippet of the automation that I do: ![Screen Shot 2020-03-30 at 7.38.49 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/27198d480f798f9baf94c386cf1f2a46cba53527.png) ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 30, 2020, 11:42am UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/17 "2020-03-30T11:42:07Z")
Thanks, that’s out of my league 😉 ! ---
**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:** [March 30, 2020, 1:21pm UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/18 "2020-03-30T13:21:26Z")
How do you to want display the levels? You could create templates for each scenerio in markdown format (‘Level 1’, ‘Level 1 Level 2’, ‘Level 1 Level 2 Level 3’ etc.). Then use an if then to pick the proper template. Or just build rich text components for each level and set visibility on each one based on point value greater that or equal to the related point value. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 30, 2020, 1:31pm UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/19 "2020-03-30T13:31:06Z")
@Jeff_Hager Thanks, I’ll have a go at it! ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 30, 2020, 2:51pm UTC](https://community.glideapps.com/t/wip-a-challenge-app/6029/20 "2020-03-30T14:51:19Z")
I played around with templates and now show only the highest level people have. That’s good enough for now. [Next page](https://community.glideapps.com/t/wip-a-challenge-app/6029.md?page=2)