Is there a way to append table2 to table3 (table2 and table3 have the same structure) when adding a row to table1? Additionally, copy the key of table1 in all rows of table2 before appending it to table3.
Example: when adding a customer to table1, also add a list of questions for the new customer with the key of the new customer to a separate table (table3). Table 2 is a template listing all the questions associated to a new customer.
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…
Is Table 2 just a Single Row of questions?
No it has about 20 rows. Each row is a question.
OK here is what you can do.
I just got this working on my app
Step 1
Step 2
Step 3
There is probably a way to get the New UserID into Table2 first in bulk but hat is beyond what I did in my app
Anyway hope that helps!
Clean, simple and it works! Thank you very much!
No problem Happy to help. I just started myself and this community has been vital for me getting my own stuff working.