# I want to translate from English to Burmese

**URL:** <https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382>\
**Category:** Ask for Help\
**Created:** [August 25, 2023, 8:35am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382 "2023-08-25T08:35:33Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ikigai\_Edu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ikigai_edu/32/62979_2.png) [@Ikigai\_Edu](https://community.glideapps.com/u/Ikigai_Edu)\
**Post date:** [August 25, 2023, 8:35am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/1 "2023-08-25T08:35:33Z")

</div>

I would like to build a translation app. For that I have found  
this - [Translate Column](https://community.glideapps.com/t/translate-column/30668) and  
this - [Is there a way to add the Google Translate button to a site](https://community.glideapps.com/t/is-there-a-way-to-add-the-google-translate-button-to-a-site/57974).  
But I don’t quite understand the explanation from those posts and cannot implement the translation column myself yet.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 26, 2023, 2:29am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/2 "2023-08-26T02:29:10Z")

</div>

Would you want to use specifically Google Translate for your project or anything that just works? I think most of these require an API key to use, have you signed up for any API keys?

---

<div class="post-metadata">

**Author:** ![Ikigai\_Edu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ikigai_edu/32/62979_2.png) [@Ikigai\_Edu](https://community.glideapps.com/u/Ikigai_Edu)\
**Post date:** [August 26, 2023, 7:58am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/3 "2023-08-26T07:58:36Z")

</div>

No I haven’t signed up for any API keys. Currently it is translated by using with google translate like this.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0ee4f0fd3542302b666018dadfdb9194afc703f6.png)

Now I am finding ways to add two buttons. One will be to save the question and answer pair. And the other `clear button` is to clear the values in text entry and two output texts. The below image is an example.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/150dfbaa1e0096a992b9c0c4164fed3e7af4ddd6.png)

I think I can do the first one by saving values into rows in a new table. But I don’t know how I can do the second one which is to clear values. Could you please help me with that?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 26, 2023, 9:28am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/4 "2023-08-26T09:28:14Z")

</div>

> [@Ikigai\_Edu](#):
>
> No I haven’t signed up for any API keys. Currently it is translated by using with google translate like this.

That will be a very poor user experience, because you will have to wait for the translation to sync back from the Google Sheet to Glide. You’re better off using a translation service (or even one of the OpenAI integrations).

> [@Ikigai\_Edu](#):
>
> I think I can do the first one by saving values into rows in a new table. But I don’t know how I can do the second one which is to clear values. Could you please help me with that?

To clear the values, you can use a Set Column Values → Clear Value action.  
If you expect to have more than one user, you should capture the input in a User Specific column, otherwise when two or more users are interacting with your App at the same time, the values they enter will overwrite each others.

---

<div class="post-metadata">

**Author:** ![Ikigai\_Edu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ikigai_edu/32/62979_2.png) [@Ikigai\_Edu](https://community.glideapps.com/u/Ikigai_Edu)\
**Post date:** [August 26, 2023, 10:06am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/5 "2023-08-26T10:06:10Z")

</div>

I will try to use translation service like you suggested then. Could you suggest any free service for that?

To save answers, i used button with add rows action to add rows to a new table like this.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/06be850d87012ad8cdbb905fccf7dcd7d11a63e6.jpeg)

But to clear values, I still don’t understand what you mean by “Column Values → Clear Value action.” Is it this one?

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/ba491c77ef8634ea316c21d97b54e4868b10ce9d.png)

But whenever I do it like that, my button go away.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/afa45458b468097ace8eabc5ac61a676e698883e.jpeg)

Could you explain more about how to do that?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 26, 2023, 11:33pm UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/6 "2023-08-26T23:33:25Z")

</div>

> [@Ikigai\_Edu](#):
>
> But to clear values, I still don’t understand what you mean by “Column Values → Clear Value action.” Is it this one?

It’s “Set Column Values”. You can click the three dots button on a column and choose “Clear Value”.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/292f94e22b29af761698b882fbd67133cc2ee038.png)

> [@Translate Column](https://community.glideapps.com/t/translate-column/30668/19):
>
> I allowed myself to add my personal touch to the excellent code of @David. In particular a small ‘cache’, the selection of the client’s local language and a Unicode to Ascii conversion. YC link [https://glide-translate-column-Modif.manun2.repl.co](https://glide-translate-column-Modif.manun2.repl.co) YC Souce

This looks like it’s still working for me, as long as you have an API key.

> **[Using the Google Translate Key for Live Translate in Freshchat](https://crmsupport.freshworks.com/en/support/solutions/articles/50000004404-google-translate-key)**
>
> Why do you need a Google Translate Key? You need a Google Translate API Key to enable Live Translate in your Freshchat account. You can get this from your Google Cloud account. If you don’t have a Google Cloud account, you can create...

---

<div class="post-metadata">

**Author:** ![Ikigai\_Edu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ikigai_edu/32/62979_2.png) [@Ikigai\_Edu](https://community.glideapps.com/u/Ikigai_Edu)\
**Post date:** [August 27, 2023, 7:29am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/7 "2023-08-27T07:29:11Z")

</div>

Thank you for the answer. I have already got that. One thing that I noticed when using google sheet for translation is that I cannot use user-specific column with google sheet. When I synced with google sheet and then create user specific column in glide app. These columns didn’t appear in google sheets. Why is it that?

Here is the example. First I create a google sheet, which only contains two columns user\_email and name. Then I synced that with glide. Then I create new user-specific columns in glide since I cannot create them in google sheet.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/077110971f4fdb59b4d677630a3c0a6d64cc829b.png)

But after I created the columns in glide, they don’t also appear in google sheet. Is it intended? If so, how can we use user-specific columns with google sheets.

 ![Your paragraph text](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d0df4a37929f9226336f727a8d2c8f4a1e184f7b.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 27, 2023, 7:50am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/8 "2023-08-27T07:50:01Z")

</div>

User Specific Columns only exist in Glide because they contain a different value in the same row for every user. There would be no way to represent that in a Google Sheet. There are other reasons, but that’s the main one.

---

<div class="post-metadata">

**Author:** ![Ikigai\_Edu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ikigai_edu/32/62979_2.png) [@Ikigai\_Edu](https://community.glideapps.com/u/Ikigai_Edu)\
**Post date:** [August 27, 2023, 9:42am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/9 "2023-08-27T09:42:26Z")

</div>

I see. Thanks for the answer. So if we would like to build an app with multiple users and let the users only see their data, we cannot use tools like google sheet? We have to use only Glide table in this case? Also if we use Glide tables, can we also export each user data in google sheets when the user request them?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 27, 2023, 10:39am UTC](https://community.glideapps.com/t/i-want-to-translate-from-english-to-burmese/65382/10 "2023-08-27T10:39:44Z")

</div>

> [@Ikigai\_Edu](#):
>
> So if we would like to build an app with multiple users and let the users only see their data

How do you define “let the users only see their data”? It’s already the behaviour if you use user-specific columns.

> [@Ikigai\_Edu](#):
>
> Also if we use Glide tables, can we also export each user data in google sheets when the user request them?

Do you mean exporting the data through multiple tables? There should be a way to do it if you configure the right CSV structures.
