Hello,
I will explain what I am trying to do and can someone give me some feedback on how to best accomplish the end results.
I am trying to have all my Users able to log in, click on the drop-down option and choose which location they are at, which will update in the database and then I can have a chart displaying the current information selected.
This is the current options have have saved in the database:
Current drop down options connected to database:
This is the chart I would like to display the current information selected from the drop down options:
Do you want them to be able to add this every day and that it logs a long list of every day status for the users or just their current status?
If you want them to log every day I would setup a new collection called usersLog and insert fields userId and statusId and DayStored.
userId will take the user.id from the wix-users currentUser object which you can find lots of info about in the API.
statusId will be the _id field of your status collection you have created and the DayStored will be the todays date.
Does it make any sense to you?
Questions:
Why do you have two columns with same status data inside?
Why do you have 6 dropdowns if they should select one status?
Do you want them to be able to add this every day and that it logs a long list of every day status for the users or just their current status?
I would like if they can choose from the 10 options below, then their input can be displayed on a chart with their names and current status:
Why do you have two columns with same status data inside?
I created a column for each of the User that would need to update their status.
Why do you have 6 dropdowns if they should select one status?
There are actually 12 drop downs, due to the need for have 12 users submit their status.
Ok. Create one dropdown for all users as long as the contents of the dropdown is the same for all users. I can make this for you if you want next week.
