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

[TimAi2 (metricrat)]

@develop_think

use @AppHelper_Studio extension

^^^^
Just not necessary…

See here:

• Google Sheets - Simple POST and GET Data

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…)

[Jinx]

Use this extension full guide is available

(Free) Simple Google Spreadsheet Extension V3

Hello Friends, Today I Am Going To Provide You A Simple Google Spreadsheet Extension. After Use This Extension You Can Connect Your App With Google Spreadsheet Database. Try This Extension And Tell Me Your Response. A Very Big Thanks To TCFGameYT For Helping Me Of Create This Extension. Release date:2021-04-27T18:30:00Z (UTC) Developed By App Helper And TCFGameYT Note:- My English Is Not So Good So Please Adjust. Some Block Images [Captur…

[HaAnh_DC]

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

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

[sugarlesscreator]

@HaAnh_DC

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

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

[HaAnh_DC]

i use it Senddata.aia (22.1 KB)

[sugarlesscreator]

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

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

[HaAnh_DC]

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

[Still-learning (1-2-3-4...)]

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

[Still-learning (1-2-3-4...)]

@HaAnh_DC

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

sheet.appendRow([A]);

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

[Still-learning (1-2-3-4...)]

[HaAnh_DC]

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

[Still-learning (1-2-3-4...)]

yeah sure,… refer this site

METRIC RAT AI2 - Google Sheets for AppInventor

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

[Tekwizer (ArnaV Bhardwaj)]

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

[Still-learning (1-2-3-4...)]

@HaAnh_DC

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

sheet.appendRow([Name]);
var range = sheet.getRange (1, 1, sheet.getMaxRows (), sheet.getMaxColumns ());
range.setNumberFormat ("@");
}
}

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

[HaAnh_DC]

@HaAnh_DC

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

sheet.appendRow([Name]);
var range = sheet.getRange (1, 1, sheet.getMaxRows (), sheet.getMaxColumns ());
range.setNumberFormat ("@");
}
}

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

[develop_think (Aashi $hármâ)]

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

[develop_think (Aashi $hármâ)]

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

[HaAnh_DC]

I don’t use v5

[Still-learning (1-2-3-4...)]

can you ping me to resolve your prob

[HaAnh_DC]

please help me