Having Multiple User Entries on a Dashboard?
Is there a way to have multiple user entries on a dashboard? Let's say I have 10 products and 2 customers. I want my customers to be able to input all the products they want on a dashboard. My desired outcome would look like this:
For Customer Joe
|Product||Unit Demand||Cost per Unit||Total Cost|
So in essence, how can the user enter multiple entries and have it visible like in the table above, from a dashboard in the new UX?
Here is the step by step approach:
1. Create the lists like this. Note: # Products by Customers is a numbered list.
2. Create a module like below:
3. Create an action to add to the numbered list. Use the "Create" action
4. You will have to give selective access at Customer level to individual users so that they see only the customers that they are supposed to see. In my list of customers, I have 2 customers.
5. Click on Customer 1, and then click the button "Add New Line". Then you can fill up the details as needed.1
There can be two ways to solve this:
You can have one module with customer and product dimension. Using selective access you can control, which products do they see on the dashboard.
The other way you can achieve this using a numbered list with Customer list as it's parent. This list will enable users to add new list items in the numbered list from the dashboard (using Add Action) and fill up details against it. It would look something like this:
#Numbered List Product Unit Demand Cost per Unit Total Cost #1 Product A 5 $3 $15 #2 Product B 10 $2 $20 #3 Product C 2 $5 $10 #4 Product D 1 $35 $35
Approach 1 may be preferred as it is simpler to design.0
Thanks for the response. but will approach one be better if I had more than 2 customers? I used 2 in my initial question for quick illustration. I actually have about 30 customers.0
Approach 1 will be better if there is not a sparsity issue. If only a part of product list is applicable to customer, then it may cause sparsity issue. With 30 customers, it should not be a concern though.
In the 2nd approach, I have suggested the addition of numbered list which will be added activity for users.
From a usability perspective, approach 1 will be better if it is not causing sparsity issue.0
@anikdas , so yeah, there is a lot of sparsity issue. Again for illustration purposes, I used a smaller number of products in my initial question. I actually have 150 products and 30 customers, and obviously no one customer orders all 150 products. So a whole lot of cells with 0 value for unit demand etc.
I'm curious as to how to approach the option 2 you suggested? as that might be the better option.0