User col index ? Which mean, for every user you are using col.?? We and all use only row
To make us clear show your gsheet screenshot
1 Like
Create a new col A with autofill numbers and use select A where C =
1 Like
how i dont understand
1 Like
No man, in col A right click , create a new col left side… so existing data will be moved one col to right side
1 Like
ok i understood
1 Like
Great extension
@Kuldeep_Pilania
Can you add some more blocks for delete row
if possible
Like In Coloum A there are 5 Xyz and some others
I want to delete all 5 xyz at same time
1 Like
New Blocks Added in V2
Create Sheet
Create Row
Create Column
Update row
Update cell
Update range
Delete Row
Get Sheet
Get Columns
Get Range
Apply Formula
Apply Filter
SQL Query
Find Row
Replace All
Replace Row
Replace Cell
Remove Row
7 Likes
can i use this type query?
like
SELECT
id,
(
3959 *
acos(cos(radians(37)) *
cos(radians(lat)) *
cos(radians(lng) -
radians(-122)) +
sin(radians(37)) *
sin(radians(lat )))
) AS distance
FROM markers
HAVING distance < 28
ORDER BY distance LIMIT 0, 20;
2 Likes
No it works with SELECT A B C D …Z column names only.
1 Like
The property Label.Visible should be true or false, but not any text
Taifun
2 Likes
Good and useful extension help me to get needed queries.
I need select query like example 5 but when get result in list all selected column show in first element of list??
When you update aix?
hello,
Please see my att file
there i need to show apple qty subtotal …or price subtotal how can i do this in my app single text
please help me
In app text must be show … qty = 18 pcs when i filter apple
Try this query
SELECT SUM(B) WHERE A = ‘apple’ GROUP BY A
The question however is: is the extension able do do it?
Taifun
2 Likes
can you please give this blocks … please
for what?..
Please see my att file
there i need to show apple qty subtotal …or price subtotal how can i do this in my app single text
please help me
In app text must be show … qty = 18 pcs when i filter apple
1 Like
already @Taifun suggested… set the following as your web url + use call web1.get
… in wheb got text, you will see the result… Before testing it, in the url change the csv as html and run in your browser and see the response then try…
https://docs.google.com/spreadsheets/u/0/d/{sheetID}/gviz/tq?tqx=out:csv&sheet={SheetName}&tq=SELECT SUM(J) WHERE I = 'apple'
2 Likes