I am a big Only Connect fan and I have been using the following web-app to create connecting walls: https://dev.to/terrychild/connections-3mod
The gameplay data is BASE64 encoded in the URL using the following pattern :
4|link0;clue0_0;clue0_1;clue0_2;clue0_3|link1;clue1_0...
I have created a database using Google Sheets in order to store the walls I create but I wanted to automate the process to make it easier to generate links when I enter or edit data without having to regenerate a link. I followed the instructions in the answer of the following question and it works pretty well. Encode google sheet rows into base64 string
However, the web-app doesn't decode accented characters properly when I am using an URL generated with the custom function. For example, the "é" character becomes "é", while it appears correctly when the url is created with the generator tool.
I would like to have the custom function encode the accented characters properly using the same btoa function used in the web app.
I hope you will be able to help me. Thanks a lot in advance :)
I haven't been able to edit the app script wihtout damaging the whole spreadsheet.