Hi,
Is there someone who did a Yes code column to translate another column ?
Thank you
2 Likes
Thee we I would be a lovely add-on to Glide apps - great idea!
Here you go: https://replit.com/@dvdsgl/glide-translate-column
14 Likes
excellent,
thanks david
1 Like
Amazing thanks a lot @david
1 Like
If I can afford Master David,
as it is a paid API (well after a while), is it possible to add a Cache, to avoid a call to the API each time the YC column is refreshed
2 Likes
I have forked the code (big thanks 
) but my forked version (unchanged from the fork) does not allow me to save - any ideas?
(and I am putting my own API key in 
Thanks!
Hi @Mark_Turrell
(itâs late for david 
)
Maybe I can answer you.
For the 1st image, rename manifest.json to glide.json
For the 2nd
Test with lowercase âfrâ
@Mark_Turrell it also looks like you are using my repl still.
Canât remember how to convert a format
âC' ;est super ce trucâ in
âCâest super ce trucâ
We have encodeURI to encode, to reverse this does decodeURI help?
Hi @ThinhDinh
no it didnât work
The Google translation API probably has a parameter to control the response format. By default this looks like HTML escaped text.
1 Like
I did a test with this, but itâs still pariel.
âContent-Type: application/json; charset=utf-8â
Thatâs not the API.
Itâs me then
Iâm not having much luck with Google APIs 
Well I made an old-fashioned conversion
function unicode2Ascii(str) {
var code = str.match(/&#(\d+);/g);
if (code === null) {
return str;
}
for (var i = 0; i < code.length; i++) {
str = str.replace(code[i], String.fromCharCode(code[i].replace(/[&#;]/g, '')));
}
return str;
}
1 Like
I allowed myself to add my personal touch to the excellent code of @David.
In particular a small âcacheâ, the selection of the clientâs local language and a Unicode to Ascii conversion.
YC link
https://glide-translate-column-Modif.manun2.repl.co
YC Souce
12 Likes
âCâest vraiment super ce trucâ 
Thanks @Manu.n for you code
2 Likes