# Individual databases

**URL:** <https://forum.adalo.com/t/individual-databases/19588>\
**Category:** Get Help\
**Created:** [November 13, 2021, 12:06am UTC](https://forum.adalo.com/t/individual-databases/19588 "2021-11-13T00:06:03Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Estebandeath](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/estebandeath/32/13235_2.png) [@Estebandeath](https://forum.adalo.com/u/Estebandeath)\
**Post date:** [November 13, 2021, 12:06am UTC](https://forum.adalo.com/t/individual-databases/19588/1 "2021-11-13T00:06:03Z")

</div>

Hi! I’m creating an app for a store, but by now I use the same collection to store the shopping cart so I have two problems:

- When I create a sale, the shopping cart doesn’t empty, the items remain, I don’t know what I can do to delete this items when I finish the payment.
- If I log in with another user, I can see the items added by any another user so I need a different cart for each different user.

Please if somebody can help me with this I will appreciate so much! Thank you!!

Pd: sorry about my non native english

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [November 13, 2021, 12:14am UTC](https://forum.adalo.com/t/individual-databases/19588/2 "2021-11-13T00:14:33Z")

</div>

Hi @Estebandeath ,

You could relate the shopping cart collection to users, so you can filter them with logged in user, in this case others will not see the same thing.

After payment, you can mark them with boolean field, so it can be filtered for next shopping cart.

---

<div class="post-metadata">

**Author:** ![Estebandeath](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/estebandeath/32/13235_2.png) [@Estebandeath](https://forum.adalo.com/u/Estebandeath)\
**Post date:** [November 13, 2021, 12:29am UTC](https://forum.adalo.com/t/individual-databases/19588/3 "2021-11-13T00:29:24Z")

</div>

Just for know, the correct way to create a shopping cart is put all items that I select into the cart collection right? No matter that the items fill many fields or “cells” in the collection. And please, what relationship will be the best? A user can have multiple shopping carts? There is no one-one relationship ☹

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [November 13, 2021, 12:34am UTC](https://forum.adalo.com/t/individual-databases/19588/4 "2021-11-13T00:34:12Z")

</div>

Try multiple shopping carts have 1 user.

If you need more details, you can have shopping cart header and shopping cart detail.

Header can be linked to users as above, while detail linked to header.

Perhaps you can show your screenshots.

---

<div class="post-metadata">

**Author:** ![golivrob](https://avatars.discourse-cdn.com/v4/letter/g/b9bd4f/32.png) [@golivrob](https://forum.adalo.com/u/golivrob)\
**Post date:** [November 13, 2021, 12:35am UTC](https://forum.adalo.com/t/individual-databases/19588/5 "2021-11-13T00:35:20Z")

</div>

Indeed, there is no one - one. You can just go with a one to many, it’ll make the job

---

<div class="post-metadata">

**Author:** ![Estebandeath](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/estebandeath/32/13235_2.png) [@Estebandeath](https://forum.adalo.com/u/Estebandeath)\
**Post date:** [November 13, 2021, 12:49am UTC](https://forum.adalo.com/t/individual-databases/19588/6 "2021-11-13T00:49:49Z")

</div>

![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/9e4d366e880a16c7a4ee5364b1cab9b7560ae472.png)

This is how I have my custom list/shopping cart, I make the relationship that you said but is still not working as I need 😕

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [November 13, 2021, 12:57am UTC](https://forum.adalo.com/t/individual-databases/19588/7 "2021-11-13T00:57:00Z")

</div>

You make the relationship in collections, not in screens.

The steps are almost the same when you want to add fields, but this time choose relationship.

---

<div class="post-metadata">

**Author:** ![Estebandeath](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/estebandeath/32/13235_2.png) [@Estebandeath](https://forum.adalo.com/u/Estebandeath)\
**Post date:** [November 13, 2021, 1:17am UTC](https://forum.adalo.com/t/individual-databases/19588/9 "2021-11-13T01:17:06Z")

</div>

I did that but nothing yet 😕

---

<div class="post-metadata">

**Author:** ![Estebandeath](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/estebandeath/32/13235_2.png) [@Estebandeath](https://forum.adalo.com/u/Estebandeath)\
**Post date:** [November 13, 2021, 1:26am UTC](https://forum.adalo.com/t/individual-databases/19588/10 "2021-11-13T01:26:24Z")

</div>

No no, I have the relationship in collections, I just wanted to show how I show the items

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f1adc7d7c1d163a96f7329daeef03c6c7c2c4585.png)

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [November 13, 2021, 1:30am UTC](https://forum.adalo.com/t/individual-databases/19588/11 "2021-11-13T01:30:19Z")

</div>

Then in the list, you can use filter such as logged in user\>carritos.

---

<div class="post-metadata">

**Author:** ![Estebandeath](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/estebandeath/32/13235_2.png) [@Estebandeath](https://forum.adalo.com/u/Estebandeath)\
**Post date:** [November 13, 2021, 1:36am UTC](https://forum.adalo.com/t/individual-databases/19588/12 "2021-11-13T01:36:04Z")

</div>

When I do that, the list appears empty 😕

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [November 13, 2021, 1:37am UTC](https://forum.adalo.com/t/individual-databases/19588/13 "2021-11-13T01:37:34Z")

</div>

If you want to fill them, user can choose from product list and do an action to create this cart.

---

<div class="post-metadata">

**Author:** ![Estebandeath](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/estebandeath/32/13235_2.png) [@Estebandeath](https://forum.adalo.com/u/Estebandeath)\
**Post date:** [November 13, 2021, 1:58am UTC](https://forum.adalo.com/t/individual-databases/19588/14 "2021-11-13T01:58:02Z")

</div>

I can solve the problem!!! When I add a product, I did not save the current user in the relationship. Thank you so much Yongki! You helped me a lot!!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [November 23, 2021, 1:58am UTC](https://forum.adalo.com/t/individual-databases/19588/15 "2021-11-23T01:58:12Z")

</div>

Closed on November 23, 2021, 1:58am UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
