# COVID-19 Support app: Struggling with data, relations, etc

**URL:** https://community.glideapps.com/t/covid-19-support-app-struggling-with-data-relations-etc/5733
**Category:** Ask for Help
**Created:** [March 23, 2020, 7:22pm UTC](https://community.glideapps.com/t/covid-19-support-app-struggling-with-data-relations-etc/5733 "2020-03-23T19:22:11Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![DanielW](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danielw/32/4556_2.png) [@DanielW](https://community.glideapps.com/u/DanielW)
#### Post date: [March 23, 2020, 7:22pm UTC](https://community.glideapps.com/t/covid-19-support-app-struggling-with-data-relations-etc/5733/1 "2020-03-23T19:22:11Z")

</div>

Hi folks! Currently trying to build an app which is basically a marketplace for drinks / treats to support local businesses during COVID19 (by providing bars/cafes with revenue through giftcard purchases - doing it non-profit)

I’ve watched the tutorials but can’t figure out where I’m going wrong with the data formatting in Slides / creating relations etc.

An overview of how the UX/flow should be:

Select country page → Select City (only show cities from the selected country) → Select venue (only venues in that city) → see venue’s menu → select item → pay

Much of the infrastructure and data is there, but we’ve spent two days trying to figure out how to get it to click! I’m sure its a very simple thing but wondered whether you guys might be able to help, or point us to the right resource, please?

Also, could you please suggest how to lay out this kind of data, in terms of different sheets, or is it a row/column/array issue? so many questions!

Apologies if this is unclear - do let me know what kind of info you’d need to be able to help most efficiently.

Many thanks in advance!

---

<div class="post-metadata">

### Author: ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)
#### Post date: [March 23, 2020, 7:30pm UTC](https://community.glideapps.com/t/covid-19-support-app-struggling-with-data-relations-etc/5733/2 "2020-03-23T19:30:50Z")

</div>

- You want one sheet each for Countries, Cities, Venues, Menu Items.
- Each menu item needs a column with its venue.
- Each venue needs a column with its city.
- Each city needs a column with its country.
- Then make a multiple relation from Country to City, from City to Venue, from Venue to Menu Item.
- Then use inline lists to show the data.

Did you watch the relations videos?

---

<div class="post-metadata">

### Author: ![DanielW](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danielw/32/4556_2.png) [@DanielW](https://community.glideapps.com/u/DanielW)
#### Post date: [March 23, 2020, 7:45pm UTC](https://community.glideapps.com/t/covid-19-support-app-struggling-with-data-relations-etc/5733/3 "2020-03-23T19:45:22Z")

</div>

Thanks so much David! Yeah I watched the videos but couldn’t quite translate where I was going wrong as I couldn’t get the relations to work.

The data sheet advice should solve that! Thanks so much for your help 🙂

---

<div class="post-metadata">

### Author: ![Robert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert/32/4903_2.png) [@Robert](https://community.glideapps.com/u/Robert)
#### Post date: [March 29, 2020, 10:30pm UTC](https://community.glideapps.com/t/covid-19-support-app-struggling-with-data-relations-etc/5733/4 "2020-03-29T22:30:26Z")

</div>

Hi,

We have done something similar. LOCUS, a crowd-sourcing initiative that helps find essentials (groceries, dairy, medical etc.) near you

You can check the same here - [https://locus.glideapp.io/](https://locus.glideapp.io/)

Hope it gives you some ideas. And if you find it useful, please spread the word!

Regards,  
Team Locus
