# Help for a Newbie

**URL:** <https://community.glideapps.com/t/help-for-a-newbie/7171>\
**Category:** Ask for Help\
**Created:** [April 16, 2020, 6:40pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171 "2020-04-16T18:40:58Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 16, 2020, 6:40pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/1 "2020-04-16T18:40:58Z")

</div>

I would like to have a web based app that would allow me to do this:

I have one Google Sheet with career resources and college resources.  
I would like to have a user choose one of those two options and then have the app filter by user type: student, parent, educator.  
Thus giving the user the resources that are best suited for their use.  
I am struggling with how to set it up.

---

<div class="post-metadata">

**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 16, 2020, 7:33pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/2 "2020-04-16T19:33:06Z")

</div>

Create a sheet (“Resources”) with all resources in their own rows. Include a column for type (career/college) and another for user (st, pa, ed).

Create a second sheet (“Types”) with just the two resource types on their own rows. Feel free to add columns for description and icon.

In Glide, navigate to the data editor and go to the “Types” table. Create a MULTIPLE relation (“rel\_resource”) that links the type name with the resource type in the “Resources” table. It is case sensitive.

Next, in Glide, create a new tab that points to the “Types” table. Now, navigate to the layout view and choose a list/tile/card layout. You should see two entries: Career and College. Click on one of them and add an inline list component that points to the “rel\_resource” relation you created. You should now see all the resources for that type. Lastly, click on the inline list component and add an in-app filter (within the features tab) that points to the User type.

Done!

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 16, 2020, 8:43pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/3 "2020-04-16T20:43:35Z")

</div>

Wow Robert…

Thank you. I will try this tomorrow when I am fresh. I will let you know.

I am super appreciative of your clear explanations.

Sandye

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 20, 2020, 4:20pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/4 "2020-04-20T16:20:25Z")

</div>

Good Morning Robert,

How do I add a second sheet into my existing work?

[https://go.glideapps.com/app/7dgyEXhGH7sh11SZquOt](https://go.glideapps.com/app/7dgyEXhGH7sh11SZquOt)

Here is what I have done so far.

Sandye

---

<div class="post-metadata">

**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 20, 2020, 4:38pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/5 "2020-04-20T16:38:19Z")

</div>

Hi Sandy. That link isn’t the share link to your app so I can’t see what it is you’re referencing. Are you asking how to add a second sheet to the Google Sheet or a second tab to the app?

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 20, 2020, 6:47pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/6 "2020-04-20T18:47:43Z")

</div>

How do I share my app?

---

<div class="post-metadata">

**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 20, 2020, 6:51pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/7 "2020-04-20T18:51:50Z")

</div>

Press the blue share button in the builder, publish the app, and then send the link it generates.

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 20, 2020, 6:55pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/8 "2020-04-20T18:55:24Z")

</div>

I think I am getting closer… your instructions are helpful but I still don’t have what I was hoping for.

Sandye

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 20, 2020, 7:04pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/9 "2020-04-20T19:04:58Z")

</div>

> **[Career and College Resources](https://7dgye.glideapp.io/)**
>
> Made with Glide from a Google Sheet, without writing any code.

I really want this to work.  
J

---

<div class="post-metadata">

**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 20, 2020, 7:12pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/10 "2020-04-20T19:12:59Z")

</div>

You’re close! It looks like the types tab is still pulling all values. I assume you have an inline list after selecting a type (college/career)? Make sure that inline list is referencing the RELATION, not the SHEET (when selecting the source for the inline list, the icon should be a grey box with an arrow, not the green sheet).

If you’re not seeing (or haven’t created) the relation value, then check my instructions about the “rel\_resource”

 ![Glide_·_Create_Apps_from_Google_Sheets](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8f34d6c4a6e182074aa96afc7f1d63618406f459.png)

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 20, 2020, 8:15pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/11 "2020-04-20T20:15:05Z")

</div>

Okay… I have my career and college separated… I have my student, parent, educator user on tabs…

How do I select career and then select educator and have just those resources show up?

I can’t believe I found the inline list section.

My technology skills are not superior…

Thanks Robert…

Sandye

---

<div class="post-metadata">

**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 20, 2020, 9:18pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/12 "2020-04-20T21:18:30Z")

</div>

Hi Sandye,

Let’s chat tomorrow. Until then, make your app copiable (located in privacy/sign in settings) and I’ll take a look at it tonight!if I can.

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 20, 2020, 9:51pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/13 "2020-04-20T21:51:41Z")

</div>

You’re a lifesaver… thank you.

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 20, 2020, 9:55pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/14 "2020-04-20T21:55:48Z")

</div>

Okay Robert… I think I did it.  
J

This was a professional goal for me to make this work.

I appreciate your patience.

Thanks again~

Sandye

---

<div class="post-metadata">

**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 21, 2020, 1:43pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/15 "2020-04-21T13:43:46Z")

</div>

Hi @Sandye_Cox

Make a copy of this app: [tcgqc.glideapp.io](http://tcgqc.glideapp.io)

Use the spreadsheet that gets generated as your new one.

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 21, 2020, 2:20pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/16 "2020-04-21T14:20:48Z")

</div>

Hi Robert…

Thank you for getting that fixed. When I open the app, it only gives me the option to share, not copy.

Suggestions?

Sandye

---

<div class="post-metadata">

**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 21, 2020, 2:22pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/17 "2020-04-21T14:22:47Z")

</div>

Try now 😉

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 21, 2020, 2:35pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/18 "2020-04-21T14:35:14Z")

</div>

Yes… it let me that time. Do you think I should delete my attempt?

Sandye

---

<div class="post-metadata">

**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 21, 2020, 2:36pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/19 "2020-04-21T14:36:54Z")

</div>

Either that or replicate what I’ve done for you.

---

<div class="post-metadata">

**Author:** ![Sandye\_Cox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandye_cox/32/5681_2.png) [@Sandye\_Cox](https://community.glideapps.com/u/Sandye_Cox)\
**Post date:** [April 21, 2020, 2:52pm UTC](https://community.glideapps.com/t/help-for-a-newbie/7171/20 "2020-04-21T14:52:08Z")

</div>

Oh no, I think I am going to keep yours.

I will work on the welcome page and if you don’t mind…can I send it to you for your thoughts?

If I ever need to add to this… I just go to the data home page and add at the bottom with all the correct columns completed?

![image001.png](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3169dded2a32ed3e2cc08efc52590aea32e3879e.png)

Sandye

[Next page](https://community.glideapps.com/t/help-for-a-newbie/7171.md?page=2)
