We work in research with sensitive populations at our university. When we design simple experiments, its always best to know who we'd like to select for our populations, but we are ethically limited from actually knowing who they are. This creates a bit of a problem.
The solution we must come up with requires two separate systems that cannot speak to each other directly: one for collecting detailed information about a person anonymously, and the other for contacting that individual via email and a message.
PART ONE: Collect the personal data:
We currently use LimeSurvey to collect anonymous information about populations. How old they are, what they do in their spare time, what languages they speak, that sort of thing. At the end of the survey, they are given a unique serialized number that they must write down and keep safe.
PART TWO: This is where you come in:
We need a separate system that we will use to contact individuals by email. We looked at CRM systems and email marketing systems, but nothing allowed us the flexibility or anonymity we desired.
Here are the two connected processes we require:
1. FORM: Unauthenticated user Creates a new record that consists of a user-entered: Unique, serialized number, first name, last name, and their email address. Upon submit, this information is stored in database.
2. FORM: Allow a user to type in serialized number(s) and select from a jquery/ajax dropdown to build a list of numbers. Next, a textbox containing a space to provide a message that recognizes URLs. (TinyMCE might be fine). Upon Submit, the email addresses associated with the selected numbers are emailed individually with the message. If successful, a success message is displayed, if not, an error message is displayed. The message may not contain reference to the emails that were used, just the numbers that were successfully sent the message. At the same time, a record of this transaction (TIMESTAMP, Message, and Numbers) would stored in a table in the database.
ASSUMPTIONS:
- The reply-to address from the message will be an email address we can change
Attached is a screenshot of the workflow we're looking for.
Dear Customer!
I am an expert PHP/MySQL developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service exciting my customers. Please contact in PMB to discuss details.
Best Regards,
Zeke
Let me work for you. Please have look of the recent work.
i am my self developer not any company or agency so you can directly communicate with me.
see my recent work for the technical expertise along with reviews & feedback on my profile page.
let's discuss and get started.
Hi, I have read your requirements and I am very confident to do this project from start till end. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message board. Thanks
Greetings,If you're looking for quality work, please consider my services. We have more than 6 years of experience in same field. I worked all over the world and having premium clients spread out on all the continents. Browse our Portfolio at freelancer.
Hello, I've read all of the spec you provided and it seems like interesting, but straighforward project. I would be very happy to get involve in it. It will require MySQL, PHP and some javascript AJAX requests. I can offer you clean, well commented code and Skype availability during the project.