Hello
I need some advice from more experienced fabrik users, here is what i am trying to achieve:
I have a list with customers info (like address phone, etc) and another list with its sales, so i need to input their monthly sales for each year, now i cant figure out how i can make the list with the sales so it shows each month and a filter for each year.
I mean, should i need to create a field for each month? (thinking on doing that) and another for each year? (maybe with a date type element i can make this work).
So the sales list should look just like an excel spreadsheet with the name of the customer and all the months to the right.
Any advice on how should i be doing this? Right now all i can think of is to create elements for each month and year, but maybe there is another way. Any advice is welcome.
Thanks.
I need some advice from more experienced fabrik users, here is what i am trying to achieve:
I have a list with customers info (like address phone, etc) and another list with its sales, so i need to input their monthly sales for each year, now i cant figure out how i can make the list with the sales so it shows each month and a filter for each year.
I mean, should i need to create a field for each month? (thinking on doing that) and another for each year? (maybe with a date type element i can make this work).
So the sales list should look just like an excel spreadsheet with the name of the customer and all the months to the right.
Any advice on how should i be doing this? Right now all i can think of is to create elements for each month and year, but maybe there is another way. Any advice is welcome.
Thanks.