Template
Phrase Translations
A quick phrase translation app that utilizes the GOOGLETRANSLATE() Google Sheet expression.
Industry:
Education
Function:
Productivity
The first significant feature this app utilizes is the basic OCR option, which quickly extracts text from a photo. All you do to enable this feature is:
1. Make sure an image is being captured
2. Set the 'Initial Value' of the desired text field to =OCRTEXT([Image])
This will automatically pre-fill the text field with any identified text in the image.
For the translation part:
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, 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.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
Unique design elements of this app include a couple custom format rules, and user settings for setting a default translation language (only functional when logged in).
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...