# Cart function ignores lookup fields

**URL:** <https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048>\
**Category:** Report a Bug\
**Created:** [August 15, 2020, 11:56pm UTC](https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048 "2020-08-15T23:56:49Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![zeki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zeki/32/9068_2.png) [@zeki](https://community.glideapps.com/u/zeki)\
**Post date:** [August 15, 2020, 11:56pm UTC](https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048/1 "2020-08-15T23:56:49Z")

</div>

I don’t know it’s a bug or a limitation but all lookup fields are ignored by glide except “description” on product info screen.

---

<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:** [August 16, 2020, 12:27am UTC](https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048/2 "2020-08-16T00:27:07Z")

</div>

We don’t have Stripe here to test but as far as I aware all Glide generated columns won’t show up as options in Stripe cart. It’s a limitation.

---

<div class="post-metadata">

**Author:** ![zeki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zeki/32/9068_2.png) [@zeki](https://community.glideapps.com/u/zeki)\
**Post date:** [August 16, 2020, 12:27am UTC](https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048/3 "2020-08-16T00:27:58Z")

</div>

That limitation ruined my dreams 🙂

---

<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:** [August 16, 2020, 12:29am UTC](https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048/4 "2020-08-16T00:29:47Z")

</div>

That is one big problem, when I make carts for my customers I always have to include those fields in Sheets and it’s annoying.

---

<div class="post-metadata">

**Author:** ![zeki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zeki/32/9068_2.png) [@zeki](https://community.glideapps.com/u/zeki)\
**Post date:** [August 16, 2020, 12:30am UTC](https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048/5 "2020-08-16T00:30:35Z")

</div>

I think, I will try to solve it with “VLOOKUP”

---

<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:** [August 16, 2020, 12:31am UTC](https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048/6 "2020-08-16T00:31:49Z")

</div>

Yeah, VLOOKUP combined with ARRAYFORMULA should work if you need a lookup function inside Sheets. Tell me if I can help.

---

<div class="post-metadata">

**Author:** ![zeki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zeki/32/9068_2.png) [@zeki](https://community.glideapps.com/u/zeki)\
**Post date:** [August 16, 2020, 12:33am UTC](https://community.glideapps.com/t/cart-function-ignores-lookup-fields/14048/7 "2020-08-16T00:33:02Z")

</div>

Thanks so much !  
I will definitely ask if I’m stuck.