I can’t seem to find the answer for this although I’m sure it’s simple (though not for me apparently). I want to use multiple rows from one table to populate multiple rows in a 2nd table. The goal is to use a master list to select and build a customized list and populate the 2nd table with the customized list. Sounds simple but when I use the action “add a new row to another table using values from this row”, it only works if I select one row. If I select two or more I get an error indicating the key already exist in that row. It looks like it’s trying to put the info from all selected rows from the master list into a single row in the customized list. Do I have to somehow use a loop for this or am I going about this the wrong way? Any help is appreciated.
Add any number of rows from any row within a table Tips & Tricks ?
Definitely a frequently-asked question: how do I add some number of rows to a table automatically? It’s possible, but it’s not easy. This article details an approach that can be accomplished entirely within AppSheet (no API use), within the app itself (no workflow use), and accommodates an arbitrary number of rows (no built-in count maximum). While I’ve tried to make the guide accessible for less-experienced app creators, make no mistake: this is an advanced technique. I hope you find this us…
Thank you sir. Digging in!
1 Like