A program that manages a database.
I need a database that can have information entered into it using a PDF form. I need the PDF form created.
Also I need to be able to enter information directly.
The database needs to email information directly using IMAP.
## Deliverables
These are the exact specs of what I need.
I'm creating a database of names.
The information will be as follows,
1 A name
2 A picklist of which category the name fits into
3 Comments about that entry
4 The date it entered the system
5 The date it expires
6 Which email address entered it into the system
7 Which email addresses the name was assigned to
8 The number of times the name was assigned
So for example one entry would look like this
Joe Fobes
5
A very strong opportunity for us
09/09/08
09/10/08
joe@[login to view URL]
jim@[login to view URL], Jack@[login to view URL]
2
I will have an email account that will be using gmail as the email server.
I will have people send a blank email to the address. They should get an auto response from that address with the information as to how they can enter information into the system and access information from the system.
This will be using a PDF form (for both functions). I will give clear instructions on exactly how the PDF form should look.
Some of those using the system will have email only. Therefore the PDF form has to have an option to be emailed as an attachment after it's filled out OR it can be submitted directly for those with web access.
If it's emailed as an attachment it need to be able to be automatically grabbed by the database from the receiving email account (using IMAP) and submitted.
I also would like to create an option that one can choose to get reciprocal information, that for every name in a certain category that one submits, he receives a name in that category. This will be on the PDF.
All names in the database will expire after 30 days, hence the day before names expire I need the program to send out an email to the address that submitted that names or names and ask that person which entries they would like to have renewed.
Also all requests for names will expire after 30 days, hence I need the program to send out an email the day before a requester expires asking him if he would like to receive new names to replace the old ones.
I also want to distribute the names evenly, so if one name has been given out 3 times and the other name has been given out twice, I want the next request to be sent the one that was given out twice.
I would also like to have the outgoing email include a stat of how many names have been distributed thus far.
I also need the capability to edit the form of the outgoing email, so that I can put other information into that email (such as a link, etc.).
I also need the ability to enter information directly into the database and to get information directly from the database.