'Concatenate QUERY/IMPORTRANGE formula

I have made an importage formula that has multiple criterias on it (query a specific text and date time):

=QUERY(IMPORTRANGE("2WdjuvMkDmxjFT6IgQmXeQ8xn1fs5T-JkSVar86P7KdQ";"A:D");"Select Col1, Col3, Col4 Where Col3 contains 'Santa Cruz' and Col1 > datetime '2022-05-01 00:00:00'")

But now I need to concatenate 3 other columns to extract the text of each row from the main google-sheet, to one column in the new one, any ideas please?

Solution 1:^[1]

I'm not 100% certain of what you want, but here is an approach that may help you change images by scrolling.

How it works: the event listener triggers a function when the page has been scrolled. Then we use window.scrollY which returns the number of pixels that the document is currently scrolled vertically and we use this number to make the changes to the slider.

const slider = document.getElementById('slider');

document.addEventListener('scroll', (e) => {
  
  let y = window.scrollY;
  
  if(y < 100){
    slider.src = "https://picsum.photos/id/50/300";
  }
  else if(y < 200){
    slider.src = "https://picsum.photos/id/100/300";
  }
  else if(y < 300){
    slider.src = "https://picsum.photos/id/200/300";
  }
})

<body style="height:2000px">
<img id="slider" style="position:fixed" src="https://picsum.photos/id/50/300">
</body>

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Gass

'Concatenate QUERY/IMPORTRANGE formula

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]