Sheetgo connection with condition in another tab


#1

Guys
How do I pull data using sheetgo query SQL if my condition is location at another tab. See example below. The data I want to full is at ‘WO Finish’!A:N but the contion AM1 is at another sheet named WO.

=QUERY(‘WO Finish’!A:N,“SELECT A,C,H,I,J WHERE A > DATE '”&TEXT(AM1,“YYYY-MM-DD”)&"'AND G=‘MY A2’ AND B=‘Fresh’")


#2

Hi @desmondlee

As I mentioned Sheetgo does not actually read information from your spreadsheets. It’s as we call it “Secure by Design”. We only process metadata, and your information never actually leaves your Google Drive.
The downside to that is we cannot do the type of query you are describing (data dependent). If you only need it to be time dependent we can do it.

One thing that could be done, regarding the amount of data, is to create two connections:

  • The first to bring dinamic info from AM1
  • The second to bring: SELECT A,C,H,I,J WHERE G=‘MY A2’ AND B=‘Fresh’

Then on this new spreadsheet create the original query with the dynamic date field.