Accent from mit app inventor to google sheet

[Bastien D.]

Hello everybody !

I have an application that communicate with Google Sheets. I post text from app inventor to my google sheets.

To do that I have one Web componement which is calling a script with .PostText

Here is the script :

function doPost(e){
 
  var ss = SpreadsheetApp.openByUrl("#URLOFGOOGLESHEETS")
  var sheet = ss.getSheetByName("Valeurs");


  addText(e,sheet);


}


function addText(e,sheet) {


  var Date = e.parameter.Date;
  var NumeroDeChantier = e.parameter.NumeroDeChantier;
  var LieuDeChantier = e.parameter.LieuDeChantier;
  var Operateur = e.parameter.Operateur;
  var NumeroDessai = e.parameter.NumeroDessai;
  var Emplacement = e.parameter.Emplacement;
  var TypeSol = e.parameter.TypeSol;
  var TypePlaque = e.parameter.TypePlaque;
  var Commentaires = e.parameter.Commentaires;
  var Essai = e.parameter.Essai
 
  sheet.appendRow([Date, NumeroDeChantier, LieuDeChantier, Operateur, NumeroDessai, Emplacement, TypeSol, TypePlaque,Commentaires, Essai]);

It works but not when I send a word with an accent.

My question is : How can I send text with accent to the google sheets?

Thank you so much for your answer !!!

Bastien.

[TimAI2]

Possibly?:

https://stackoverflow.com/questions/19976532/how-do-i-fix-charset-problems-in-gs-script

Try adding .getDataAsString('ISO-8859-1')   < or another more suitable character set

to your parameters or the whole of "e" in your apps script

[Bastien D.]

I try it and it doesn't work sadly :(

[TimAI2]

Let me do some more investigation...

[TimAI2]

While i am looking try:

.getDataAsString()

(nothing in the brackets)

[TimAI2]

I have just tested a google apps script that sends to a google sheet and sent it a string of accented characters which arrived OK on the spreadsheet

Admittedly I used the browser and not an app...

[Bastien D.]

I exactly do the same and it works too.

The problem comes from the communication bettween App inventor and the script.

 

Is the problem come from "sending data's" ? Or receiving data's ?

I tried to post the text with different Encoding but nothing works. 

[Peter Mathijssen]

What if you replace your accent character with the responding ascii code and in your google script replace the code with the character? Maybe that's done automatic. Never tested it just an idea.

https://theasciicode.com.ar/extended-ascii-code/letter-e-acute-accent-e-acute-lowercase-ascii-code-130.html

[Bastien D.]

Sorry i don't understand clearly !

What should I send ? 
And how can I replace it ?

[Bastien D.]

I try to send character with encoding ASCII and it returns "?"

[Peter Mathijssen]

Can you show what you did?

Is this helpfull?

https://groups.google.com/forum/#!msg/mitappinventortest/404FUnScIyY/UoDm3yWpCwAJ

[TimAI2]

Solution: use the uriencode block on your parameter only:

e.g.

[Bastien D.]

Oh thank you so much , it works perfeclty !!!! 

I tried to do that but before the block "join" :( !!

Have a nice day :)