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

Discuss
, ,
#21

can you ping me to resolve your prob

1 Like
#22

please help me

1 Like
#23

If there is freely extension available why you use web ?

#24

that extension was decompiled

#25

I used v3 but it didn’t work

#26

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 .

#27

From what I understand the special characters aren’t getting stored… Right ?

#28

yes, accented characters

#29

No they store well :heart: but don’t use ", "in cell if you want then use replacment block

#30

refer to this

#31

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

#32

the problem is not in the script its in the way how u post and get text

#33

8
8821×355 18.7 KB
Uploading: 8.PNG…

#34

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

Screenshot_2021-07-08-10-35-31-642_com.google.android.apps.docs
Screenshot_2021-07-08-10-35-31-642_com.google.android.apps.docs1080×2400 452 KB

#35

When you get text use the uri decode block

#36

Then it should work

#37

yes, i want to save in column A

#38

But it’s not compulsory :roll_eyes: decode text .

#39

Ok let me create a new script for same sheet

1 Like
#40

its compulsory :roll_eyes: