Use Queries to show records based on conditions

Follow

Comments

17 comments

  • Avatar
    Gustavo A. Valero P.

    Hi,

    I have a little problem using LABEL and ORDER clauses at the same time.

    If I write:

    SELECT A, C, D ORDER BY D       -->   the query works fine

    but with:

    SELECT A, C, D LABEL A ' Name', C 'Phone' ORDER BY D   -->   the query sends an error message!!

    Is there a little bug or I'm missing anything? 

    Thanks in advance for your help!

    Gavp

    BTW...  great web site, product and ideas, congratulations!!

  • Avatar
    Awesome Table

    Hello Gustavoavalerop,

    Actually, when you use SELECT and ORDER, ORDER must be just after SELECT. I suggest you use:

    SELECT A,C,D ORDER BY D LABEL A 'Name', C 'Phone'

    It should work with this method.

    Kind regards.

    Thomas

  • Avatar
    Gustavo A. Valero P.

    Hi Thomas,

    Yes, you are right, now my query works correctly!

    Thanks

    Gavp

  • Avatar
    Lasse Soininen

    Is it possible to pass query via URL parameter? We would like to limit returned results to a UID that would be passed in the URL view?UID=123456789

    Query: select * where UID = {{GET_UID}}

  • Avatar
    Awesome Table

    Hello,

    Unfortunately this is not possible with Awesome Table.

    Nicolas

  • Avatar
    Sean Gillard

    Great Article! it helped me on some of the things I have been working on.

    I have one that I'm asking it to essentially filter more. But once I get to a certain point, Then the rest stops working. What am I doing wrong?  In the below formula, A is bringing me Active and inactive. Manager sometimes shows up and sometimes doesn't depending on if I add the Active one or not. Is there a specific way this order should be to make it work?

    =QUERY(Lookup!A:Y, "select B, E, F, O, P, Q, W, X where B = 'Operations' and W = 'Supervisor' or W= 'Lead' or W = 'Manager' and A = 'Active' ")

     

     

    Sean

  • Avatar
    Thomas Morin

    Hello Sean Gillard,

    Actually, your syntax is not correct. You don't need to use"=QUERY(Lookup!A:Y...".

    Your query must be like this:

    select B, E, F, O, P, Q, W, X where B = 'Operations' and W = 'Supervisor' or W= 'Lead' or W = 'Manager' and A = 'Active' 

    In this way, it will work because that's the correct syntax.

    Thank you.

    Thomas

     

  • Avatar
    Jennifer Prusak

    I am super new at this. Is there a way to make it so as you filter results in the drop-down filters that the other filters would be dynamic and update with only content relative to the filter before it? If so where would you beginning to set that up?

     

    Thank you so much for your help!  Jen

  • Avatar
    Nicolas Gauvin

    Hello Jennifer,

    You could achieve this with CSV and Category filters using dependent filters.

    Please let me know if that helps!

    Nicolas

  • Avatar
    Deepak

    Dear All,

    I am making something similar to the board games template but to display reports. But i need to add a button with hyperlink for a report instead of complexity. Please help me with the code. 

  • Avatar
    Thomas Morin

    Hello Deepak,

    I suggest you use a buttonType and place it between markers in your template sheet at the correct location in your code.
    However, it requires knowledge in CSS code and HTML code.

    Kind regards.

    Thomas

  • Avatar
    Dave HUDDART

    Hello

    Is it possible to SELECT rows that are not duplicates (based on value in a specified column)?
    I can deduplicate in Google Sheets, but was wondering if I could do it in an Awesome Table view.

    Best regards

    Dave

  • Avatar
    Thomas Morin

    Hello Dave HUDDART,

    It is definitely possible to select rows depending on specific term or criteria. You should consult this part of this article to know how to achieve that.

    Kind regards.

    Thomas

  • Avatar
    Brandon Carraway

    🙌🙌

    The SORT option was VERY helpful; I needed newest data at the top, and doing this through Google Sheets is tedious. This saved me SO much headache!!! ❤❤

  • Avatar
    Thomas Morin

    Hello Brandon Carraway,

    Thank you for your message! 

    We are really glad you like our product and you find it is useful.

    Kind regards.

    Thomas

  • Avatar
    Luís Esteves

    Hi,

    Is it possible to add a button to sort the results in diferent ways ? I'd like to have the possibility to sort by one colums (alphebeticaly) or a diferent way by clicking on a button.

     

    Thanks !

  • Avatar
    Nicolas Gauvin

    Hello Luis Esteves,

    There are no ways to change the sorting or query with a button.

    Nicolas

Please sign in to leave a comment.