Programmatic Query Builder for Google Sheets - Sheetstopia

	B	C	I	L	O	P	Q	R	S	T	U	V	W	X	Y	Z	AB	AD	AE
1			Troubleshooting:	Error								Remedy
2			#VALUE	Unable to parse query string for Function QUERY parameter 2: CANNOT_BE_IN_GROUP_BY: Col#								Uncheck "Group By" for the col							http://www.sheetstopia.com/
3			#VALUE	Unable to parse query string for Function QUERY parameter 2: ADD_COL_TO_GROUP_BY_OR_AGG: Col#								Check "Group By" or add an agg for the col							http://www.sheetstopia.com/
4			#VALUE	Unable to parse query string for Function QUERY parameter 2: CANNOT_GROUP_WITHOUT_AGG								Include an agg for one of the fields in column R							©️ 2024 Sheetstopia
5			#VALUE	Unable to parse query string for Function QUERY parameter 2: NO_AGG_IN_ORDER_WHEN_PIVOT: Col#								Remove the "order by" instruction for the column							PQB_v1
6			#VALUE	Unable to parse query string for Function QUERY parameter 2: COL_IN_ORDER_MUST_BE_IN_SELECT: Col#								An "order by" instruction is given for a field without the select checkbox ticked; check the select box or remove the "order by"
7
8
9
10	Query Text (+ overrides)		Selections														Query Result
11	Query Text (+ overrides)		Selections														Query Result
12
13	Query text - natural		Sheet:		Limit	#avail				Date Entry		Date presets	days	FALSE
14	select Check limit 150		Transactions-S		150	111				1/1/2024		ALL						Caution: This query has a limit applied - refer to the Selections panel 'Limit' value
15			Sheet Range:							3/31/2024
16			Transactions-S!A1:K			◀ Select ALL			Note: Use short dash symbol: - for empty. Ex. <> - for filtering out empty values
17
18	Query text - Col style								>=		<=
19	select Col1 limit 150				select				where				group by	pivot	order by
20					Adder				and/or	and	Adder
21
22	Override - Complete QUERY		Columns	Num	select	rank	dbl	agg/scalar	operator	value	operator	value			asc/desc	rank		Check
23			Check	Col1
24			Date	Col2
25	clause	statement	Description	Col3
26	select	Col1	Category	Col4
27	where		Amount	Col5
28	group by		Tags	Col6
29	pivot		Account	Col7
30	order by		Account #	Col8
31	limit	150	Institution	Col9
32	label		Transaction ID	Col10
33			Date Added	Col11
34	order by override
35
36	label overrides
37	Col1
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100