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…

@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 h…

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 ca…

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	18	989	January 17, 2024
Data calculate in Data editor to Gsheets Ask for Help	10	1181	June 13, 2020
Data from a user-specific column into my google sheet? Ask for Help	26	2565	July 2, 2021
Replicate a Relation Column in Google Sheet Ask for Help	19	1097	October 5, 2021
Ability to add item to Google Sheet Report a Bug	13	588	January 9, 2021

Query user data on reviews form based on product sheet

Related topics