I am working on a payment app that helps billers manage their owed payments and am trying to come up with the right design. I currently allow Billers to populate sheet 1 with a description of the bill via a Form (eg. Title, dates payments start, payment type, etc.). On sheet 2 I have information about the Payers associated with each bill (name, email, the amount owed). However, I am having trouble making this work because the process of registering a new bill and adding new Payers don’t seem compatible. My specific problem is to come up with a design that allows for:
Billers to enter info that includes bill description and multiple Payer info in one setting. I am trying to avoid just having one long-form where all the info (including all Payers) is entered on one form. Instead , I have a design where - once the description of the bill is entered there will be an “Add Payers” button that appears which billers can use multiple times to add multiple Payers.
I would like Billers to be able to easily add new Payers at a later point in time and for this to be automatically attached to the right bill. I am figuring I need a new sheet that accepts this info but I need this to be compatible with the info related to the original registering of the bill and the original Payers that were registered.
I would really appreciate anybody’s thoughts on this.