🟩 [FREE] GS Connected - A Swiss Army Knife for Google Sheets

[dora_paz]

Maybe post a screenshot, works fine for me

[TIMAI2]

@Faraz_Firoz

I am getting html code in listview

This indicates an error with the url being sent, or the script is not setup correctly.
The error message is usually at the end of the html.

[Faraz_Firoz]

Can you please tell me what are the things we need to edit in ScriptGsConnected.txt

[Gordon_Lu]

Just copy ScriptGSConnected.txt, delete everything in the script editor and paste.

@TIMAI2

Once you have created your new apps script, delete anything in Code.gs and paste everything in the above txt file.

[Faraz_Firoz]

My steps are

But I am getting error

[SHUBHAMR69]

How can I access the data in a Cell of the Spreadsheet ?

[TIMAI2]

@SHUBHAMR69

How can I access the data in a Cell of the Spreadsheet

and just use a single cell reference, e.g. A4

[SHUBHAMR69]

But how can I assign the value (text) to a variable ?

It is a void method according to the image right ?

Edit : OK I just saw the GetFunctionOutput()

But could you make this as a value returning block in the next update ?
Cuz it becomes quite complicated to get the variables to the exact values. (I know a way though, but still it becomes quite harder.)

[Gordon_Lu]

You have an event called GetFunctionOutput. Use this concept and translate this into blocks.

if (event = GetRangeData) {
set variable to output;
}

[SHUBHAMR69]

@Gordon_Lu

You have an event called GetFunctionOutput. Use this concept and translate this into blocks.

Thanks GordonLu

[Gordon_Lu]

@SHUBHAMR69

But could you make this as a value returning block in the next update ?

No unfortunately. Return blocks are convenient, but void blocks means that it will take time to get data, and will not be returned immediately.

For example:

• TinyDB's GetValue block is a return block because it can be accessed as soon as possible, works offline.

• CloudDB's GetValue block is a void block because it takes time (milliseconds) to access the cloud.

[SHUBHAMR69]

@Gordon_Lu

it will take time to get data

Wait what ?
How much time will it take ?
Cuz I need to get the data ASAP after the button click, as the procedures are dependant solely on that data.

[Gordon_Lu]

@Gordon_Lu

it takes time (milliseconds)

If connection is slow, seconds.

[SHUBHAMR69]

How can I make a Popup display then to show :

Waiting for data.

If I get this solution, the time would not be a problem.

[TIMAI2]

You could use the Progress Dialog from the notifier. Set this in your "GET" and close it in the return event.

[SHUBHAMR69]

I'm making a different topic for this actually.

[Gordon_Lu]

@SHUBHAMR69

Popop display then to show :

Use a Notifier's ShowProgressDialog block.

call GSConnected1.GetRangeData(rangeRef = something);
call Notifier1.ShowProgressDialog(message = "Loading data...", title = "Loading...")

when GSConnected. GetFunctionOutput {
if (event = GetRangeData) {
set variable to output;
call Notifier1.DismissProgressDialog;
}
}

[TIMAI2]

@Faraz_Firoz

But I am getting error

Thank you for the video, it was very helpful.

You should give names to your spreadsheet and script, and save your script before deploying.

I do not see you being asked to authenticate your web app against your account (to give permission to access google sheets and google drive). Try creating a new version of the script to see if it asks you to authenticate.

[Faraz_Firoz]

Ok I will see it and soon I will create a video on this

[SHUBHAMR69]

@TIMAI2

What e-mail should I add to Manage People and Links ?

Asking cuz, I don't want Anyone with the link to be even a Viewer. It is because it may contain some sensitive and private data in the future, which must not be leaked.

(I haven't used it still cuz it's not the right time for me to use this extension, as the app I'm making requires me to gather many resources [mostly made by me, actually].)