# Multiple entries using add to cart **URL:** \ **Category:** Report a Bug\ **Created:** [September 26, 2020, 12:36am UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382 "2020-09-26T00:36:33Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![frenat](https://avatars.discourse-cdn.com/v4/letter/f/82dd89/32.png) [@frenat](https://community.glideapps.com/u/frenat)\ **Post date:** [September 26, 2020, 12:36am UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382/1 "2020-09-26T00:36:33Z")
Is it normal behavior to add a new row for each item that’s purchased by a user? I’m using a Zapier integration to alert a user of their purchase, but it’s sending several emails if they’ve added several things to an order. Wondering if I’m doing this wrong of is this is expected behavior. ---
**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:** [September 26, 2020, 12:49am UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382/2 "2020-09-26T00:49:37Z")
That’s the way the add to cart flow works, I think the best bet is to have a query formula in another sheet to group same orders to the same row (using the unique processing link), then use Zapier on that sheet (not sure the recalculation of query would affect Zapier or not, so please beware). ---
**Author:** ![frenat](https://avatars.discourse-cdn.com/v4/letter/f/82dd89/32.png) [@frenat](https://community.glideapps.com/u/frenat)\ **Post date:** [September 26, 2020, 3:54am UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382/3 "2020-09-26T03:54:20Z")
Interesting… I’m not familiar with that. What might something like that look like? I’m thinking that new sheet would need to go look for any new entries every time new records we added. ---
**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:** [September 26, 2020, 10:13am UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382/4 "2020-09-26T10:13:36Z")
> [@Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432): > > This topic was inspired by our last community meetup, in which we talked about some formulas in Google Sheets and some people want to know more about QUERY, which was branded [“The most powerful function in Google Sheets”](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/) by famous GSheets teacher Ben Collins. So, what is QUERY, and why is it so powerful. Here’s a writeup on it, which hopefully would help many of you here in this community. Trust me, it would change so much how many of you “clean” your data in the future from raw data, in a very… > [@Tutorial - QUERY: “The most powerful function” in Google Sheets (part 2)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-2/10849): > > If you have not read part 1, below is the direct link so you can have a read at what QUERY is, and how it can help your case, whether it be building Glide apps or make your normal day work easier. > > > **6/Dynamically sort your data using ORDER BY** > > > > An ORDER BY claused can be used to dynamically sort your data after being queried, and you can change the column that is used to sort with just a letter. By default, the ORDER BY sorts ascendingly, and it can grab the data type in the column automatically.… Here are some tutorials for you regarding query. However, as I said, beware of the recalculation, which can resends for all rows and I would advise you to take some tests with dummy data first. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [September 26, 2020, 2:16pm UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382/5 "2020-09-26T14:16:26Z")
All depend on your shopping cart: Do you use the Glide one or your own one? ---
**Author:** ![frenat](https://avatars.discourse-cdn.com/v4/letter/f/82dd89/32.png) [@frenat](https://community.glideapps.com/u/frenat)\ **Post date:** [September 26, 2020, 2:17pm UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382/6 "2020-09-26T14:17:13Z")
It’s all through glide. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [September 26, 2020, 2:21pm UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382/7 "2020-09-26T14:21:08Z")
Ufff… you are doomed! 😀 ---
**Author:** ![frenat](https://avatars.discourse-cdn.com/v4/letter/f/82dd89/32.png) [@frenat](https://community.glideapps.com/u/frenat)\ **Post date:** [September 26, 2020, 2:33pm UTC](https://community.glideapps.com/t/multiple-entries-using-add-to-cart/16382/8 "2020-09-26T14:33:23Z")
HA! Is there another option to use via glide?