Hopefully, someone can help me get to grips with this. I’m sure I’m doing something wrong, but I can’t figure out what.
I have manually created 3 users in the DB. I have created columns for address and a boolean for IsStaff. Each has an address and two of them are defined as staff (IsStaff = “yes”).
Now, I am logged in as the first user (IsStaff = “no”). I want to get a list of nearby users so according to the videos etc, I need “Do a search for”. So, I’ve created a text box and selected Do a search for and selected Users. I’m not putting any criteria on it at this point. I’m then selecting :count
To my mind, this should be a very simple count of the users table (i.e. 3). However, it only returns 1. If I change it to Search for Users:last item’s Address, I would expect (given that I’m not applying a sort order) record 3 (or possibly the last one entered if the Data tab is displaying in a different order). I don’t. I get the address of my current user. If I change it to Search for Users:first item’s Address I still get the address of the current user. If I change it to Current User then I get (as expected) the current user.
I’ve tried using a repeating group to display all the addresses but that doesn’t work either.
Clearly I have something wrong, but having been through the video and examples I still can’t work out what I’m missing.
Can anyone help me?