davesudweeks wrote:The Speaker History has to be exported to allow me to populate the last date an individual spoke.
Where do you 'keep' the speak hstory that you export?
davesudweeks wrote:The Speaker History has to be exported to allow me to populate the last date an individual spoke.
About exporting and manipulating on other programs:davesudweeks wrote: The Speaker History has to be exported to allow me to populate the last date an individual spoke. I use formulas to copy the previous data to the new fields when I update it (about monthly). By the way, our youth are amazed that the Bishopric can remember the last time they spoke... we just keep the "how" our little secret.
ggllbb wrote:Where do you 'keep' the speak hstory that you export?
daryl1 wrote: There is no work around and no option under the custom reports format section to draw mailing addresses street 1 or street 2 from the data base. Also there is no option for this under the abbreviated directory customize section. Currently the only way to see the mailing address is to look at the membership record in MLS or to print out the mailing labels.
daryl1 wrote:Can we add this to the Clerk Wiki? :rolleyes:
daryl1 wrote:Currently the only way to see the mailing address is to look at the membership record in MLS or to print out the mailing labels.
I agree that these fields should be selectable through custom reports. It does seem like it would be an easy addition, and very helpful.daryl1 wrote:Many members in the unit have a physical residential address along with a mailing address. This would bless the leaders to be able to create a custom report by adding mailing address street 1, and street 2 to the custom report format and or under the abbreviated directory customize section.
The programmers did put a check box for residential street 2 address under the abbreviated directory customize section but forgot the mailing address fields.
aebrown wrote:You say the only current option is to "look at the membership record in MLS" (obviously impractical) or "to print out the mailing labels" (no flexibility in formatting). But have you tried the other option I mentioned in my previous reply to you? That way you can have an electronic version of the mailing addresses and merge or do whatever else you want with the mailing addresses. Since you didn't mention that option, I can't tell if you've tried that.
I made a suggestion, and he didn't respond to it. It was a simple followup to see if he understood and if that would be helpful. Yes, the only data with that mechanism is the data that the labels contain, but I don't see how you can be certain that is in no way helpful.RossEvans wrote:I still don't understand how this would satisfy daryl1's needs. He is not seeking just to reformat the mailing address data, but to add it to a directory report. The directory typically contains other information, such as household members and phone number, that is not in the mailing labels. IIRC, the only time I ever tried exporting the mailing labels to a CSV file, the only data I got there was what the labels themselves contained.
aebrown wrote:I made a suggestion, and he didn't respond to it. It was a simple followup to see if he understood and if that would be helpful. Yes, the only data with that mechanism is the data that the labels contain, but I don't see how you can be certain that is in no way helpful.