# Hi + Daily Fantasy App

**URL:** <https://community.glideapps.com/t/hi-daily-fantasy-app/32959>\
**Category:** Ask for Help\
**Created:** [October 12, 2021, 10:34am UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959 "2021-10-12T10:34:18Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Trebzz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trebzz/32/32927_2.png) [@Trebzz](https://community.glideapps.com/u/Trebzz)\
**Post date:** [October 12, 2021, 10:34am UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959/1 "2021-10-12T10:34:18Z")

</div>

Hi everyone, I’m Marc, in Ireland. For anyone here who plays fantasy sports, unfortunately Fanduel and Draftkings daily fantasy football isn’t available in Ireland yet. I’m making an app for my friends where we can easily search through players, pick and submit a team unique to each user and ideally see a leaderboard of the teams.

I’ve built a simple set of player databases with a team selector, but now need to make this unique for each user and ideally somehow collate the user scores in one tab also.

If anyone has tried this or know someone who has tried this, all tips and shortcuts appreciated!!!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 12, 2021, 11:43am UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959/2 "2021-10-12T11:43:11Z")

</div>

As someone who has played Yahoo Fantasy Basketball for 3 years I’m all for this concept. Let me know where you get stuck and I’ll try to help.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 12, 2021, 12:18pm UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959/3 "2021-10-12T12:18:36Z")

</div>

My very first Glide project was a Fantasy Golf app, so this sort of thing is definitely doable 👍

---

<div class="post-metadata">

**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\
**Post date:** [October 12, 2021, 1:11pm UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959/4 "2021-10-12T13:11:00Z")

</div>

A colleague of mine was building something similar with NFL/College Fantasy and I remember he used this API in his app:

> **[Sports Data API Solutions | NFL API , NBA Data, MLB Data API](https://sportsdata.io/)**
>
> Live sports data provider with scores, odds, projections, stats, news, and images for NFL football, MLB Baseball, NBA Basketball, NHL Hockey, PGA Golf, NASCAR, Soccer, and ESports. SportsDataIO provides sports API feeds and database downloads to...

However, you would need a way to get data from their API imported into your Google Sheet, thus keeping your Fantasy Glide app updated for your users.

Cool idea, hope your build goes well!

---

<div class="post-metadata">

**Author:** ![Trebzz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trebzz/32/32927_2.png) [@Trebzz](https://community.glideapps.com/u/Trebzz)\
**Post date:** [October 12, 2021, 1:30pm UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959/5 "2021-10-12T13:30:36Z")

</div>

Thanks very much for saying this!

Right now I’m just at the beginning so apologies if this is rookie stuff.

I’m a bit stuck at setting things up so unique users can submit their own unique lineups. I’ve been able to build a basic database of the players and a selector, but just haven’t figured out how to allow each unique user to make their own selections.

The other piece I can’t figure out is there are conditions within team building. Each player has a budget value and your team needs to stay under a budget. I can show the SUM of the team cost by working on the google sheet but I’m finding it hard to set conditions like “can’t pick the same player twice” or “cant submit this team unless you’re under budget”.

 ![Screen Shot 2021-10-12 at 2.53.34 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/18562b4f5b2817370ac14a431386bb0e5fd7b903.jpeg)

---

<div class="post-metadata">

**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\
**Post date:** [October 12, 2021, 1:31pm UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959/6 "2021-10-12T13:31:27Z")

</div>

Hi, Marc & Welcome to the Community!  
LM. Paris, France.  
Enjoy your Glide 🌸

---

<div class="post-metadata">

**Author:** ![Trebzz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trebzz/32/32927_2.png) [@Trebzz](https://community.glideapps.com/u/Trebzz)\
**Post date:** [October 12, 2021, 1:31pm UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959/7 "2021-10-12T13:31:32Z")

</div>

Yea if I get to live updating data I will be stoked. Those APIs can be expensive though and this is for casual use w friends right now.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 12, 2021, 2:41pm UTC](https://community.glideapps.com/t/hi-daily-fantasy-app/32959/8 "2021-10-12T14:41:35Z")

</div>

> [@Trebzz](#):
>
> I’m a bit stuck at setting things up so unique users can submit their own unique lineups. I’ve been able to build a basic database of the players and a selector, but just haven’t figured out how to allow each unique user to make their own selections.

I would advise you to firstly setup and configure [User Profiles](https://docs.glideapps.com/all/reference/security-and-per-user-data/user-profiles), and (probably) set your app [sign-in method](https://docs.glideapps.com/all/reference/security-and-per-user-data/controlling-who-can-access-your-app) to Public with Email.

Then when your users submit their selections, you won’t need to ask for an email address as you’ll be able to automatically capture that based on the signed in user.

You’ll probably want a separate table to capture the user selections - one row for each user. So the form shown in your screen shot would add a row to that table as each user submits.

How often will your users be making selections? Will it be a weekly thing? You should have a think about you want to handle “old” selections. If you’re intending to keep this as a free app, then the 500 row limit will very quickly come into play.
