[Free] Google SpreadSheet Extension Fastest Lite Version

Extensions
#23

Create a new col A with autofill numbers and use select A where C =

1 Like
#24

how i dont understand

1 Like
#25

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
#26

ok i understood

1 Like
#27

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
#28

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
#29

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
#30

No it works with SELECT A B C D …Z column names only.

1 Like
#31

Extension not working

Docc
Docc1354×578 119 KB

1 Like
#32

The property Label.Visible should be true or false, but not any text

Taifun

2 Likes
#33

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??

#34

When you update aix?

#35

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
Untitled

please help me

In app text must be show … qty = 18 pcs when i filter apple

#36

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
#37

can you please give this blocks … please

#38

for what?..

#39

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
Untitled

please help me

In app text must be show … qty = 18 pcs when i filter apple

1 Like
#40

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
#41

Can I use this extension to get filterd range data from spreadsheet like a range of data in bw two dates?

#42

for get filtered range data from spreadsheet you need to take lecture of spreadsheet query and try it with this extension query block

1 Like