# Query user data on reviews form based on product sheet

**URL:** <https://community.glideapps.com/t/query-user-data-on-reviews-form-based-on-product-sheet/11954>\
**Category:** Ask for Help\
**Created:** [July 4, 2020, 1:01pm UTC](https://community.glideapps.com/t/query-user-data-on-reviews-form-based-on-product-sheet/11954 "2020-07-04T13:01:40Z")\
**Posts on this page:** 5\
**Page:** 2

<div class="post-metadata">

**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\
**Post date:** [July 5, 2020, 1:08am UTC](https://community.glideapps.com/t/query-user-data-on-reviews-form-based-on-product-sheet/11954/21 "2020-07-05T01:08:24Z")

</div>

I did get reviews via form.  
See attachments. Note the number of rows (78 vs 73 after)

I am planning to redo the reviews sheet. May be I made a mistake somewhere because the template is also not showing user sheet columns like Jeff suggested.

 ![Practice Sheet V11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dd9cf3d3e0eb46c8bf093a7558c67cd7adefcb97.png) ![Practice Sheet V11 · Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f38ddea21a9dcaec1a84782da8446a9d6bda35b5.png) ![Practice Sheet V11 · Glide · 2 minutes after login to glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f41ce8f53c1fb2f549e6c1aa0793c2af4c9a2c01.png)

---

<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:** [July 5, 2020, 1:43am UTC](https://community.glideapps.com/t/query-user-data-on-reviews-form-based-on-product-sheet/11954/22 "2020-07-05T01:43:57Z")

</div>

Ok let us know if we can help further.

---

<div class="post-metadata">

**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\
**Post date:** [July 5, 2020, 1:47am UTC](https://community.glideapps.com/t/query-user-data-on-reviews-form-based-on-product-sheet/11954/23 "2020-07-05T01:47:12Z")

</div>

Your help is much appreciated!!

---

<div class="post-metadata">

**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\
**Post date:** [July 5, 2020, 7:03pm UTC](https://community.glideapps.com/t/query-user-data-on-reviews-form-based-on-product-sheet/11954/24 "2020-07-05T19:03:48Z")

</div>

@ThinhDinh: The formula you used with ARRAYFORMULA and VLOOKUP works.  
Glide was adding new review data after blank rows (around 900). I guess this was creating issues during sync and it was deleting its own content. I deleted blank rows in google sheet and now it works just fine. Thanks for your help.

---

<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:** [July 5, 2020, 10:06pm UTC](https://community.glideapps.com/t/query-user-data-on-reviews-form-based-on-product-sheet/11954/25 "2020-07-05T22:06:01Z")

</div>

Make sure you delete all empty rows from your sheets 😄

[Previous page](https://community.glideapps.com/t/query-user-data-on-reviews-form-based-on-product-sheet/11954.md?page=1)