Proposed Universal Substitution System
From Convention Master Documentation
| Substitution | Description | Source | Tag Replacement | badgecode | Notes |
| uid | outputs the registrant uid. | Tag Replacements | reg_uid | $uid | |
| legal_first | outputs registrant first name. | Tag Replacements | reg_rl_first | $registrant_rl_first | |
| legal_last | outputs registrant last name. | Tag Replacements | reg_rl_last | $registrant_rl_last | |
| legal_name | outputs registrant "first" + "last" name. | Tag Replacements | reg_full_name | ||
| common_name | outputs registrant badge name if not empty - otherwise thier "first" + "last" name. | Tag Replacements | reg_badge_name | $registrant_fan_name | |
| badge_name | outputs registrant badge name. | Tag Replacements | reg_birthday | $registrant_birthday | |
| birthday | outputs registrant birthdate. | Tag Replacements | reg_first_created | ||
| first_created | outputs registrant account creation date from database. | Tag Replacements | reg_common_name | $registrant_common_name | |
| address_ship_to_name | outputs registrant ship to name. | Tag Replacements | reg_address_ship_to_name | ||
| address_line_1 | outputs registrant address line 1. | Tag Replacements | reg_address_line_1 | ||
| address_line_2 | outputs registrant address line 2. | Tag Replacements | reg_address_line_2 | ||
| address_city | outputs registrant address city. | Tag Replacements | reg_address_city | ||
| address_state | outputs registrant address state. | Tag Replacements | reg_address_state | ||
| address_country | outputs registrant address country. | Tag Replacements | reg_address_country | ||
| address_zip | outputs registrant address zip. | Tag Replacements | reg_address_zip | ||
| address_full | outputs registrant address with all fields combined. | Tag Replacements | reg_address_full | ||
| phone_type | outputs registrant phone type. | Tag Replacements | reg_phone_type | ||
| phone_number | outputs registrant phone number. | Tag Replacements | reg_phone_number | ||
| outputs registrant email. | Tag Replacements | reg_email | |||
| payment_hold_created | outputs date payment hold was created for current registrant and event. | Tag Replacements | reg_payment_hold_created | ||
| payment_hold_expiry | outputs date payment hold will expire for current registrant and event. ex: 2020-01-22 18:30:15 | Tag Replacements | reg_payment_hold_expiry | ||
| payment_hold_extendable_to | outputs latest date payment hold can be extended up to for current registrant and event. | Tag Replacements | reg_payment_hold_extendable_to | ||
| payment_hold_payment_type | outputs most recent payment type selected for current registrant and event | Tag Replacements | reg_payment_hold_payment_type | ||
| payment_hold_expiry_long | outputs long date payment hold will expire for current registrant and event. ex: Wednesday, January 22, 2020, @ 6:30 PM | Tag Replacements | reg_payment_hold_expiry_long | ||
| bool_marked_deceased | Returns True if the user is marked deceased | new | |||
| bool_ConsoleUser | Returns True if the user has an active console login | new | |||
| consoleUserExpiryDate | Displays expiration date for console login | new | |||
| CompMoneyRemaining | Displays the remaining comp money | new |
| Substitution | Description | Source | Tag Replacement | badgecode | Notes |
| event_id | outputs the Event Id. Example: "DEMO_1" | Tag Replacements | event_id | $event_id | |
| event_title | outputs the Event Title. Example: "Demo Event" | Tag Replacements | event_title | $events_event_title | |
| event_start_date | outputs event start date from event settings. | Tag Replacements | event_start_date | ||
| event_end_date | outputs event end date from event settings. | Tag Replacements | event_end_date | ||
| event_age_of_maturity | outputs event age of maturity from event settings. | Tag Replacements | event_age_of_maturity | ||
| event_pre_reg_end_date | outputs event pre-reg end date from event settings. | Tag Replacements | event_pre_reg_end_date | ||
| event_address_1 | outputs address line 1 from event settings. | Tag Replacements | event_address_1 | ||
| event_address_2 | outputs address line 2 from event settings. | Tag Replacements | event_address_2 | ||
| event_address_3 | outputs address line 3 from event settings. | Tag Replacements | event_address_3 | ||
| event_address_4 | outputs address line 4 from event settings. | Tag Replacements | event_address_4 | ||
| event_address_full | outputs event address with all fields combined. | new | |||
| event_defaultFromEmail | outputs default from email address in event settings. | Tag Replacements | event_defaultFromEmail | ||
| event_defaultReplyTo | outputs default reply to: in event settings. | Tag Replacements | event_defaultReplyTo | ||
| event_chequeToName | outputs cheque to name in event settings. | Tag Replacements | event_chequeToName |
| Substitution | Description | Source | Tag Replacement | badgecode | Notes |
| bool_underage | true if below age of maturity set for event from birthdate and stored event age of maturity | badgecode | $underage | ||
| num | registration sequence number for that particular event | Tag Replacements | reg_reg_num | $events_attended_reg_num | |
| badge_display_code | outputs registrant badge layout code. Example: FNOT | Tag Replacements | reg_badge_display_code | ||
| membership_name | outputs membership name. (setting: Group Name) | Tag Replacements | reg_membership_name | $event_membership_types_name | |
| membership_long_name | outputs membership long name. (setting: Membership Type as printed on badge) | Tag Replacements | reg_membership_long_name | $event_membership_types_long_name | |
| membership_full_desc | outputs membership description. (setting: Sales pitch description:) | Tag Replacements | reg_membership_full_desc | ||
| membership_rules | outputs membership rules. (setting: Rules For this membership) | Tag Replacements | reg_membership_rules | ||
| membership_type | outputs registrant membership code for current event. Example SPON_0 | Tag Replacements | reg_membership_type | ||
| membership_last_updated | outputs membership last modified date for current event. | Tag Replacements | reg_membership_last_updated | ||
| membership_price | outputs membership price. | Tag Replacements | reg_membership_price | ||
| membership_avail_from | outputs membership available from date. | Tag Replacements | reg_membership_avail_from | ||
| membership_avail_to | outputs membership available to date. | Tag Replacements | reg_membership_avail_to | ||
| staff | if attendee_membership_name contains the word 'staff' this will equal true, this is not case sensitive. | badgecode | $staff | if retained, maybe this should also check membership_long_name |
| Substitution | Description | Source | Tag Replacement | badgecode | Notes |
| bool_has_confirmed_activity | useful for a true false for flagging panelist badges. | new | This is highly speculative, however I'm presuming this would work something like AS/DD in that the application would be tied to the UID of the person who applied, so we could pick it up that way, it could go into the attendee group | ||
| bool_activity_host | useful for a true false for flagging panelist badges. | new | |||
| bool_activity_assistant | useful for a true false for flagging panelist badges. | new | |||
| bool_is_true if uid matches to either activity host or assistant - useful for a true false for flagging panelist badges. | new | ||||
| activity_schedule | displays a formatted list of activities a panelist is assigned/confirmed to | new |
| Substitution | Description | Source | Tag Replacement | badgecode | Notes |
| <num>_application_state | useful for doing a strcmp in badgecode to automatically tag dealers on approved dealers/artists. | new | for correctness I want to call this group artshow, but these function will only really be used by dealers den | ||
| bool_<num>_confirmed | useful for a true false for flagging dealer badges. | new | these three are listed as options | ||
| bool_<num>_assistant | useful for a true false for flagging dealer assistant badges. | new | these three are listed as options |
| Substitution | Description | Source | Tag Replacement | badgecode | Notes |
| <num>_title | Will display the title of the user defined field. (If the customer has it applied to them) Ex: $UDF_12_title. | Badgecode | $udf_title | ||
| <num>_value | Will display the value of the user defined field. (If the customer has it applied to them) Ex: $UDF_12_value. | Badgecode | $udf_value | ||
| bool_<num> | Returns True is the UDF has been answered | new | |||
| <num>_type | returns the udf type | new | |||
| <num>_udf_response_list | Will display the UDF questions if relevent | new |
| Substitution | Description | Source | Tag Replacement | badgecode | Notes |
| bool_purchased_<num> | returns true if the customer has purchased the product | new | |||
| bool_incart_ | returns true if the customer has the product in their cart | new | |||
| <num>_info | displays product description | new | |||
| <num>_price | displays product price | new | |||
| <num>_items_sold | displays how many have been sold | new | |||
| <num>_items_remaining | displays how many are remaining (cart+purchased-inventory) | new |
| Substitution | Description | Source | Tag Replacement | badgecode | Notes |
| cm_version | displays CM version string | new | |||
| db_version | displays db db version int | new | |||
| license_expiration | displays license expiration date | new | |||
| license_valid_events | displays list of valid events | new | |||
| bool_dev_license | returns true if dev license | new |