In my app I have a “type” table (cash, paypal, zelle, wire transfer, check, and so on).
I also have a “payment method” table. Each payment method is related to a type:
John’s paypal - Paypal
Cash in USD - Cash
Cash in CAD - Cash
(basically a 1 → n relation, each type can have multiple payment methods)
all of these payment methods are linked to an user:
By example:
John:
Now, what I want is a data grid in which each column name is the payment methods that the user that is currently seeing the page accepts. Meaning, the names and amount of columns won’t be the same for two users:
Hi,
you can obtain something similar, for example.
The main drawback with this representation is that the number of columns is static. So it has to be sized correctly, and it’s impossible to hide empty columns.
I will have multiple rows, one for each month of the year.
Below the payment methods, will have a rollup for how much money entered in each month to that payment method