# Quick tip please! How to extend a list

**URL:** <https://community.glideapps.com/t/quick-tip-please-how-to-extend-a-list/22543>\
**Category:** Ask for Help\
**Created:** [February 10, 2021, 10:56am UTC](https://community.glideapps.com/t/quick-tip-please-how-to-extend-a-list/22543 "2021-02-10T10:56:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\
**Post date:** [February 10, 2021, 10:56am UTC](https://community.glideapps.com/t/quick-tip-please-how-to-extend-a-list/22543/1 "2021-02-10T10:56:11Z")

</div>

I have a table with a list of room names: column A = room name.  
The unique room owner resides in column B.

So far so good. I would now like to define Column C so that each room contains a corresponding list of guest names, e.g. each cell contains a list. I assume each cell will be a list of names and that I can use a component with a pick-list of names that allows the room owner to add a guest name to the list.

Any tips on how to do this please? I am familiar with forms, choice components and relations but I have never had a component that can add to list. Do I need to work up a relation? I have never worked with arrays before… maybe this will be answer!

Thanks in advance for your time.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [February 10, 2021, 11:06am UTC](https://community.glideapps.com/t/quick-tip-please-how-to-extend-a-list/22543/2 "2021-02-10T11:06:51Z")

</div>

Hola @Simon_Hill

I would do it this way:

1. set up a log sheet where room owner have all the room guests (guests should be a column as well). In that sheet you need to have either the room owner or the room ID

2. on the room sheet, make a relation that matches either the room owner or room ID in the log tab.

3. in the room sheet, create a joined list column against that relation and bring the guests to your room sheet. Now you can display that list.

I hope this helps.

---

<div class="post-metadata">

**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\
**Post date:** [February 10, 2021, 11:50am UTC](https://community.glideapps.com/t/quick-tip-please-how-to-extend-a-list/22543/3 "2021-02-10T11:50:47Z")

</div>

Sorry I don’t follow this.

Either I have to add a list of rooms into a cell corresponding to a name in the user sheet. Or I have to add a list of names into a cell corresponding to a room in the rooms sheet. Either way, I need to be able to add to a list within a cell… the relation will not work without doing that.

Regards,  
Simon.

---

<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:** [February 10, 2021, 11:58am UTC](https://community.glideapps.com/t/quick-tip-please-how-to-extend-a-list/22543/4 "2021-02-10T11:58:34Z")

</div>

If the length of the guest list for any given room is variable, then probably the best way to handle this is with a 2nd sheet (which is what @SantiagoPerez is suggesting).

In that sheet you have two columns:

- Room ID
- Guest ID

The sheet will have one row per guest/room combination.  
To get a list of guests in any given room, create a multi-relation linking the room ID in this sheet back to the same room in your original sheet.  
You can probably figure out the rest 🙂

---

<div class="post-metadata">

**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\
**Post date:** [February 10, 2021, 12:00pm UTC](https://community.glideapps.com/t/quick-tip-please-how-to-extend-a-list/22543/5 "2021-02-10T12:00:01Z")

</div>

It took me a while… but I get it. Thanks so much!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/quick-tip-please-how-to-extend-a-list/22543/6 "2024-01-17T16:53:27Z")

</div>


