Most of the time, itโs best to remove custom formulas or expressions from your app data source to help optimize app performance.
One particularly useful expression in Google Sheets, however, is its โGOOGLETRANSLATEโ function, that uses the Google Translate engine to quickly translate text.
By leaving that function as part of my data and then connecting it to my app as a data source, the AppSheet editor incorporated that โSpreadsheet Formulaโ into my app definition:
The result is a simple form that accepts a text input & desired translation language, and returns the translated result after having synced with the Google Sheet.
I just added a feature to this demo app that allows you to extract text from an image, to help make it easier to input the phrase youโd like to translate. (This feature is still in beta stage, please share your feedback!)
Simple steps for this update:
Here are some examples of images that might be handy to translate (try saving, then uploading it into the app to test it out).
Any plan to include Asian language to read by OCR?
OCRTEXT() impressively returns Thai language (3-lines text).
And I think itโs good for Japanese text as well. But for hand-writing, Iโm not sure.
Thanks!! The text on the bottom of the screen is correct. I donโt know what is just below the human thumb (to the left of the blue X), though. That seems to be some other language. Iโll have to play with this.
1.The human is me
2.Itโs Thai words that I filled in UX > Localize > Clear.
This is really cool feature !
เธเธญเธเธเธธเธเธกเธฒเธ! (Google translate . . . I wish I understood Thai but I donโt. )
เธเนเธงเธขเธเธงเธฒเธกเธขเธดเธเธเธตเธเธฃเธฑเธเธเนเธฒเธ (Youโre welcome, sir.)
Thanks for head up, I tested with my own language, Japanese and found out ocrtwxt function now picked up them perefectly. Obviously Appsheet dev team did something for this!
This is fantastic !
Wow! Although itโs been around for a while, I was unaware of the OCR capability until I saw this post. Hereโs some more documentation:
and
I take it, though, that as Koji has indicated, it works with the alphabet we are used to in English and not script in other languages, such as Japanese. My app is primarily for people interested in learning English, so I can use the function as is, but it really would be great if OCR capability for other languages could be added as well. With my app, it would be extremely useful for students of Japanese (Japanese as a second language), who need to convert text that they see (in books, posters, printed documents, etc.) into text they can put in their app. Iโd like to put this on my wish list. (Hoping to find it in my stocking for Christmas )
HI can I ask you what this is ? I am making apps in english for Thai staff to use , I have to enter both languages. would this , what you are talking about help me .
Thanks in Advance Devina
@Devina_Maxwell if I understand what youโre asking, this thread on localization may be helpful for you: Feature: Changing the language in your app (localization)
Thank you I appreciate it, Devina