Scolring - Forum

Entraides et échanges autour de la technologie Scol - Informations and exchanges on the Scol technology

Vous pouvez changer la langue de l'interface une fois inscrit - You can change the language once registered

You are not logged in.

#1 7-Aug-2020 12:42:08

teacherone
Member
Registered: 5-Apr-2017
Posts: 36

write data into google sheets

could it be possible to write data into google sheets with openspace3d!
if it is possible . could anybody be kind to show me how to do!thanks!:)

Offline

#2 7-Aug-2020 14:38:19

arkeon
Admin. / Scol language & OpenSpace3D developer
From: Nantes
Registered: 30-Mar-2009
Posts: 5,161
Website

Re: write data into google sheets

Maybe it could be possible.
Check if an api exists for this.
Openspace 3d have all curl functions so it could be possible to write a plugit for this.

Offline

#3 9-Aug-2020 06:08:23

teacherone
Member
Registered: 5-Apr-2017
Posts: 36

Re: write data into google sheets

arkeon wrote:

Maybe it could be possible.
Check if an api exists for this.
Openspace 3d have all curl functions so it could be possible to write a plugit for this.

https://developers.google.com/sheets/api
maybe another api!
thank you!^__^

Last edited by teacherone (9-Aug-2020 14:05:48)

Offline

#4 12-Sep-2020 02:54:09

teacherone
Member
Registered: 5-Apr-2017
Posts: 36

Re: write data into google sheets

dear friend:
  still need help,
this is the google sheet on my cloud space
https://docs.google.com/spreadsheets/d/ … sp=sharing

and this is the pkos file
https://drive.google.com/drive/folders/ … sp=sharing

only objectclick2 is working

can you teach me what mistake I have made!
THANK YOU!

Offline

#5 14-Sep-2020 08:55:46

arkeon
Admin. / Scol language & OpenSpace3D developer
From: Nantes
Registered: 30-Mar-2009
Posts: 5,161
Website

Re: write data into google sheets

Hello,

I did some tests. You can use $1 $2... in url directly
https://script.google.com/macros/s/.... … ?T=$1&H=$2

then in link parameter just set the values: 38 54

It's working this way

Offline

#6 14-Sep-2020 15:38:00

teacherone
Member
Registered: 5-Apr-2017
Posts: 36

Re: write data into google sheets

arkeon wrote:

Hello,

I did some tests. You can use $1 $2... in url directly
https://script.google.com/macros/s/.... … ?T=$1&H=$2

then in link parameter just set the values: 38 54

It's working this way

Dear arkeon
I have to say I`m a stupid student!

Beause I still can not make it work, after the clue you offer to me!

can you describe more !

thank you!

Offline

#7 15-Sep-2020 09:03:38

arkeon
Admin. / Scol language & OpenSpace3D developer
From: Nantes
Registered: 30-Mar-2009
Posts: 5,161
Website

Re: write data into google sheets

In the url parameter of the call url plugit, you set the url with get params
here: https://script.google.com/macros/s/AKfy … ?T=$1&H=$2

$1 and $2 will be replaced by the parameters in call url link.

click -> Call "38 54"

Offline

#8 15-Sep-2020 15:46:56

teacherone
Member
Registered: 5-Apr-2017
Posts: 36

Re: write data into google sheets

arkeon wrote:

In the url parameter of the call url plugit, you set the url with get params
here: https://script.google.com/macros/s/AKfy … ?T=$1&H=$2

$1 and $2 will be replaced by the parameters in call url link.

click -> Call "38 54"

dear arkeon
sorry ,still not work!
I paste the link of the file
https://drive.google.com/drive/folders/ … sp=sharing
can you check what`s wrong with the file!
THANK YOU!

Offline

#9 17-Sep-2020 13:44:08

arkeon
Admin. / Scol language & OpenSpace3D developer
From: Nantes
Registered: 30-Mar-2009
Posts: 5,161
Website

Re: write data into google sheets

You don't need quotes "" in link parameter
click -> Call - param: 38 54
if you prefer

Offline

#10 27-Sep-2020 14:31:58

teacherone
Member
Registered: 5-Apr-2017
Posts: 36

Re: write data into google sheets

arkeon wrote:

You don't need quotes "" in link parameter
click -> Call - param: 38 54
if you prefer

dear friend :
still not working , but thanks for all you did!
Maybe there`s something different!
such as language or font or ...
I will try again , thank you!

Offline

Board footer

Powered by FluxBB