[Free] Basic Google Sheet Extension with Web Component

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

Extension not working

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
Untitled

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
Untitled

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

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

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