# Help please, In google sheet database, I have 2 sheets

**URL:** <https://community.glideapps.com/t/help-please-in-google-sheet-database-i-have-2-sheets/43647>\
**Category:** Ask for Help\
**Created:** [June 29, 2022, 12:10am UTC](https://community.glideapps.com/t/help-please-in-google-sheet-database-i-have-2-sheets/43647 "2022-06-29T00:10:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![oscarnocode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/oscarnocode/32/44389_2.png) [@oscarnocode](https://community.glideapps.com/u/oscarnocode)\
**Post date:** [June 29, 2022, 12:10am UTC](https://community.glideapps.com/t/help-please-in-google-sheet-database-i-have-2-sheets/43647/1 "2022-06-29T00:10:13Z")

</div>

Hi!!

I am creating a marketplace.

In the marketplace there are different stores.

The user decides in which store to buy.

Each store has contact information, such as address, telephone, whatsapp.

In google sheet database, I have 2 sheets.

One has the information of each store and I have called this sheet “stores”

And the other is the shopping cart, I have named this sheet “cart”

In the shopping cart I need to create a column that contains the WhatsApp of the store where the user is buying.

How can I bring the whatsapp number from the “stores” sheet and put it in the “cart”?

The first challenge I have is to recognize in which store the user is buying and depending on that information, enter the WhatsApp of the store in the “WhatsApp of the store” column located in the “cart” sheet.

Thanks

---

<div class="post-metadata">

**Author:** ![resepsionis\_ganteng](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/resepsionis_ganteng/32/39081_2.png) [@resepsionis\_ganteng](https://community.glideapps.com/u/resepsionis_ganteng)\
**Post date:** [June 29, 2022, 1:03pm UTC](https://community.glideapps.com/t/help-please-in-google-sheet-database-i-have-2-sheets/43647/2 "2022-06-29T13:03:24Z")

</div>

use “relation”

---

<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:** [June 30, 2022, 1:17am UTC](https://community.glideapps.com/t/help-please-in-google-sheet-database-i-have-2-sheets/43647/3 "2022-06-30T01:17:18Z")

</div>

I feel like there’s a missing table called “Items” here or is your “Stores” table actually containing “Items” as well?

Whatever is the case, if you are using a form for users to write their cart items into the “Cart” table, you can use a “special value” component in the form so that it automatically writes the stores’ ID or any unique info to the “Cart” table.

> **[Special Values](https://docs.glideapps.com/all/topics/values/special-values)**

Then, you will use a relation to relate the store’s ID back to the “Stores” table and retrieve the WhatsApp link using a lookup column.

> **[Relations](https://docs.glideapps.com/all/product/data-editor/relations)**

> **[Lookup Column](https://docs.glideapps.com/all/topics/computed-columns/primary/lookup-column)**
>
> Lookup values from another table