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?!?