Hi folks
I have source data in two tables / tabs within a Google Sheet document, and Iโm trying to use AppSheet to help combine these similar-but-slightly-different data sets into a single consistently-structured data set. The idea is that I surface the data in AppSheet, then use the โData: add a new row to another table using values from this rowโ Action to selectively import specific rows into the target table. I have defined a specific โCopy Recordโ Action for each data source (screen snips to follow in subsequent posts):
Iโve assigned the action to the UX, but for any of the columns itโs copying based on existing data, itโs selecting values from all the rows and dumping them into the single new row (screen-shots to follow).
Iโve already checked the data types between the source and target tables are aligned. I also tried encapsulating the data being transferred in withing the TEXT() function, also without success.
Do I need to define a filter under Action > Behaviour? (Itโs currently blankโฆ)
I canโt help but think Iโm stuck on a โtrap for new playersโ and that Iโve missed something simpleโฆ can anyone help me understand what am I doing wrong?!?
Thanks!
Solved! Go to Solution.
An expression of the form, table-name[column-name]
(e.g., Form Responses[Child's Gender]
) produces a list consisting of all values from the column named in the table named. It appears you instead want the column value for only the current row. For that, just omit the table name (e.g., [Child's Gender]
instead of Form Responses[Child's Gender]
).
I also suspect you donโt need the TEXT() function where it appears in your screenshots. It may actually cause problems later unless youโre using it for its particular behavior.
Screen snip of Action #1:
Screen snip of Action #2:
Data from one of the source tables:
This is clearly showing two quite discrete records, before the Copy action.
Data from the target table:
Running the Copy action for each of the source rows has created two distinct records (unique keys) containing the same concatenated source data.
An expression of the form, table-name[column-name]
(e.g., Form Responses[Child's Gender]
) produces a list consisting of all values from the column named in the table named. It appears you instead want the column value for only the current row. For that, just omit the table name (e.g., [Child's Gender]
instead of Form Responses[Child's Gender]
).
I also suspect you donโt need the TEXT() function where it appears in your screenshots. It may actually cause problems later unless youโre using it for its particular behavior.
Hi Steve
Thanks for the tip; indeed a โtrap for new playersโ as I suspected! Curse my trying to be too specific.
Your suggested fix has worked, as demonstrated below:
Thanks again!
hi,
i think i have similar problem here.,
i have two table.,
I want to select some row from the first table and copy it into the second table.,
but., do i need to make a button to run the action?
or can i run the action automatically?
because i just try to add new data in first table then nothing happen in the second table.,
You may do it either way. To do it automatically, youโll need to attach the copy action to something initiated by the user (e.g., saving a form, pressing a button, or choosing an action to apply to the selection), or use a workflow.
hello,
Great info
If i have a inventory database that have to be updated regularly, how can i make a list with the new elements, i need this info because in the same aplication i have another table (table B) with the same inventory data but it have photos and some other info, the first table (table A) have 80 columns and 43000 rows, the second table must have the same 43000 rows after the update (table B), but just have 40 columns (just 10 fields from this table are the same of table A including the unique id field) .
Regards
Please start a new topic for help with this.
User | Count |
---|---|
44 | |
34 | |
24 | |
23 | |
15 |