Assume I have to support 25 languages. I have a Google Spreadsheet to which I connect which has 25 sheets called English, French, Spanish … Kannada, Tulu, Hindi. Each of these sheets has messages in that language. I dont want to repeat “get row object from” 1000 times. The Row ID’s I can change via a for loop. Is there a way/trick/workaround to automatically change the language? Right now we have to manually click it and change it. I want to automate it. Please advice how I can do it?
Thanks
Ananda
Assuming your spreadsheet is built like this:
| Row | Language | Message (english letters) |
|---|---|---|
| 1 | English | How are you? |
| 2 | French | Comment vas-tu? |
| 3 | Spanish | Cómo estás? |
| 4 | Kannada | Nīvu hēgiddīri? |
| 5 | Tulu | Yīr en̄ca ullar? |
| 6 | Hindi | Aap kaise ho? |
(I typed some of these myself, so please don’t criticize if I spelled it wrong)
Instead of the get row object block, use the get first row object from block.
used one of my personal spreadsheets for this example, don’t copy
- Make a button that says “Language.” When clicked, redirect to another screen and place a Data Viewer List and set all properties
- After that, you can create a variable and store the language type the app user has selected from the Data Viewer.
- Then you can set it to
where ColumnName = userEntryVar.
1 Like
Thanks @krish05. Please note I am not using Data Viewer List. I am using individual Label/Text Boxes. Also I did more research and there appears to be no solution for my issues. I have to do it individually only. Thanks for your reply.
1 Like