Kindoo Access Control System

[kd7mha]

Google sheets and newer versions of excel support textjoin which can be simpler especially if you are combining more than 3 cells.

=textjoin(" ",1,A1:B1)

[ELHawkes]

I know you can look at a users log to see their activity, but it would be much more efficient to be able to generate a list of those who haven't opened a door in the past 6 months.

I enjoy a good challenge, so through it would be fun to give this one a try. I was able to get that list in just a couple minutes, but it's slightly kludgy .

• Export the list of users to a CSV
• Export the logs to a CSV based on the date range you care to view.
• Open them both up in a spreadsheet
• In the user list, concatenate the first and last names to create the full user name column, because that's how it's listed in the logs
• Use VLOOKUP or a similar spreadsheet function to tag users in the user list who are found in the logs. Those not found are your target group.

Like I said, it's a little kludgy (maybe a lot kludgy), but it gives you exactly what you are looking for.

Instead of Never issued a command for a title, maybe it could say "Never Opened a Door".

Keep in mind, Kindoo is not the Church's software and only for doors. It's a product used in many places with many functions, including opening gates, turning on lights, a pretty much anything else you can dream up using a remote relay.

Concatenation is easy and super useful Works in Excel and Google Sheets:
If cell A1 is first name and B1 is last name, just use a formula like this in C1 to get the full name:
=A1&" "&B1
The ampersand (&) is the secret sauce here!
I'll see if I can throw together a clean G Sheets example later to cover ELHawkes feature request. I think it could be useful.

Site Dashboard-Never issued a command (Opened a door) (in the past (X) months) Spreadsheet workaround

So after several hrs of watching videos and practicing, I was able to make swigginton suggestion work.
To merge two columns in G Sheets, I used this formula after watching this video. =ARRAYFORMULA(A1:A&" "&B1:B)
https://youtu.be/Tcvv-tmZEEA?si=mKeX24mmvzuI4Sl7

To Match (Vlookup) two ranges in G Sheets, which was the harder part to find the best video example and figure out, I used this video.
https://youtu.be/GZ1bEXjdhFU?si=xurEk-B7VwrJdYrT

[swigginton]

So after several hrs of watching videos and practicing, I was able to make swigginton suggestion work.

Excellent! Well done! Those new bits of knowledge may help you with future spreadsheet quests.