Advanced query



  • Avatar
    Nicolas Gauvin

    Hello Joseph,

    Unfortunately, it is not possible to change the query programmatically.

    However in your specific use case maybe this article on proxies could do the trick?


    Comment actions Permalink
  • Avatar
    Joseph Vaughan


    Thank you for your reply.  That article looks like exactly what I need! 



    Comment actions Permalink
  • Avatar
    Gustavo A. Valero P.

    Great the Joseph's point!

    I'm a rookie working with proxy and try to understand how it works. According what I know as far, Awesome Table will not query the data from my spreadsheet, it will be done by proxy instead.

    If so, you will have to create a large script (maybe complex) to help/guide script to generate the table (I will lose the automation and features given by AT) when the main goal was to have a dynamic query associate to something inofensive like this:   

    - "Select * Where B = 3"  or

    -  "Select D, SUM(I) Group by D Pivot E"   -->   (my case)

    I wonder if this could be an improvement,  if AT could read the customized query from a Sheet/cell  and later work with it to generate the table, everyone will win with it. I created an image in order to help to understand my idea.

    In this way, the query can be static or dynamic depending on user or need 

    I hope it helps, regards!









    Comment actions Permalink

Please sign in to leave a comment.