Hello !
I have achieve to put datas into a goggle sheet through a google form so if anyone need help, just see below :
Web tutorial : Tuto by Allison John ( thanks to her ).
My job :
Hello !
I have achieve to put datas into a goggle sheet through a google form so if anyone need help, just see below :
Web tutorial : Tuto by Allison John ( thanks to her ).
My job :
You know we can’t read the text in the … at the end of the text blocks?
To solve that, break the long text up and JOIN the short pieces,
to make everything visible that should be visible.
Considerate authors do individual Download Blocks as Image operations on individual blocks, to get draggable blocks that can be pulled into readers’ Blocks Editor sessions.
Yes you’re rigth !
I had not find any example so …
TIMAI2 : you link gives an easiest way to do it. ==> Thank you
Hello. I have tried to adapt your example but something must be wrong in my work.
I changed the end of the script url with /exec
Adaptation of your script :
function doGet(e) {
var ss = SpreadsheetApp.openByUrl(“https://docs.google.com/spreadsheets/d/1NYkQdZc32elE4GlCLUN3M77RMYEv2hchmtfXxzMKra0/edit#gid=0”);
var sheet = ss.getSheetByName(“Sheet1”);
addUser(e,sheet);
}
function doPost(e) {
var ss = SpreadsheetApp.openByUrl(“https://docs.google.com/spreadsheets/d/1NYkQdZc32elE4GlCLUN3M77RMYEv2hchmtfXxzMKra0/edit#gid=0”);
var sheet = ss.getSheetByName(“Sheet1”);
addUser(e,sheet);
}
function addUser(e,sheet) {
var id = e.parameter.id ;
var name = e.parameter.name ;
sheet.appendRow([id,name]);
}Exo_Ecrite_SpreadSheet.aia (1.9 KB)
Change the above to:
function addUser(e,sheet) {
var id = e.parameter.Nom ;
var name = e.parameter.Prenom ;
Hello.
I changed my way to check by doing exactly what you advise us to do on the web page :
Here is what i write in the scrpit url adding exec at the end : https://script.google.com/d/1UTv-ZvIWw-114nmoM3UynlIO8cJRt55B_thfGErl3sc3qRbKCGTlu83J/exec
Then that gives :
The script and sheet are open to any one :
and it is not runing properly.
There is surely something wrong in my copy
If i try to un derstand the scprits :
Have you republished your web app script to a new version ? Try it.
The web app ( the script ) must be integrated to the sheet i want to use or must they be separated ?
what do you mean by republuish ? I am directly working on a webpage and not on a file in my computer
The way you have coded in your script, this doesn't matter. Assuming that you have a standalone script project: "CopyDataTest":
1 Open the script project
2 Go to Publish
3 Deploy as Web App
4 Project version: - select New from the dropdown
5 Execute the app as: your google account address (email)
6 Who has access to the app: Anyone, even anonymous
7 Press the Update button
You have to do this EVERY TIME you change your script
OK ! It is running properly.
It was my first time on google scripts so … I am not used to its use.
So I must learn how to use it and how to do some scripts by my one !
If I could advise you something : you should add to your web page what you told me to do ( publishing the the sript ) it wasn’t clear for me. Peerhaps only with a screenshot !
For you information : I am doing a small app for my club to store data about some skiing, moutainering hikings.
THANK YOU !!!
RTM
Hello TIMAI2.
Now I want to add a new columln but I want to chek everything step by step so first i changed the name of the I/O as shown in the image below :
I have republished the script.
When running the APP blocks only the second value is transfered ( name ) but not the first one ( date ) .
Could you explain me why ?
If the second one has been transferd it means that the script has been published correctly. No ?
If Yes it means that the modification of the I/O names is not correct but I dont see why …
You might need to encode your date format
this also works for international characters such as accents, egrave, umlaut, etc.
Hello !
I have my answer
As I was writing you that message i had the idea that the publishing was wrong and it WAS : I have to set new version when publishing !
I assumed you had already learnt that lesson!
However, the encodeUri block is another useful tool when posting or getting data with google sheets.
The modification of the I/O name is ok now :
If I need to send more than 2 values I need to :
==> correct ?
And put the headings in the columns on the spreadsheet
naming a new column done :
I think the execution problem I have is because of the the rights I give to the execution
I say so because evene if i change the code inside thescripts with the code that is running properly on other scripts this is not running correctly so …