Actions: Create N rows in another table

Hi, I am doing a small app to track micro loans. The idea is that when a new loan is created, it should populate the payment schedule.

The loan entity has a field called Number_Payments. If the user selects 6, I want to create an action that will create 6 rows in the payments entity, all of them with different dates (weekly payments, for instance)

How can I create an action that will read the Number_Payment field and create N number of rows. Any ideas?

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…

1 Like