Kit Johnson

Let's say I have 10 customers each created using a 'customers' form. Each customer has their own monthly subscription rate, which is set in the same form. There is also a status: either 'current', for customers who are paying for their subscription, or 'dormant', for customers who have stopped paying. I would like to be able to generate an invoice at the end of the month for each of the 'current' customers. So far I have created a 'invoice' form, which is able to look up the subscription rate for an *individual* customer, however for all current customers (let's say there are 8 current ones) I need to individually create 8 entries, either from a repeating section or simply 8 separate entries. Obviously 8 is not too many, but if the business grows to a 100 active customers this would be a big waste of time. What I really would like is to be able to automatically generate the invoices based on the active customers in the customers form. It's important to separate the invoice form from the customer form because there is more data that needs to be stored for the invoices, which is specific to each month, and […]