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
| User | Count |
|---|---|
| 18 | |
| 14 | |
| 11 | |
| 7 | |
| 4 |
