Copy and paste text between fields

Hi, I want to do an Action that apparently should be very simple but no matter how much I use I can't find the way to do it.What I want to do: copy and paste the text from one field to another. In Google sheets I have a cell that "SUM" the text of the previous 4 cells with this formula: 

=B2&" "&C2&" "&D2&" "&TO_TEXT(E2)


The problem is that I need to see the Changes History and in this cell I only see the changes in the formulas, not in the text. So I resorted to, in the next cell to copy and paste the clean text. In Google Sheets I created a button and assigned a script to it. As there are no buttons in AppSheet I wanted to do something similar, add a "Set Check to Yes" and when I activate it to copy the text in the A field to pasts in the B field.


And no matter how much I look around here or try myself, I can't do it. I also can't get AppSheet to find my Script in Google sheets. How should I approach this Action?
Thanks in advance...

Solved Solved
0 2 893
1 ACCEPTED SOLUTION

Sorry for my bad expression, I am not a native English speaker and help me with the translator.

 

Your advice has helped me a lot. I was looking for a Copy and Paste function and really the solution is where you say. This would be functional. The arrow indicates the text I want to copy from the field above, to the one below.

Right now I have some problem with the buttons but I think I can solve it.

Thanks a lot!

 

 

 

 

 

Screenshot - 2023-04-07T014135.838.png

 

View solution in original post

2 REPLIES 2

I don't understand your goal or your questions. Try providing a concrete example from your app that exemplifies what you're attempting to accomplish. Meanwhile, the following may be relevant.


@Marototuit wrote:
=B2&" "&C2&" "&D2&" "&TO_TEXT(E2)

It's definitely possible to do the equivalent in AppSheet. For example, in a column's App formula you can use analogous syntax (or the CONCATENATE function) in an expression like:

[ColumnB]&" "&[ColumnC]&" "&[ColumnD]&" "&[ColumnE]

 


@Marototuit wrote:

buttons in AppSheet


Create an action. It sounds like you might need the "Data: set the value of some columns in this row" action type.


@Marototuit wrote:

get AppSheet to find my Script in Google sheets


You would need to use a standalone Apps Script project and Call Apps Script from an automation - AppSheet Help.

Sorry for my bad expression, I am not a native English speaker and help me with the translator.

 

Your advice has helped me a lot. I was looking for a Copy and Paste function and really the solution is where you say. This would be functional. The arrow indicates the text I want to copy from the field above, to the one below.

Right now I have some problem with the buttons but I think I can solve it.

Thanks a lot!

 

 

 

 

 

Screenshot - 2023-04-07T014135.838.png

 
Top Labels in this Space