Merging Smartsheets in Appsheet

[Elevate_Church]

I’m trying to put two smartsheets into one app I would like to merge the information from the two sheets so that it will be contained in one tab on the AppSheet. I know how to add two different sheets to the same appsheet where the information is separated on two different tabs on the bottom of the app sheet. But what I want to do is take two different Smartsheets and merge that information so it shows it together. I have information that is listed In two different smartsheets. Because SmartsheetS only allows 5000 rows so I have archive some of the information onto a different sheet I want to be able to take the information from the archive sheet and the other sheet which are both in the same format with the same columns. is that possible to do?

[Koichi_Tsuji]

My previous post may help.

Dynamic table connections Questions

As Steve highlighted, all the data table need to be connected to app through the appsheet editor. Unless the connection to the target data table is established, Apppsheet won’t have direct access to do any operation in terms of CRUD. But now I understood your data source is Smartsheet and need to store the data to much of sheet in Smartsheet through Appsheet. Again to achieve that, in general and per Appsheet standard procedure, we need to add every single Smartsheet sheet to Appsheet and proba…