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

Discuss
, ,
#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:

#41

Can you give me some time as I am busy in other project also ?

#42

yes, thank you very much, help me when you are free

#43

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

image
image532×546 21.1 KB
. matter of two min work

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

1 Like
Problem :: send data to google sheet
#44

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

#45

everything is explained here. How to send data (vietnamese) to google sheet using kodular - #8 by sugarlesscreator

Share your url link here or messages me and give me access to edit your sheet.
I will check your script.

#46
#47

see, you cannot send data with the code what you have entered in the sheet. Now i have modified it. Kindly deploy it, and try the method i suggest in the previous post. Let me knoe if it is not working for youi

#48

postv.aia (3.5 KB)

Result

1625748457256
1625748457256720×1549 99.9 KB

I’ve tried using several languages and it works.

#49

please give me the script code

#50

Is it

9
92516×1920 238 KB

#51

Got solution or should I

#52

Yups…

If your edit script, save and publish with new version again, and set who has access to the apps to anyone, even anonymous. Copy and paste url to kodular :+1:

B05010_04_06
B05010_04_06587×557 69.5 KB

#54

Which topic ?

If you are talking about this, it is not closed.

#55

sorry, my network is lagging

#56

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.