Sunnyvale Moose 2049

Help
DEVELOPMENT

Production Site ]


Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles

Array
(
    [Action] => View
    [help_id] => 421
)

View: SELECT h.*, p.full_name FROM help h, people p WHERE 1 = 1 AND h.contact_id = p.people_id AND h.help_id = '421'

get_field_labels:Table: help, Cullme: help

Language: US_English

get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'help' AND message_type = 'Field Label' AND language = 'US_English'

Row Count: 19

From get_fields_label Output from Message

Array
(
    [help_id] => Help Id
    [meta_id] => Meta Id
    [contact_id] => Contact Id
    [language] => Language
    [topic] => Topic
    [subtopic] => Subtopic
    [application] => Application
    [context] => Context
    [summary] => Summary
    [help_type] => Help Type
    [sequence] => Sequence
    [level] => Level
    [module] => Module
    [table_name] => Table Name
    [field_name] => Field Name
    [keywords] => Keywords
    [short_help] => Short Help
    [long_help] => Long Help
    [last_modified] => Last Modified
)
Help Id 421
Meta Id 111
Contact Id Now Vacant
Language US_English
Topic Mail Labels
Subtopic User Forms
Application Mail Labels
Context OverView
Summary Mailing Labels Overview
Help Type Explanation
Sequence 0
Level 0
Module
Table Name maillabel
Field Name OverView
Keywords mail labels mailing
Short Help Mailing Labels Overview
Long Help The mailing label system provides the ability to create a printable page that will fit the Avery 5160 mailing label sheet of labels. The initial page provides two selection options:
  • Scope: Filter selection of which people to include
    • Entire Roster: Used as a check to proof the list, mainly for cleanup.
    • Newsletter Subscribers: Each person record has an attribute of Newsletter which can either be Y or N. This option collects those who are opted in where this value is Y.
    • Member Subscribers: Same as above, and they are in the member table.
    • Opted Out Members: Same as above, but their Newsletter is N.
    • All Prospects: Anyone in the people table whose Membership Progress is not Member.
    • Opted In Prospects: As above but the newsletter attribute is set to N.
    • Opted Out Prospects: As above but the newsletter attribute is set to N.
    • All Members: All members.
    • Opted In Members: Members whose newsletter attribute is set to Y.
    • Paid Members: Members whose current dues status is Paid Member.
    • Recent Attendees: Anyone attending the last 2 socials.
    • Past Attendees: Anyone attending a social since the system went online in July 2025.
    • Last Event Attendees: Anyone attending the last social.
  • Delivery: Whether the output goes to:
    • See To Print: You see a printable sheet as it will appear and print it to your printer.
    • Save To Website: Save the output to the website, archiving it to https://matesanddates.org/maillists where anyone can retrieve it.
    • Download PDF: Directly downloads it without inspecting it.
You make the two selections and click on the button labeled Print and the database selects the set of people/couples to mail to and provides the list in the delivery format you choose. The key filters work on the Newsletter attribute of the person record (via the Who utility) and the relationships from the Members utility.
Last Modified 2025-12-18 20:43:43

Entering spew_footer


Event Calendar  |  Facebook  |  Feedback  |  Home  |  Login  |  Newsletters  |  Roles
Questions, feedback, or website issues; please let us know by filling out the feedback form or emailing Webmaster.
Last Modified: December 29 2025 @ 14:52 PST
Stats