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 (€). Works in Word documents only; in an e-mail or a contract, use [MEMBERSUBTOTALAMOUNT] |
| [MEMBERSUBVALIDSTART] | Subscription Start Date |
| [MEMBERINFO1] … [MEMBERINFO30] | Info fields from customer profile 1–30 (e.g., DB User, DB Password, etc.) |
| [F_SQL1] … [F_SQL30] | 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] | Price of the selected subscription on the payment line (€), without the options and without pro rata |
| [MEMBERSUBPAYWAY] | Subscription Payment Method |
| [MEMBERSUBREMAINDER] | Outstanding Balance |
| [MEMBERALLREMAINDER] | Total of All Outstanding Balances |
| [MEMBERSUBCONTRACTMONTHS] | Minimum contract duration of the current subscription, in months. Prefer [MEMBERSUBCONTRACTDURATION], which also handles weeks, days and years |
| [MEMBERSUBCONTRACTDURATION] | Contract duration of the selected subscription, including the unit, for example 6 months |
| [MEMBERSUBCONTRACTQUANTITY] | Number of periods the subscription runs, without the unit, for example 6 |
| [MEMBERSUBCONTRACTUNIT] | Unit of the period (days, weeks, months or years), in the language of the member |
| [MEMBERALLSUBAMOUNT] | Total amount (€) of all subscriptions together (paid and unpaid) |
| [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 |
| [MEMBERLASTSUBPAYWAY] | Payment Method of Last Subscription |
| [MEMBERLASTSUBOPTIONAMOUNT] | Options Total in Last Subscription |
| [DATENOW] | Today’s Date |
| [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] | Sum of the subscription amount + pro rata + options − the discount from an action or promo code (€) |
| [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 |
| [MEMBERSUBAMOUNTPERIOD] | Monthly amount (€) of the selected subscription, without the options. If the subscription uses pro rata type 2, this code shows the amount of the follow-up line. Use [MEMBERSUBPERIODTOTAL] if the options have to be included. |
| [MEMBERSUBPERIODTOTAL] | Monthly amount (€) of the selected subscription, including the chosen options and minus the promotional discount. Use this on a contract to show the amount that is actually collected by direct debit. |
| [MEMBERSUBPERIODSTART] | Start date of the first full period of the selected subscription. On a contract with pro rata, this is the day the first full month starts. |
| [MEMBERSUBPERIODEND] | End date of that first full period. If there is no end date, a dash is shown. |
| [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] | Answer given in the 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 start 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 |