I have a billing app that has 3 unique data - bill title, due date, and payer. Every time a biller uses the app to bill a payer, these three pieces of information are recorded. The original data, looks a bit like this: [Screen Shot 2020-05-13 at 3.47.09 PM] I’m looking for a query that takes this …

Hi ThinhDinh. Unfortunately, I get a parse Error message with that. I am not familiar with Group By queries…do you have to list every column you want included in the results after GROUP BY Aand ORDER BY for this kind of query to work? Also, there is “B” missing after ORDER BY in your query - is that…

My mistake. If you have columns from A to I, then setup a helper column in J. The query to achieve your desired result would be: =QUERY(A2:J,"SELECT MAX(A), B, C, D, E, F, G, H, I GROUP BY B, C, D, E, F, G, H, I, J ORDER BY C, D, E, F, G, H, I LABEL MAX(A)''",-1) If you have time, try Jeff’s metho…

I tried your method today. Works fine. Learned something new.

Nice to hear. Hit me up if any problem occurs.

Thank you very much for stepping in and for the suggestion, Jeff. I wanted to be on the same page with you with respect to the fact that my primary customer would be the Biller and not the Billers customer before implementing. I am not intending for any of the Billers customers to use my app - just …

Just a note, non of the following involves an additional changes within the google sheet. This is all done within the glide data editor. I was referring to the Payer, so everything I said before was assuming it was the payer signing in and seeing their own data. Yes, everything would be in the sa…

Thank you so much for the detailed response, Jeff. If my intention was for this just to be for the Biller - with no Payers having access - what would change?

Nothing really. I don’t know how you intend to display everything, but I’m picturing a simple filter on a list that only looks for ‘true’ in the if/then column. This will display the latest bill for each payer.

Thank you so much for the detailed explanation, Jeff. I am trying to implement but have a question. What do you mean by: “Then create a relation column. In the relation you would set the template column as the initial value and then select the same sheet and the same template column in that sheet.” …

Yes, the relation would like the template column in that row to the same template column in the same sheet. Yes, it’s relating to itself, but will also pick up any other rows that have the same template value. What does not work? What is the relation showing?

Help with a google sheet query for a billing app

Ask for Help

Jeff_Hager May 20, 2020, 12:19am 18

This appears to currently be a bug. I’m guessing you renamed your relation column after you created it. Delete it and recreate it with the proper name, then create the rollup column again.

Topic		Replies	Views
Conditional Relations Feature Requests	23	3520	May 4, 2023
Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1) Ask for Help	20	4208	June 21, 2020
Comparing two lookup columns Ask for Help	24	1810	February 3, 2022
🧲 The QUERY Column: One Column to Rule Them All! Ask for Help	51	2409	September 12, 2023
Filter rows in sheet based on last date entry Ask for Help	12	1067	January 17, 2024

Help with a google sheet query for a billing app

Related topics