LinkedIn
Twitter
TRANSLATION FEATURE ADDED
Also added the translation feature via Google Translate API in compliance with ISO-639-1 Code which supports 109 languages via NMT/PBMT model.
STANDALONE WEBHOOK
A couple of members had texted me that, they have copied the app but translation feature is not working 
That’s so normal, because the app is using a standalone webhook workflow. To make it working for you; there are a couple of steps that you shall follow:
1. You need to subscribe to Google Cloud
2. You need to activate Google Translate API and generate an API Key (check it here)
3. Create a Google Apps Script (you can copy the code below), make necessary changes as per your requirements and deploy the script as a WebApp. When deploying, you shall ensure that the webapp is deployed for use of Anyone, even anonymous. Take a note of the generated webapp URL, as you will need it for your AppSheet Webhook Workflow
THE CODE
var SHEETID = "Your Sheet ID here";
var SHEETNAME = "Your Sheet Name here where you want the translation to be recorded";
var TR_COL_INDEX = 7; // The column index (A=1) in your sheet for the translation record
var API_KEY = "Your API Key here";
Logger = BetterLog.useSpreadsheet(SHEETID);
function doPost(e) {
Logger.log("Number2Text Webhook triggered...");
var payload = JSON.parse(e.postData.contents);
var string = payload.InWords;
var target = payload.TargetL;
var rowNr = parseInt(payload.RowNr);
try {
var baseURL = "https://translation.googleapis.com/language/translate/v2?key=API_KEY";
var payload = {
"q" : string,
"source" : "en",
"target" : target,
"format" : "text"
}
var headers = {
'content-type': 'application/json'
}
var options = {
"method" : "post",
"payload" : JSON.stringify(payload),
"headers" : headers
};
var response = JSON.parse(UrlFetchApp.fetch(baseURL, options));
var trText = response.data.translations[0].translatedText;
SpreadsheetApp.openById(SHEETID).getSheetByName(SHEETNAME).getRange(rowNr, TR_COL_INDEX).setValue(trText);
Logger.log("Source Language: en"+"\nTarger Language: "+target+"\nString: "+string+"\nTranslation: "+trText);
return ContentService // return json success results
.createTextOutput(
JSON.stringify({"result":"success",
"data": JSON.stringify(payload) }))
.setMimeType(ContentService.MimeType.JSON);
} catch (e) {
MailApp.sendEmail("youremail@domain.com", "Webhook Error Occured!",
"\r\nMessage: " + e.message
+ "\r\nFile: " + e.fileName
+ "\r\nLine: " + e.lineNumber);
e = (typeof e === 'string') ? new Error(e) : e;
Logger.severe('%s: %s (line %s, file "%s"). Stack: "%s" . While processing %s.',e.name||'',
e.message||'', e.lineNumber||'', e.fileName||'', e.stack||'', processingMessage||'');
throw e;
}
}
APPSHEET WEBHOOK WORKFLOW
I have the exact requirement but don't have it implemented yet in AppSheet.
I am using a workaround as follows. Assume we need to get words in Indian Rupees for the column [Total].
1. Create an Action as follows to open a URL. Use the following formula:
CONCATENATE("https://num2word.com/?number=",[Total])
Example: https://num2word.com/?number=15177.20
2. Clicking this action will take you to a website and you'll have to copy the result into the desired field manually.
This is a semi-automation.
Hello guys!
A colleague recently asked me for this tool to transform prices into text in Portuguese (Brazil). Some grammar rules are different here besides the question of prices and not numbers.
I created an application that I’m still testing but that apparently manages to correctly translate to PT-BR the price values entered with the name of the local currency (Reais / Centavos).
I’ll make it available here because I only found this forum through this colleague, so if any Brazilian looking for the same function will already be available here.
It translates numbers below 1 Billion and as it is a complex system to make the formulas were robust, but basically the app works as follows:
1- There are 2 tables, one with the names already recorded and a record of its positioning, another table where you enter the number you want to translate;
2- There is 1 virtual column to identify the size of this number and so we can separate it into Millions, thousands, hundreds and cents;
3- For each box there is 1 column that identifies the value and translates it including its end (million, million, thousand, reais, cents), each formula has between 118 and 61 lines;
4- Our last virtual column completes these values in the correct order.
Olá pessoal!
Recentemente um colega me solicitou essa ferramenta para transformar preços em texto em Português (Brasil). Algumas regras gramaticais são diferentes por aqui além da questão de ser preços e não números.
Criei um aplicativo que ainda estou testando mas que aparentemente consegue traduzir corretamente para PT-BR os valores de preço inseridos junto ao nome da moeda local (Reais / Centavos).
Vou disponibilizá-lo aqui pois só encontrei esse fórum atravéz desse colega, então caso algum Brasileiro procure pela mesma função já estará aqui disponível.
Ele traduz números abaixo de 1 Bilhão e como é um sistema complexo de se fazer as fórmulas ficaram robustas, mas basicamente o app funciona da seguinte maneira:
1- Existem 2 tabelas, uma com os nomes já gravados e um registro do posicionamento dele, outra tabela onde você insere o número que deseja traduzir;
2- Existe1 coluna virtual para identificar o tamanho desse número e assim podemos separá-lo em Milhão, milhar, centenas e centavos;
3- Para cada casa existe 1 coluna que identifica o valor e o traduz incluindo seu final (milhão, milhões, mil, reais, centavos), cada fórmula possui entre 118 e 61 linhas;
4- Nossa última coluna virtual completa na ordem correta esses valores.
APP URL Preço por extenso - AppSheet
Matheus,
Primeiramente, obrigado pela contribuição. Porém copiei o seu app no link acima e ainda apresenta problema.
Inicialmente aparece o valor correto por extenso, mas após sincronizar o registro aparece "milhões" o invés de "1 milhão". A mesma coisa acontece com "5.000" que aparece "E cinco mil".
Agradeço se puder revisar e descobrir o que está quebrando as fórmulas, pois estou tendo dificuldade em fazê-lo.
