[Free] Google SpreadSheet Extension Fastest Lite Version

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

#77

That’s Script Less Extension only have Read functionality in Google Sheets.

#78

@kuldeep_pilania
Hey,
I would appreciate it if you could show me the simplest form in which I present in the label the text found in cell A1,
I just didn’t understand
Is there an explanatory video?

#79

I managed
But why does it show the value with quotes?
Is it possible to display without quotation marks?

#80

image
image903×648 91.5 KB

How do I make each one be displayed in a different label?
as in the picture.

#81

if u found any extra character then you can replace it by Replacement text block

#82

I didn’t understand what you meant,
can I have picture?

#83

replaceall

By using this block u can remove extra that you don’t want…

#85

please tell how to show google sheet data in listview.
IMG_20240724_113311

#86