Is there a way to copy rows WITH Row ID's from an existing Appsheet Database to another existing

[Luc87]

I've transferred databases from Excel to Google sheets to now Appsheet Database. But, as I didn't check some of its limits in terms of columns per database, tables per database, and # databases, I need to consolidate some of them. As I painstakingly switched all the references to Row ID's rather than my previous keys, I do not want to lose existing Row IDs. I'd be more tedious to transfer again.

With google and Excel, you can copy and paste rows etc easily and not lose existing keys. Is there a way to do so with AppSheet databases? If there isn't currently, there needs to be.

[dbaum]

Use an app action or the AppSheet API to replicate rows from one data source to another.

[Luc87]

👍I did do that to change keys to Row ID's originally. But, was hoping for something simpler to do so now. But, there may not be.

[dbaum]

In case it's helpful: For one-off data manipulation needs, I sometimes create an disabled automation that comprises the pertinent data change actions and then utilize the AppSheet editor's function to test the automation, which in effect runs it once, which is all I need. As compared to using a directly invoked app action, it can be far more efficient since it runs on the server rather than a local device. As compared to the API, it can be easier to set up.