# How to change spreadsheet data using an buttion from diffrrent screen **URL:** \ **Category:** Issues / Bugs\ **Tags:** spreadsheets, help\ **Created:** [December 7, 2023, 7:41am UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878 "2023-12-07T07:41:06Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![salmannawaz1724xjqj0](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/salmannawaz1724xjqj0/32/173858_2.png) [@salmannawaz1724xjqj0](https://community.thunkable.com/u/salmannawaz1724xjqj0)\ **Post date:** [December 7, 2023, 7:41am UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/1 "2023-12-07T07:41:06Z")
i have added an language feautures which contain four languages urdu ,spanish, and arabic , filipino , and i make spreedsheets for all of them like life hacks(urdu) life hacks (spanish ) but now i want your help on the what statement to put to to it let me give you a example : ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/b/bb0b213289cdebf3be4984049a2f209b0e64d806.png) if i select spanish its should gets the data from lifehacks(spanish) and the whole app language convert into spanish give me the statement how to do it ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 7, 2023, 10:27am UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/2 "2023-12-07T10:27:19Z")
So you want to change language in all the app and retrieve data from database ? Spreadsheet? How you store data ? ---
**Author:** ![salmannawaz1724xjqj0](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/salmannawaz1724xjqj0/32/173858_2.png) [@salmannawaz1724xjqj0](https://community.thunkable.com/u/salmannawaz1724xjqj0)\ **Post date:** [December 7, 2023, 12:41pm UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/3 "2023-12-07T12:41:19Z")
here is it my project : [Thunkable](https://x.thunkable.com/projectPage/654c48ef8523da3b8c113ff4) ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 7, 2023, 1:31pm UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/4 "2023-12-07T13:31:29Z")
Sorry i can’t see now . Anyway for translation there is a specific block (in speech block) and you can translate all the words to specific language. If you make a list with all the labels or textboxes you can set all the texts to the right language. You can use the **any block** to make a global and fast change. For the database I have to know or see what you are using now and how you stored the data . Probably this [TUTORIAL](https://youtube.com/playlist?list=PLB89L9PPGIrznDQS234PIEz4r3U8PMn31&si=EvHMZ89zy2edbuzK) can help you to start ---
**Author:** ![salmannawaz1724xjqj0](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/salmannawaz1724xjqj0/32/173858_2.png) [@salmannawaz1724xjqj0](https://community.thunkable.com/u/salmannawaz1724xjqj0)\ **Post date:** [December 8, 2023, 3:33am UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/5 "2023-12-08T03:33:56Z")
here are screenshots : ![11](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/5/c521f467c9d42a8d3ff5490a381e9b6b7f93835c.png) ![12](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/b/eb4d406354f91631141ea0c31691d5958a038d43.png) you should check my project for better understanding, ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 8, 2023, 8:44pm UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/6 "2023-12-08T20:44:24Z")
This code works with spreadsheet ?you can retrieve data from database? Is this app like a slide show or similar ? So you want to translate the text after got it from spreadsheet or you have different column for different languages? For app language I think you have to make a list with all the components (labels, textboxes,buttons) you want to translate and with the any block and translate component you can change all text with a procedure. If you have more than 1 screen you have to repeat the procedure in all the screens . I hope to post an example as soon as possible ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 8, 2023, 11:03pm UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/7 "2023-12-08T23:03:27Z")
This is a little example but you can change it according to your needs As you can see there may be some small translation error. Clicca qui per scrivere → it-en–\> click here to write (and not to mail ) [Project](https://x.thunkable.com/projectPage/65738d07a21aaceab6784710) Another way could be to save in the app or spreadsheet all the traslations of all the components, very hard work ---
**Author:** ![salmannawaz1724xjqj0](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/salmannawaz1724xjqj0/32/173858_2.png) [@salmannawaz1724xjqj0](https://community.thunkable.com/u/salmannawaz1724xjqj0)\ **Post date:** [December 15, 2023, 3:46am UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/8 "2023-12-15T03:46:58Z")
in that way i have to make many screens for every languages, like for tech hacks, i have to make tech hacks(eng) tech hacks(spanish) and languages i want to add… but i dont want this method ,provide me the logic that can change my spreadsheet data in one screen without making new screens for every data ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 15, 2023, 7:46am UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/9 "2023-12-15T07:46:59Z")
I added you a project in the last message, there is an example to made three button to change all your text using a translator , if you have also different image you have to add an additional code with an if control to set image . Example : If \*\*language to \*\* = Italian then set image.picture to x.png elfe if **language to** = English then set image.picture to y.png Etc etc etc ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 15, 2023, 7:51am UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/10 "2023-12-15T07:51:33Z")
Oh 😅 sorry But you have just different screen with different languages? If you haven’t to translate the content you have only to save the language inside e variable when user click the button . So if click English button set variable to English. When click the button to go in a screen you need a control if then else If variable =English then navigate to English screen Else If variable =Spanish then navigate to Spanish screen Etc etc ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:33pm UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878/11 "2024-11-08T13:33:12Z")