I used v3 but it didn’t work
I used Google sheet in my 2 apps it’s work fine but there is some features actually bugs like ( if you use , in your cell it’s consider it a new line .
From what I understand the special characters aren’t getting stored… Right ?
yes, accented characters
No they store well but don’t use ", "in cell if you want then use replacment block
refer to this
function myFunction() {
function doGet (e) {
var ss = SpreadsheetApp.openByUrl(“KODULAR - Google Sheets”);
var sheet = ss.getSheetByName(“Sheet1”);
addUser (e,sheet);
}
function doPost(e) {
var ss = SpreadsheetApp.openByUrl(“KODULAR - Google Sheets”);
var sheet = ss.getSheetByName(“Sheet1”);
addUser (e,sheet);
}
function addUser (e,sheet) {
var Name = e.parameter.Name;
sheet.appendRow([Name]);
var range = sheet.getRange (1, 1, sheet.getMaxRows (), sheet.getMaxColumns ());
range.setNumberFormat ("@");
}
}
please check it for me
the problem is not in the script its in the way how u post and get text
When you get text use the uri decode block
Then it should work
yes, i want to save in column A
But it’s not compulsory decode text .
Ok let me create a new script for same sheet
its compulsory
Can you give me some time as I am busy in other project also ?
yes, thank you very much, help me when you are free
ok, i am sharing you very simple one. there by you can send only one text box value to the sheet.
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
function doPost(e) {
var data = JSON.parse(e.postData.contents);
sh.appendRow(data);
return ContentService.createTextOutput(data);
}
function doGet(e) {
var data = JSON.stringify(sh.getDataRange().getDisplayValues());
return ContentService.createTextOutput(data);
}
decompile it, and use this block to send whatever type of letters to gsheet
p.s, you need to make this change to make it effective
pls refer: METRIC RAT AI2 - Google Sheets - Simple POST and GET Data
i think u forgot to done puslish as a web app… OR
check this simple method