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! Go to 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!
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!
User | Count |
---|---|
17 | |
11 | |
7 | |
4 | |
3 |