I have a billing app designed to enable Billers to send bills to Payers. Each Biller has multiple bill titles with each bill title having its own Payers. A Payer can be listed on more than one bill.
I would like to enable Billers to add (or remove) Payers to any Bill using the Choice component. As part of this functionality, I would like Billers to have the option of adding a brand new Payer OR a Payer from another bill title.
What is the best way to design in such a way that when a Biller wants to add a Payer to a Bill, that:
- I automatically not include a Payer among the choices if he/she is already on the bill they are being added to?
- I allow Billers to select Payers from any other bill title OR select a brand new Payer?
I would welcome any input or guidance both in the google sheet design and glide data design. Thank for any help on this.