Our platform doesn't currently offer a built-in lottery feature, but we have a workaround using a spreadsheet! It's a simple process, but requires a little manual effort.
Here's what you'll do:
Set Up Your Event: When setting up your event, set all participant limits to zero. This ensures all entries automatically go to the waiting list.
Download the Waiting List: When it's time to select participants, click the "Download CSV" button located above the waiting list table in "Manage" > "Manage Waiting List." This will download a file containing a list of all dogs and handlers currently on the waiting list.
Open the CSV File: Use spreadsheet software like Microsoft Excel or Apple Numbers to open the downloaded CSV file. This will display a table containing information about each waiting list entry, including dog name, handler name, and other details.
Sort the List Randomly: Here's the key step! Most spreadsheet programs offer a "Sort" function. Use this function to randomly sort the list of waiting list entries. This ensures a fair chance for each dog to be selected.
Select the dogs: Once the list is shuffled, you can choose the desired number of entries from the top of the list as your lottery winners.
Let the dogs in from the Waiting List: The "winning" dogs can now be selected and allowed in from the Waiting List. The remaining dogs can remain on the waiting list. See these articles for guidance:
That's it! With this workaround, you can effectively run a random lottery for your event using a simple spreadsheet. Remember, confirmed entries (both paid and allowed to be paid later by check) cannot be undone. However, if you need to make adjustments, you can always cancel and re-enter specific entries.
