[Rob]

Hi – Someone from BePro replied to my post on reddit and offered to build a custom plugin for me: http://www.reddit.com/r/Wordpress/comments/35e14j/email_plugin_that_queries_a_database_and_sends_to/

Here’s what I’m trying to accomplish, please advise next steps:

I am building a site that connects two groups of people. The URL is http://www.goalie411.com. The two groups are hockey players and hockey goalies.

There is a form (http://goalie411.com/im-a-goalie-looking-for-ice-time/) that the goalies can fill out indicating:
Name
Phone Number
Email
State they live in
Level(s) they can play at (selected from a drop down list, values are A, B, C, D or lower)

These goalies will be stored in a database table. This should be treated like a registration process, so they can go into a page where they can edit their information.

There will be another form (http://goalie411.com/im-a-player-looking-for-a-goalie/) that players can fill out when they need a goalie indicating:
Name
Phone Number
Email
State they need a goalie in
Level
Date
Time

I am using Contact Form 7 to create my forms. I am using Contact DB to store to the database.

My goal: when the player hits the submit button, an individual email is automatically sent to each of the goalies on the database where

Goalie State = Player State
AND
Goalie Level <= (is less than or equal to) Player Level

The email will contain the data entered on the form. I should be able to edit the HTML of the email form, or it should connect to AutoChimp so I can managed the email HTML there.

Back End
In the back end for my admin use, there should be:
The ability to send emails from multiple forms – I’ll need an indicator where I can select a form by its HTML name attribute or other method. That field should be a free text field where I can just enter the name. Example: if the code starts with:
<form action=”form_action.asp” method=”get” name=”myForm”>
Then I should be able to simply enter: myForm into the field.
A section where I can enter the HTML for the email what will be sent to goalies (if not using AutoChimp)
A list of available variables (variables = the form data, ex. Level of Play, and an example of how to enter them into the HTML
The ability to download and/or upload a CSV file of the email list.
A text field where I can enter an email address that I want to remove from the database if someone wants to unsubscribe from the list

[BePro Software Team]

Hi,

Thanks for posting this request. Have you had a chance to download and test out BePro Email? It is 100% FREE and will provide most of your backend needs.

– https://www.beprosoftware.com/shop/bepro-email/

The interface (plugin) that will need to query the database for your outlined criteria and add it to the template that BePro Email is sending, will need to be custom built. We can share technical details if you are a developer or a quote if you need help

We are actively working on an optout feature. You can anticipate seeing this added to BePro Email within the next 7-10 business days.
___
BePro Software Team

[Rob]

Hmm. On reddit you seemed to indicate you would build this for free as long as I test and review it and then buy the yearly support. Is that no longer the case?

If not please provide both developer notes and a quote.

[BePro Software Team]

Hi,

My apologies for the confusion. The offer on reddit was create a scenario where an email is sent to a specific mail chimp list, when a wordpress action hook is triggered (form submitted).

You have shared a few details here that were not shared on reddit. Specifically, the use of 3rd party form and database plugins. This aspect was not anticipated when the offer was extended. In fact, we anticipated you would use our BePro Listings plugin to upload data and allow users to search. This would have required us to create a simple bridge which emails the search results

The new requirement to integrate with the 3rd party plugins is unfortunately very specific to your needs. This eliminates any chance of commercialization and hence incurs the cost. A member of our team will update this post later today with notes and a quote.

___
BePro Software Team

[Rob]

Hi: I’m not tied to this 3rd party contact form or db plugin. I wasn’t aware of your listings product. How about this for a next step. Tell me how you can meet the intent of my idea using be pro products.

[Rob]

Hi BePro folks – any update on this?

[BePro Software Team]

Hi,

We suggest that you use our BePro Listings plugin to store and showcase all of your players and goalies. You could use the categories to store the various levels. Users could then enter their level and address info during the creation of their listing

BePro Email would store all of your emails. We are willing to create an addon which emails all users which match the category and state when a wordpress action hook is triggered (form submission).

Note, there is a limited list of custom fields that you can setup in the email. Reference our BePro Email shorcodes and other documentation to confirm this setup is right for you

– https://www.beprosoftware.com/documentation/bepro-email-features/
___
BePro Software Team

[Author]

Posts