Idea: enable smarter sorting by address in LDS tools and MLS so that is can sort by street name not just number.
Backstory:
As a YSA ward clerk we have been entering in addresses using both the street1 (house number) and street2 (street name) fields in MLS so that we can sort by street name and end up a fairly well organized list for assigning FHE groups, visiting routes, etc.
This could be implemented by having a separate field in the lds tools for house number, aprt, street name, box, like they do for some postal and account information.
Additionally this seems to cause some problems for our stake clerk when they print off lists as they usually only include street1 (so he has to enable street2 just for our ward) And it apparently doesn't adhere to postal guidelines.
I have been told this isn't really done much in family wards, But I would love to hear some opinions as our ward finds it a quite useful setup.
Sorting by address MLS and LDS tools
- david.fox2
- New Member
- Posts: 8
- Joined: Sat May 18, 2013 1:20 am
- Location: Alberta, Canada
-
- Community Administrator
- Posts: 34503
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
Re: Sorting by address MLS and LDS tools
Sounds like a job for Geo codes.david.fox2 wrote:As a YSA ward clerk we have been entering in addresses using both the street1 (house number) and street2 (street name) fields in MLS so that we can sort by street name and end up a fairly well organized list for assigning FHE groups, visiting routes, etc.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.
So we can better help you, please edit your Profile to include your general location.
So we can better help you, please edit your Profile to include your general location.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
Re: Sorting by address MLS and LDS tools
When I've done this, I've used a spreadsheet to do the sorting. That way I can leave the addresses properly formatted in MLS. I just export the address list from MLS (typically by doing a copy and paste from the MLS Abbreviated Directory report). Then I paste it into a spreadsheet and use the spreadsheet's functions to isolate the street name into a separate column, which I can easily sort on.
Once you've set up the spreadsheet, for future iterations you can just do a quick paste and sort in less than a minute when you want to update the list as people move in and out of the ward.
Once you've set up the spreadsheet, for future iterations you can just do a quick paste and sort in less than a minute when you want to update the list as people move in and out of the ward.
-
- Senior Member
- Posts: 1222
- Joined: Thu Dec 08, 2011 10:42 am
- Location: Emmett, Idaho
Re: Sorting by address MLS and LDS tools
I'm with russell Geo codes would work great for what your trying to do. depending on the area of the ward you could use the street names as the Geo Code.
-
- Community Administrator
- Posts: 34503
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
Re: Sorting by address MLS and LDS tools
I didn't think about it at the time, but one weakness of Geo Codes may be in the reporting. I know it's the bane of custom fields.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.
So we can better help you, please edit your Profile to include your general location.
So we can better help you, please edit your Profile to include your general location.
- showseason
- Member
- Posts: 150
- Joined: Sat Feb 26, 2011 9:56 pm
- Location: Oregon
Re: Sorting by address MLS and LDS tools
I'm with aebrown on this. It's a pain to set up but once it is it is easily maintained. We also have added a column for comments and have some info on most families in the ward. The Bishop loves it.aebrown wrote:Once you've set up the spreadsheet, for future iterations you can just do a quick paste and sort in less than a minute when you want to update the list as people move in and out of the ward.