ANZA Admin Links

WordPress Admin

Google Analytics

MembershipWorks

ANZA Reporting System

Stripe

CampaignMonitor

 

Snippets

Inserting an image into MembershipWorks emails:

<p><img src="https://anza.org.sg/assets/newsletter-header.jpg" alt="" width="600" height="96" /></p>

 

Inserting a menu into a sports page (remove the spaces directly inside the brackets):

[ insert page='athletics-menu' display='content' ]

This will display as follows:


 

Inserting a menu into a sports page (remove the spaces directly inside the brackets):

[ insert page='sponsored-content-tag' display='content' ]

This will display as follows:

  •  Sponsored Content 


 

This is an Excel formula to convert MembershipWorks’ date format to an Excel date:

=DATE(RIGHT(BC2,4),(MONTH(DATEVALUE(LEFT(LEFT(BC2,FIND(",",BC2)-1),3)&" 1"))),(RIGHT(LEFT(BC2,FIND(",",BC2)-1),2)))

This parses the date in BC2 which should be in the format ‘Mar 12, 2017’.

=DATE(RIGHT(P2,4),MONTH(DATEVALUE(LEFT(P2,3)&" 1")),RIGHT(LEFT(P2,6),2))

This parses the date in P2 which should be in the format ‘Mar 09 2008’.

 


 

These links take to you to the 3 reports

New members

Renewed members

All Members