How to send data (vietnamese) to google sheet using kodular

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 :joy: 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 :heart: 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

Uploading: 8.PNG…

Is this your sheet from where you want to get and store data in this same sheet

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 :roll_eyes: decode text .

Ok let me create a new script for same sheet

1 Like

its compulsory :roll_eyes:

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

image
image

p.s, you need to make this change to make it effective

. matter of two min work

pls refer: METRIC RAT AI2 - Google Sheets - Simple POST and GET Data

1 Like

i think u forgot to done puslish as a web app… OR
check this simple method