What is Waitlisting?
Setting a limit to the amount of registrations is standard practice for many events. For example, if you only have 500 seats available for your gala dinner, you certainly don’t want to be selling more than that. Now, normally when your event has hit its set capacity, the registration limit feature kicks in and prevents any further registrations. This is great and all, but let’s say someone cancels and now you’re stuck with an empty seat, or maybe you found some more space at the venue for another table and can increase your registration limit — this is where waitlisting comes into play.
By using the waitlist feature in Event Wizard, you can allow registrations to continue past your event’s set limit, but have them placed a list separate from the main registrants. Then, in the case of any cancellations or the like, you can bring up your waitlist and see who’s next in line. Sounds pretty easy, right?
Let’s start by heading to the main edit screen, (ie: task list) of your event.
You can find the waitlist feature by going to the purple section of your task list, selecting Properties/Info from the submenu, then selecting Enable/Disable other advanced options.
On this next screen, you’ll see a bunch of advanced options for your event that you’re probably already familiar with, but the main one we are interested in is Enable/disable waitlisting — ensure this box is checked and click the save button. Oh, and you may want to double-check your Registration Limit while you’re here!
Notification and Confirmation
After activating the waitlisting feature, two new pages/sections are created: a waitlist notification and a waitlist confirmation.
The notification portion will appear above your registration form in place of your registration page contents, (if any exist). This is to notify the user that the event has reached its capacity and their registration – should they choose to continue – will be placed on the waitlist.
The confirmation page will appear in place of the Thank You page, which is displayed once the registration is submitted. This is simply to reiterate to the registrant that they haven’t been fully registered and that they have been placed on the waitlist.
Both of these sections have been titled and filled with sample information, however they can also be customized by heading to the purple section of your task list and selecting Edit Custom Pages.
To edit them, simply do so as you would with any other custom event page by clicking the Edit icon in the tools column and modifying the contents and properties as you see fit. It’s important to keep in mind that these pages will need to be translated if you have multiple languages enabled, just the same as any other page contents.
NOTE: Be mindful of the Page Type dropdown that appears on the edit screen(s), as this is the key identifier for each one and will determine which page is being used for which function. Only change this value if you’re familiar with page types in Event Wizard.
Reports and Management
Enabling the waitlisting feature also opens up the Waitlist report, which is the main tool for managing your waitlist after you start taking registrations – let’s head over there now.
After landing on the reports summary page, open the main Reports and Tools dropdown and select the Waitlisted report.
Here you will see the registrants that came in after the registration limit was reached. It’s important to note that any names on this report do not appear anywhere else in your reports, since they are not fully registered at this point.
In order to change a “waitlisted” registrant into an actual registrant, it’s as simple as finding their name in the list and checking the box beside their name. By doing this, you’re effectively completing their registration, making them a full, proper registrant for your event — they will now appear in all the appropriate reports.
See? Told you it was easy! If you have any questions about our waitlist feature that may not have been answered here, please don’t hesitate to drop us a line.
We offer many different e-commerce gateways in Event Wizard® when it comes to collecting fees from your registrants. However, some users prefer to use PayPal, so here’s a quick rundown on how to set it up in your event.
Enable PayPal as a Payment Option
The first step is to enable PayPal in your event’s payment process.
To do this, head to the orange section of your event task list and select “Edit your payment options and details”, as seen above.
On the page that opens up, you’ll notice the PayPal panel on the right side.
In the first box, enter the email address associated with your PayPal account. Then, under Item Name, enter something relevant to your event/fees. This will be the name that appears during the PayPal checkout process for this event.
Enable Instant Payment Notification (IPN)
While it’s not required to enable IPN, we strongly recommend doing so. If you don’t, you’ll end up having to manually check your PayPal transactions on a daily basis and manually flag each successful transaction as Paid in your Event Wizard® attendee database using the Event Wizard Reports. It is a huge time-saver, especially when it comes to higher transaction volume.
How to Enable IPN:
- Logon to your PayPal account
- Click on the Profile link under the My Account tab
- Click on the My Selling Tools link on the left side of the page
- Click the + beside Getting paid and managing my risk
- Click the Update link next to Instant payment notifications
- Select Receive IPN messages (Enabled) and enter the following URL in the text box provided:
- Click on the Save button to save your information
There are a few more steps on how to check your transactions and test your IPN integration, which we have compiled into a quick-reference PDF for your convenience.
As always, if you have any questions regarding PayPal integration or anything else in Event Wizard®, you know where to find us!
Emails can be found all over Event Wizard®, like the ones that are sent automatically when someone registers/pays for one of your events, or sent manually using the Mass Email tool in your event’s reports section. While you can’t directly attach files to these emails, you can easily create a link to the file using your online file hosting space, which is included with every Event Wizard® account.
1. Upload Your File
The first step is to navigate to My Files in Event Wizard®, which can be found in the main menu at the top of every page.
From here, you can either click the Upload button and choose a file local to your computer, or simply drag-and-drop it into the browser window. You will likely notice a progress bar at the bottom of the screen as your file is uploaded; the speed of which will depend on the file size and the speed of your internet connection. Once the uploader has finished doing its thing, you will see your new file in the list.
2. Create Your Link
For this example, we are going to use the Registration Confirmation Email.
Now that you have uploaded your file, head over to your event’s task list, open up your Edit registration confirmation email page and scroll down to the editor. Highlight the text into which you’d like to insert your link and click the Link button in the editor’s toolbar.
In the popup that appears, click the Browse Server button, which will open up your list of files in a new window. Locate your newly-uploaded file in the list, (likely near the top) and click the file name to close the window and insert the link into the URL box.
NOTE: Some older email clients require that you set the Target of your link to open in a new window. To do this, click the Target tab at the top of the popup and select New Window (_blank) from the list of options.
Click OK to confirm, then click Save to lock in the changes to your email contents.
That’s it! Now, when someone receives this email, the embedded link will allow them to download the linked file from your Event Wizard® storage. You can also use this method when linking to files elsewhere in your event; to an agenda PDF on your Welcome page, for example.
The reporting system in Event Wizard® is very powerful and feature-rich. Not only does it give you a full overview of your event’s progress, it also allows you to manage your registrants in just about every way imaginable. One particularly useful reporting feature is the Excel download function, which allows you to download an Excel-compatible file containing the report of your choice.
However, some reports contain names that use special characters, (like accented letters, for example) and depending on what spreadsheet software you’re using, it may not be able to read them properly. There are a couple different ways you can deal with this issue:
Method 1 – Convert and Import into Excel
If you’re using Excel to open your .csv file, there’s a tried and tested way of preserving special characters:
- Open Excel to a new document
- Click the Data menu at the top, then select Get External Data > From Text, (or Import Text File…, depending on your version)
- Ensure All Files are selectable and choose your downloaded .csv report file
- In the window that opens, choose Delimited for your data type, and UTF-8 as your file origin – click Next
- Finally, choose Comma as your delimiter and click Finish.
If you’re on a Mac, the above method may require an extra step in order to make it work properly:
- Before opening Excel, open your .csv file in TextEdit
- Click File > Duplicate, then File > Save to save as .TXT file, but be sure to select UTF-16 from the Plain Text Encoding dropdown in the Save dialog
- Follow the same steps as the PC instructions above, but instead of using your .csv and UTF-8, (in step 3) choose your new .txt file and Macintosh as your File Origin.
Regardless of whether you’re on a Mac or PC, the import window in Excel provides a preview of what your data will look like once imported. If for some reason the above steps don’t work for you and you’re still getting strange looking characters in your preview, try different encoding/file origin types until you find the one that works for your setup.
Method 2 – Open in Google Sheets
This method is a bit easier than above and works on all platforms, since it’s done through your web browser. It also doesn’t require you to have Excel on your computer, so there are no software costs:
- Go to https://docs.google.com/spreadsheets/ and sign into your Google account
(NOTE: if you don’t have a Google account, it’s quick and free to create one through the link above)
- Create a new spreadsheet
- Click File > Import
- Click the Upload tab and select your downloaded .csv file
- Select Replace spreadsheet as your Import action, Comma as your Separator character, and then Import
You can then use your new spreadsheet as is, or you can download in a variety of file types by clicking File > Download as.
Hopefully one of these methods will help you deal with special characters in your report downloads. As always, if you have any questions about this or anything else in Event Wizard®, please drop us a line.
Merge tags are a vital tool when composing your confirmation emails, since they allow you to personalize each registrant’s emails by automatically inserting things like their name and registration info. Our latest system merge tag generates a personalized link to each registrants’ ticket, for when it comes time to check them in at your event using our free mobile Attendee Scanner app.
Adding a Ticket Link to your confirmation email is easy. Start by going to your event task list and clicking the Edit Payment Confirmation email link.
Next, click the Insert System Merge Tag dropdown in the editor’s toolbar and scroll down – you’ll notice an option to insert the Ticket Link. Once selected, the Ticket Link merge tag will be inserted next to your cursor in the editor.
NOTE: It’s important to keep in mind that the ticket will only successfully scan once the registrant has paid for their registration, so it makes the most sense to place this tag in the Payment Confirmation Email, rather than the Registration Confirmation Email.
Much like an <a> tag in HTML, the Ticket Link merge tag consists of an opening tag, link text/contents, and a closing tag. Please ensure the opening and closing tags aren’t altered, since they tell the system where to insert the custom link when the email is eventually sent out. The only part we need to be concerned with is the link text between the two tags – change it to something more relevant, similar to the screenshot above, then click Save.
It’s important to test your confirmation email to ensure the link is appearing and functioning properly. Once you receive your test email, assuming everything went as planned, you’ll notice that the Ticket Link merge tag has been transformed into a proper link, which gives access to a personalized ticket for the registrant to whom it was sent.
That’s it! Nice and easy. If you have any questions about the new Ticket Link merge tag or any other merge tags, give us a shout. Also, be sure to download our mobile Attendee Scanner app so you’re prepared for when it comes time to check in attendees at your event – it’s free!
Group registration is a vital tool for a lot of our clients, which is why we have developed one of the most powerful group registration systems in the industry. When utilizing group registration, sometimes our clients want to offer discounts based on different scenarios – this is where group rules come into play.
Below are six example scenarios of where group rules can help automatically apply discounts to your event fees.
1. 10% discount to all members in a group of 10
Say you want to offer a bulk discount to all members of your group. In this scenario, the discount will only be applied when the 10th group member registers and will be applied to all members of the group. If any more than 10 people register for the same group, the extra registrants will not receive the discount.
2. Free registration to the 6th member of a group
This scenario is similar to the “buy one, get one free” deals sometimes seen in your local department store. More specifically, this example is a “buy 5, get 1 free”, where the 6th registrant in a group gets a discount of 100%.
3. $50 discount for everyone if a group has AT LEAST 3 members
Similar to the first example above, this one applies a discount to all group members. Where it differs is that it will continue to be applied to group members, even after it hits a certain threshold, (in this case, 3 members).
4. 25% discount to a group of at least 2 members if they register before a certain date
This one is useful for rewarding group members for early registration. In this example, we are applying a 25% discount to everyone in a group, (minimum of 2 people) who registers before a certain date. If anyone is added to the group after the early-bird fee expires, they will not receive the discount. It should also be noted that you need to set up your fee with an early-bird rate in order for this to work properly.
5. 15% discount to groups with at least 4 members but no more than 6 members
Say you are trying to fill tables at a banquet that hold a maximum of 6 seats, but in order to fully cover the cost of the table you need 3 or more people at each one. The discount in this scenario doesn’t get applied until after you have hit your 3 seat minimum, but will encourage people to fill the tables to their capacity of 6. Note that you would need to set your max group size to 6 as well.
6. Pay for an entire group of 8 in one step
This is another useful one for banquets or dinners. Say you’re selling two different ticket tiers: single seats, and full tables of 8. You can set a group rule to apply a 100% discount to all but the first group member if they purchase a full table. That way, the group administrator, (first person registered per group) will essentially pay for all group members that follow. This is especially useful in scenarios where the group administrator is not only paying for, but also registering the rest of the group members. Note that you would need to set your max group size to 8 as well.
These are just six examples of how you can utilize group rules, but the possibilities are pretty much endless. Keep in mind that you can apply these rules at any time, even if your event is already open. And group rules are smart – they know when someone has cancelled from the group and will re-apply the rule to the new group. If you have any questions about group rules, drop us a line.
As an event coordinator, you want your event to go smoothly from start to finish. The last thing you want to be doing is chasing your registrants down trying to collect missing payments, but it does happen from time to time. Not to worry, we have compiled three tried and tested methods to help you collect any outstanding payments from your registrants.
1. Email Them Their Confirmation Link
It’s possible that one or two registrants simply missed the payment buttons on their confirmation, (i.e.: “thank you”) page; emailing them a quick reminder is the easiest way to get them back on track. Open up your event reports and locate the name of the registrant in question.
Click the View the Registration Details icon in the Tools column for that registrant, which will open up their confirmation page in a new window. Copy the URL from the address bar of the popup and paste it in an email to your registrant. Once received, they can click the link to come back and make payments using the methods you have enabled in your event.
Note: If you only have online payment enabled, simply replace the /thank-you/ portion of the URL with /checkout/. By sending them this link instead, they will open up directly to the checkout process rather than their confirmation page, saving a step.
2. Include the Payment Link in Your Registration Confirmation Email
Rather than waiting for any missed payments, you can take a preliminary measure by including a personalized payment link in your registration confirmation email. This is done using the Payment Link system merge tag, which uses your registrant information in Event Wizard® to generate a personalized link for each individual registrant.
When editing your registration confirmation email, click the Insert System Merge Tag dropdown in the editor, and select Payment Link. This will insert the payment link merge tag wherever your cursor is placed within the body of the editor.
The link merge tags work similarly to how <a> tags work in HTML: they consist of the opening tag, link text, and closing tag. In this case, the opening and closing tags make up the portion of the merge tag that is automatically created by the system, so you don’t need to worry about that. The portion you need to concern yourself with is the link text, which should be changed to something more relevant, (such as “Click here to pay for your registration”) so the registrant knows what the link represents. The screenshot above shows the different steps from link creation to the final email.
3. Email All Registrants with Pending Payments
If you have a lot of registrants that have outstanding payments, you can use the email tool within the reports to easily send every one of them a personalized email reminder. Start by going to your event reports and opening the Pending Payments report. Locate the Email icon beside the Reports and Tools dropdown – give it a click.
On the page that opens, you will notice a lot of the same fields from the Edit Confirmation Email page. Start by filling in the boxes with your subject, name, and email address. Next, add some content to your email.
Composing your reminder email is just like composing the confirmation email we did in method 2, only with slightly different information. You can use merge tags to personalize the email with information like the registrant’s name and registration date, but most importantly, their payment link. Once you have your email composed, click the Send Email button.
Hopefully one of these methods will help you to collect any pending payments for your event fees. If you have any questions about this, or anything else Event Wizard®, please contact us.
You asked and we listened! The date input field type has been a part of Event Wizard® for a long time, but it wasn’t very flexible and was due for an overhaul. Thanks to suggestions from some of our clients, we have added some much-needed functionality to the date input field.
Date Format Choices
When a date input field is added to a registration form, it is rendered as three dropdowns: Day, Month, and Year. Until now, these dropdowns always appeared in a static order and couldn’t be rearranged. This wasn’t ideal, since different countries format their dates differently, so we added an option to arrange them as Day/Month/Year or Month/Day/Year, as seen in the example below.
Choosing whether your date input field appears as Day/Month/Year or Month/Day/Year is easy, and can be done using the new Date Format property when adding or editing your date input field.
Default Dates Are No Longer Required
Due to the way the date input fields functioned, they were always required to have a default date. This meant that even if a registrant didn’t explicitly fill out the field, the default date was always present in their response. We completely rewrote the date input field’s functionality from the ground up, which provided us with the option of allowing empty date fields on forms.
Because of this new feature, the only time registrants are now forced to enter a date is if the date input field is specifically marked as “required” by the event organizer. Awesome!
We hope you find these enhancements useful when building your next event. If you have any feedback or requests, please take 5 minutes and fill out our Event Wizard® Feedback survey. Who knows, you might just see your suggestion(s) in the next version update of Event Wizard®!
Statistics and information play a key role in running a successful event. As a user of Event Wizard®, you get a whole suite of reporting tools to view and manage things like who registered for your event, what options they chose during registration, and when they registered. That’s great and all, but what about when a registrant makes changes to their registration record? Enter the Registrant Activity Tracker…
To see the new activity tracker in action, head on over to the reports section of one of your events and open up the By Last Name report. Scroll through the list of registrants and you should notice a new icon in the Tools column for some of the names – give it a click.
Note: If a record has not been updated in any way, the icon will not appear. Only registrants with some sort of activity associated with them, (further to the initial registration) will display the activity icon.
On the page that opens up, you’ll see a list of instances where this particular registrant was either updated or substituted. There are three possibilities for who modified the record: the registrant themselves, an account user/administrator, or a reports user.
Note: If a record is updated by a reports user, the password with which they used to login to your public reports is captured and displayed.
In the case of our example, we can see it was updated on two separate occasions by an account holder, (not the registrant herself) who happens to be an administrator for this event. We can also see the date and time at which the update took place, providing a “timeline” of sorts. From here, we can take it one step further by clicking on the descriptions and drilling down to view all the details.
The page will open up to a table containing all the information that was modified during the record change. The first column is the field that was updated – pretty self-explanatory. The second column is the type of change that happened to the field, of which there are three possibilities:
- Add – Information for this field was not present previous to the update; all new information was added to the field response
- Deletion – Information for this field existed prior to the update; all information was removed from the field response
- Change – Information for this field existed prior to the update; information was changed from one value/selection to another
The final two columns will display the old value/selection of the field field, along with the new one that was provided during the update process.
You can also view the activity for all registrants of an event. To do this, select Registrant Activity from the Reports and Tools dropdown in the reports section.
Not only do we see the two records that we did previously, but we now also see the records that were updated for other registrants, in order of when they were modified. Furthermore, like the previous page, you can click the descriptions to view all the details for that particular record.
We hope you find this new tool as useful as we do. If you have any questions about the new activity tracker or anything else Event Wizard®, give us a shout!
Often times our customers have certain requirements when it comes to processing fees for their online registration. One such requirement is tax-exemption, which can include GST, HST, or PST/QST.
HST exemptions are given to those businesses that are deemed as Charitable Organizations by the Receiver General (a Charitable Organization number will be required) and for any events that are providing services to children under the age of 14. These basic rules are legislated and mandated by the Receiver General. Not For Profits (or NPOs) do not necessarily qualify for HST exemptions. Please see the following links for more clarification:
In order to have tax removed from your event you must download and complete this form, then return it, along with your exemption certificate, to our offices using one of the following methods:
- By email, to firstname.lastname@example.org
- By fax, to 905-420-8852
- By post, to 16-1815 Ironstone Manor, Pickering, ON L1W 3W9
Once we have received this, we will process your request.
If you have any questions about this process, or anything else, please give us a shout.