I have an application where I ask to input number of payments (installments).
Then based on this number, create new records (payments) with the date in the future. With that information, i would track who is overdue to pay or how much incomme i may have in the future.
Ex.
Client decided to buy a produt and pay for it in 10 installments.
table: cliente order
columns : number installment , start day, total value
table: paymement
columns: payment number, due date, paid date, value
loop 10 times…
1 - today, date, value
2 - 30 later, date, value
3 - 60 days later, date, value
…
10 - 300 days later, date, value
Can someone share me light how loops to create future events could happen using knack, jquery, zapier or any type of automation.