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

Help me:
I want send data (vietnamese) to google sheet using kodular;

File: script google:

function doGet(e) {

var ss = SpreadsheetApp.openByUrl(“Your Sheet Url”);
var sheet = ss.getSheetByName(“Sheet1”);

addUser(e,sheet);
}

function doPost(e) {
var ss = SpreadsheetApp.openByUrl(“Your Sheet Url”);
var sheet = ss.getSheetByName(“Sheet1”);

addUser(e,sheet);
}

function addUser(e,sheet) {
var Name= e.parameter.Name ;

sheet.appendRow([Name]);
}

If you want to send data then simply use @AppHelper_Studio extension for that

^^^^
Just not necessary…

See here:

tested and working with accented characters on a UK locale spreadsheet. (The locale of your spreadsheet may impact on what it presented, but try it…)

3 Likes

Use this extension full guide is available

1 Like

I used Google Spreadsheet Extension v3 and Script. My block:

6
, but when I click botton2 the data is not written to google sheet
help me!

Have you change “your sheet url” to your spreadsheet link?
Can you share your script screenshot?

i use it Senddata.aia (22.1 KB)

first edit your script

function doGet(e) {

var ss = SpreadsheetApp.openByUrl(“YOUR SHEET URL”);
var sheet = ss.getSheetByName(“Sheet1”);

addUser(e,sheet);
}

function doPost(e) {
var ss = SpreadsheetApp.openByUrl(“YOUR SHEET URL”);
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("@");
}

use block uri encode text

result
viet

Test my aia and paste your url script to block…
postv.aia (3.3 KB)

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([A]);
var range = sheet.getRange (1, 1, sheet.getMaxRows (), sheet.getMaxColumns ());
range.setNumberFormat ("@");
}
}

I can’t send it to GGsheet
postvv1.aia (3.3 KB)

ID GGheet: 1QH2wsTcOUf2iJFB9OOXzrWgmih6v7LVQmX6BpjII8qw

I hope the problem is with your script url.
Did you deploy properly? After deploy and if you use the script url alone in browser , Are you getting anything?

I tried it says you have deleted the file like it says

Also in this appendRow field, what are the thing you are using in var, all should have to come followed by , separation.
Here you have used Name in var but you used [A]
In the append row :thinking:

1 Like

I want to insert in column A, is there any way

yeah sure,… refer this site

function doGet(e) {

  var ss = SpreadsheetApp.openById(e.parameter.ID);
  var sh = ss.getSheetByName(e.parameter.SH);
  var fn = e.parameter.FN;
  var rg = sh.getDataRange().getValues();

// enter A1 notation reference to return cell value
   if ( fn == 'readCell' ) {
var ref = sh.getRange(e.parameter.REF).getValue();
return ContentService.createTextOutput(ref);
  }
// enter column number (A=1/B=2/etc.) to return all values in column as a list
  else if ( fn == 'readCol' ) {
var ref = sh.getRange(2,parseInt(e.parameter.COL),rg.length-1,1).getValues();
return ContentService.createTextOutput(JSON.stringify(ref));
  }
// enter A1 notation reference to write cell value
 else if ( fn == 'writeCell' ) {
    sh.getRange(e.parameter.REF).setValue(e.parameter.DATA);
    return ContentService.createTextOutput('Value: ' + e.parameter.DATA + ' written to cell ' + e.parameter.REF);
  }

This code alone is enough. I am using this method only and the success rate is awesome. You can modify the blocks in such way what we want to do … Thanks to @TimAi2 , I am bringing. Very easy and convenient

Also see this -
http://puravidaapps.com/spreadsheet.php

or even you can use the same exsiting code by just changing at here

2 Likes

it’s not even saved to ggsheet, maybe the fault is in ggsheet

No it’s your bug . First use v.v5 version there is more features if want it’s too simple then airtable and firebase

I think you don’t choose anyone can write in sheet option? Don’t edit any script

I don’t use v5