How to create a payment payment projection in Zoho Creator?
Hey there! I'm new to Zoho Creator. I want to create an app that lets me register loans. That way, when I enter some information like the amount loaned, interest rate and time, it will create a table containing the amount to be paid by the user, for example every month.
For example:
Interest rate: 10%
Time: 12 months
Amount: $ 1200
Payment table:
1. Month 1: loan principal -> $ 100, Interest-> $ 10
2. Month 2: loan principal -> $ 100, Interest-> $ 10
3. Month 3: loan principal -> $ 100, Interest-> $ 10
And so on. How can I create this payment table? what tools are there available in Zoho Projects for that?