[Free] Google SpreadSheet Extension Fastest Lite Version

Extensions
#53

this is wrong… first you need to convert into list (just interchange the blocks)

image
image880×279 75.4 KB

#54

Thank you for your support :rose: :rose: :rose:

#55

This post was flagged by the community and is temporarily hidden.

#56

Can you explain it in English

#57

Please provide documentation for GotSheet. For variables are returned, namely:

code
msg
data
total rows

What is data type for each and what do these values represent?

Does ‘data’ contain everything in the sheet? And in what format? As a dictionary or what?

Also, an example code snippet on how to parse/use data would be much appreciated.

#58

in Advance google Sheet Extension
Output Response Everything Explain in Details
code int
msg string
data string
total rows int
Read Full Article

#59

Parse Data String by using these blocks

#60

[https://kodular-community.s3.dualstack.eu-west-1.amazonaws.com/original/3X/6/9/695b010ccac383b18e1eca0a156e5fdffa6df966.png]

I used your blocks arrangement for getting data in Label component from google sheet (using your provided .aix for google sheets). I got full column data in single Label. I will feel more obliged and thankful, if you could tell me the way I can get the data of only one cell in one label, and with next button, second cell data in second label and so on. Not in a list, but navigating with Next Button. Thanks

#61

get list item position by list index block

#64

first add sheet id and google sheet is in viewer mode

#67

Hi ,
plz how to select UNIQUE in col A.
THX

#68

how to give a segmentation sign like a | in every columns in show , ex :
1 | Michael | Minesotta
2 | Klose | Newyork

an how to delete ( and ) in show , ex :
(1 Michael Minesotta) become 1 Michael Minesotta

thanks

#69

I am using the Query tool.Now what to do if I want to pass a variable defined in the app inventor as the condtion
For eg, inQ2 condition is B=Label2.Text
how to implement this

#70

B=‘Label2.Text’ text in single inverted comma.

#71

Currently, I want to retrieve data in this format:
I will select one value from column A
and I will select one column from the app, such as B, C, D, or E, and display the data that matches the row in column A and the row in the selected column.

X represents the value selected from the ListPicker, which searches for the column from the app.
For example, if the app selects X4 = column E,
then Set X(column E) where A = ‘a2’ and display the data = 1400 in the TextBox.

Screenshot 2024-07-03 090324
Screenshot 2024-07-03 090324763×311 8.12 KB

#72

This possible with “Find row function” in Advance google sheet Extension.
Find Row:
unique column is “Y1”
Find text “a2”
from column “X4”

event Return Value = 1400

#73

Extension Updated in Post Try New Version

#74

How to store data?
Is it possible or not?

#75

These Extra Function Available in Advance Google Sheet Extension

Create Sheet
Create Row
Create Column

Update row
Update cell
Update range
Delete Row

Replace All
Replace Row
Replace Cell
Remove Row

#76

How to submit Multiple Value in same column?

Example On Column A I want to submit 200 New Data at a time is it possible?