In this guide, you’ll find an overview of all available superlinks.
Superlinks are tags that automatically fill in data in contracts, emails, documents, and more.
They allow you to personalize documents and emails based on the member, staff member, or other data.
| Superlink | Explanation |
| [GREETING] | Greeting + First name (e.g., “Good morning Tom”) |
| [MEMBERID] | Member Number |
| [MEMBERFIRSTNAME] | Member First Name |
| [MEMBERNAME] | Member Name |
| [MEMBERADDRESS] | Member Address |
| [MEMBERZIP] | Member Postal Code |
| [MEMBERCOUNTRY] | Member Country |
| [MEMBERCITY] | Member City |
| [MEMBERBIRTHDATE] | Member Date of Birth |
| [MEMBEREMAIL] | Member Email |
| [MEMBERMOBILE] | Member Mobile Number |
| [MEMBERTELEPHONE] | Member Phone Number |
| [MEMBERSUB] | Member Subscription (description) |
| [MEMBERSUBTYPE] | Member Subscription Type (subscription/card/cost) |
| [MEMBERSUBTOTAL] | Sum of Pro Rata + First Month + Options |
| [MEMBERSUBVALIDSTART] | Subscription Start Date |
| [MEMBERINFO1] … [MEMBERINFO20] | Info fields from customer profile 1–20 (e.g., DB User, DB Password, etc.) |
| [F_SQL1] … [F_SQL20] | Function SQL – for custom work |
| [SP_SQL1] | Executes procedure when sending this link; OUT parameter is displayed as text |
| [MEMBERAGE] | Member Age |
| [MEMBERGENDER] | Member Gender |
| [MEMBERNOTE] | Notes field in member profile |
| [MEMBERVAT] | Member VAT Number |
| [MEMBERCOMPANY] | Member Company Name |
| [MEMBERACCOUNT] | Member Bank Account Number (IBAN) |
| [MEMBERMANDATEID] | Member Mandate |
| [MEMBERBANK] | Member BIC Code |
| [MEMBERSINCE] | Member Since |
| [MEMBERLASTVISIT] | Last Visit |
| [MEMBERVISITS] | Total Visits |
| [MEMBERPOINTS] | Member Points |
| [MEMBERCREDIT] | Outstanding Credit |
| [MEMBERSUBVALIDUNTIL] | Subscription End Date |
| [MEMBERVISITSLEFT] | Remaining Visits on Visit Card |
| [MEMBERSUBAMOUNT] | Total Subscription Amount |
| [MEMBERSUBPAYWAY] | Subscription Payment Method |
| [MEMBERSUBREMAINDER] | Outstanding Balance |
| [MEMBERALLREMAINDER] | Total of All Outstanding Balances |
| [MEMBERSUBCONTRACTMONTHS] | Number of Months Subscription is Valid |
| [MEMBERALLSUBAMOUNT] | ???? (unclear) |
| [MEMBERALLSUBPAID] | Sum of All Subscriptions Paid |
| [MEMBERNATIONALID] | National ID Number |
| [MEMBERSTATUS] | Subscription Status (Valid days – End date – Outstanding Balance) |
| [MEMBERLASTSUB] | Last Purchased Subscription |
| [MEMBERLASTSUBVALIDUNTIL] | End Date of Last Subscription |
| [MEMBERLASTVISITSLEFT] | Remaining Visits of Last Subscription |
| [MEMBERLASTSUBAMOUNT] | Last Subscription Amount |
| [MEMBERLASTSUBPRORATAAMOUNT] | Pro Rata of Last Subscription |
| [MEMBERLASTSUBREMAINDER] | Balance of Last Subscription |
| [MEMBERLASTVALIDSTART] | Valid Start Date of Last Subscription |
| [MEMBERLASTSUBPAYWAY] | Payment Method of Last Subscription |
| [MEMBERLASTSUBOPTIONAMOUNT] | Options Total in Last Subscription |
| [DATENOW] | Today’s Date |
| [MEMBERABSENCECOUNT] | Number of Absences (penalty system) |
| [CONFIRMRESERVATION_XXXX] | Confirmation link for 1 reservation (XXXX = reservation ID) |
| [MEMBERQRCODE] | Sends standard QR code (email only) |
| [MEMBERCOST1AMOUNT] | Amount of Cost 1 |
| [MEMBERCOST1REMAINDER] | Balance of Cost 1 |
| [MEMBERNEWPASSWORD] | Generates and shows a new password |
| [MEMBERIMAGE64]/[MEMBERIMAGE96]/[MEMBERIMAGE128] | Customer profile picture (Word docs only) |
| [MEMBERSUBTOTALAMOUNT] | SubscriptionAmount + ProRataAmount + OptionsAmount – ActionDiscount |
| [MEMBERSUBTOTALWITHCOSTSAMOUNT] | [MEMBERSUBTOTALAMOUNT] + cost1 + cost2 + cost3 |
| [MEMBERSUBNOTE] | Memo of selected subscription |
| [MEMBERSUBSTARTDATE] | Start date of selected subscription |
| [MEMBERSUBOPTIONS] | Description of subscription options (comma-separated if multiple) |
| [MEMBERSUBOPTIONSAMOUNT] | Total amount of selected options |
| [EMPLOYEENAME] | Staff Name |
| [EMPLOYEEFIRSTNAME] | Staff First Name |
| [WEBAUTOLOGONURL] | URL to log in directly online and show homepage |
| [WEBSHOPOPENURL] | URL to log in directly online and show outstanding subscriptions |
| [WEBSHOPURL] | URL to log in directly online and show webshop |
| [E-INVOICEURL] | URL to log in directly online and show invoices |
| [EMAILBEACON] | Inserts a beacon in HTML email to track when it is read |
| [RESERVATIONSURL] | URL to log in directly online and show current reservations (customer only) |
| [COMMUNITYURL] | URL to log in directly online and show community (customer or staff) |
| [MEMBERTESTSURL] | URL to log in directly online and show fitness tests (customer only) |
| [INVITEURL] | URL for customer to (re)set password |
| [UNSUBSCRIBEURL] | URL to unsubscribe from newsletter (customer email prefilled) |
| [CONFIRMEMAILADDRESSURL] | URL to verify this email address |
| [CLUBNAME] | Club Name |
| [CLUBCOMPANYNAME] | Club Company Name |
| [CLUBADDRESS] | Club Address |
| [CLUBZIP] | Club Postal Code |
| [CLUBCITY] | Club City |
| [CLUBVAT] | Club VAT Number |
| [CLUBBANKACCOUNTNUMBER] | Club IBAN Number |
| [CLUBPHONENUMBER] | Club Phone Number |
| [CLUBEMAIL] | Club Email |
| [CLUBCOLOR] | Theme Color (#ABCDEF) – without brackets |
| [CLUBLOGOURL] | Club Logo |
| [CLUBBASEURL] | Base URL of MyClubPlanner (e.g., https://demo.clubplanner.be) |
| [CLUBWEBSITE] | Club Website URL |
| [CLUBFACEBOOK] | Club Facebook |
| [CLUBINSTAGRAM] | Club Instagram |
| [CLUBLOGO64]/[CLUBLOGO96]/[CLUBLOGO128] | Club Logo (Word docs only) |
| [CLUBCREDITORID] | Club Creditor ID |
| [CLUBTERMSANDCONDITIONS] | URL for Terms & Conditions |
| [CLUBPRIVACYPOLICY] | URL for Privacy Policy |
| [ACTIVITY] | Activity Description |
| [ACTIVITYDAY]/[ACTIVITYDATE] | Activity Date |
| [ACTIVITYTIME]/[ACTIVITYSTART] | Activity Start Time |
| [ACTIVITYEND] | Activity End Time |
| [ACTIVITYMEMO] | Activity Memo |
| [LOCATION] | Location |
| [POPUPQUESTION] | Optional popup question |
| [POPUPANSWER]/[POPUPVALUE] | Question and answer from optional popup during booking |
| [BOOKINGSTATUS] | Booking status (e.g., which subscription or price was used) |
| [ONLINEPURCHASEDESCRIPTION] | Online Purchase Description |
| [ONLINEPURCHASEAMOUNT] | Online Purchase Amount |
| [ONLINEORDERNBR] | Online Order Number |
| [ONLINEORDERMEMO] | Online Order Memo |
| [ONLINEPURCHASEOPTIONS] | Online Purchase Options |
| [ONLINEPURCHASEARTICLES] | Online Purchase Articles |
| [BOOKINGWIZARDCALENDAR] | Booking Wizard Calendar |
| [BOOKINGWIZARDCLUB] | Booking Wizard Club |
| [ONLINERESERVATIONNBR] | Online Reservation Number |
| [COUPONKEY] | Coupon Key |
| [COUPONID] | Coupon ID |
| [COUPONAMOUNT] | Coupon Amount |
| [COUPONVALID] | Coupon Validity |
| [SALEFIRSTNAME] | Lead First Name |
| [SALENAME] | Lead Name |
| [SALESEX] | Lead Gender |
| [SALEID] | Lead ID |
| [SALEADDRESS] | Lead Address |
| [SALEZIP] | Lead Postal Code |
| [SALECITY] | Lead City |
| [SALEBIRTHDATE] | Lead Date of Birth |
| [SALETELEPHONE] | Lead Telephone |
| [SALEEMAIL] | Lead Email |
| [SALEMOBILE] | Lead Mobile |
| [SALENOTE] | Lead Notes |
| [SALECREATEDON] | Lead Creation Date |
| [ACTIVITYDAY] | Activity Date (only in planning step) |
| [ACTIVITYTIME] | Activity Time (only in planning step) |
| [CONTRACT_SIGN_URL] | Link to contract signing page (requires a selected subscription) |
| [SUBSCRIPTIONSTOP] | Name of stopped subscription by customer |
| [SUBSCRIPTIONSTOPDATE] | End date of stopped subscription by customer |
| [MEMBERSTOPSUBSCRIPTIONSURL] | URL to log in as customer and stop auto-renewing subscription |