I am trying to get user preferences from user profile to the reviews sheet for products. The form that adds data to reviews sheet does populates columns from products but not user sheet. I can use the lookup component in reviews sheet for each column on user profile but my concern is that it doesn’t sync back to sheets or create an array. Ultimate goal is to use images that will display user preferences on users review. I tried query function: =QUERY(definedrange,“select P, Q, R, S WHERE B=‘unique-email@gmail.com’”) . It works but I can’t replace the value ‘unique-email@gmail.com’ with the cell value . Has anyone been successful in using QUERY or FILTER functions? Any help is appreciated.

@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.

Hi, maybe a part of the answer: did you try to include the syntax ’ " & reference cell & " ' example: ={arrayformula (if(isblank(A2:A);""; query ( Feuille#1 ; "SELECT B WHERE A = '"& A2:A &" ’ " )))} nb: mine doesn’t work neither but for another reason :slight_smile:

In this case QUERY won’t work with ARRAYFORMULA. It will always return the result for A2.

@AyS_0908: Thanks for responding. Yes, I tried it but may be didn’t format it correctly. I am still a nb with sheets formula. Would you mind telling me if this is the correct way: =QUERY(definedrange,“select P, Q, R, S WHERE B=‘&A2&’”) If yes, it doesn’t work.

Exactly the issue I have for my case. But for the one of @S_C? (ie. without arrayformula)

Can we use QUERY and FILTER function combined. Assuming both work with arrayformula.

Use the script to copy it down here, if he has already found the right outcome for his case. [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 1/ Definition Arrayformula is defined as “a range, mathematical expression using one cell range …

I am also totally newbie on this, but in your above formula, you may try with the end written as follow: ‘"&A2&"’ (you must have " + ’ on each side)

If you’re ok with showing me the data structure you’re having in place I would appreciate it. Want to have a live look to provide better recommendations if I can.

Thanks :smiley: I will correct that. Either way I will need to join strings sooner or later.

Tutorial seems very helpful. Thanks for sharing the link. I will go through it. Sure thing! Can I send you a PM though?

Query user data on reviews form based on product sheet

Ask for Help

ThinhDinh July 4, 2020, 1:26pm 7

Use the script to copy it down here, if he has already found the right outcome for his case.

Topic		Replies	Views
How to retrieve data after duplicating and relation in Google sheets Ask for Help	17	1088	February 24, 2021
Data calculate in Data editor to Gsheets Ask for Help	10	1244	June 13, 2020
Data from a user-specific column into my google sheet? Ask for Help	26	2794	July 2, 2021
Replicate a Relation Column in Google Sheet Ask for Help	19	1260	October 5, 2021
Ability to add item to Google Sheet Report a Bug	13	672	January 9, 2021

Query user data on reviews form based on product sheet

Related topics