Building Your Business

It is easy to set up online registration using Relevant Tools. We have implemented online registration for many sports, such as swimming, water polo, soccer, lacrosse, and Little League baseball. Rugby is the latest sport that is using Relevant Tools for online registration. As with many sports teams that only collect payments once a year, Highlanders Rugby is using PayPal to collect online payments.

To get started a registration page lists all the steps for a parent to do:



The registration information form is a standard Relevant Tools web form where all the information collected is stored in a Relevant Tools database.



Each player completing the registration form is automatically assigned a unique confirmation number using Relevant's auto increment fields. This confirmation number is used to track the payment. Payments can be made online using PayPal or by check.



The confirmation number and player name are passed into PayPal. Online payment is completed using PayPal's standard interface with a return to the rugby website when payment is complete.



The PayPal payment notification is automatically processed by Relevant Tools and a record is created in a Relevant Tools PayPal database. The player registration information is updated with the payment details. The volunteers running registration for Highlanders Rugby can easily generate reports.



Full details of the PayPal transactions are available in the Relevant Tools PayPal database. The credit card information itself is not stored online for added security and it is not needed in Relevant Tools as PayPal is handling the actual credit card transaction. You can create custom views of your PayPal and registration databases to show the information you need to see.



Let us know if you need help with your sports league registrations. We can customize the registration forms and payment processing for your particular sport and have you up and running right away.

Labels: online payment, registration, web forms

You can easily create custom views for your online database. With a custom view you can control which columns are data are displayed and the order of display. This is particularly useful if you have a database with a lot of fields that are used for different functions. For example you can define a contact view, a status view, a performance view, and so on.

To get started click on databases. Make sure your database that you want to define the view for is selected as the current database. Click on 'create/edit/delete' a view to start the process of defining or customizing a view.



To create a new view give it a name or you can select an existing view to edit.



Select the field that you want to use for each column. You can also specify the maximum column width if you want to have some columns be wider or narrower.



In addition to using any of the fields that you have defined for your database you can also include system fields in your view. System fields are fields such as "created on" or "IP address" that are automatically added to each record.



When you display your database you can toggle the view from 'all user defined fields' to the views that you have defined. The fields will be displayed in the order you have specified.



In addition to controlling the view that you see on the screen, views are also used to control what data is exported. When you export your database only the fields that are used in the current view are exported. If you want all fields exported make sure you are using the view 'all user fields'. If you want to export system fields such as the date created and IP address you will need to define a view that includes those fields.



Have fun creating views for your data. You can change your views at any time.

Labels: databases, views