I am struggling through this thought process and need some ideas. In my spreadsheet I am logging equipment run time. You start a log in the morning and stop it at the end of the day. Based on the equipment logs I want those"active" equipment names to pop up on my loadsheet form. I also want the “active” equipment to have a green dot next to their name so I know they have a log going like so:
What I am struggling with is that more than one user is going to be using this at the same time and I want each user to only see their equipment that they have active. Any thoughts or suggestions?
I should also mention that right now they have to “activate” their equipment based on customer and date through this form. But not sure if this route will allow multiple users to use it.
Presumably you have a “Log” table with columns like [equipment] and [user]. So then to get a list of all “active” equipment for today for the current user, you’d do something like this:
