Since I have received some great help with my present Database, it is off to a great success with the Human Resources department (we are using it to post and maintain all the current job listings available to the public). Now, we had a second idea for this database, which seems to be pretty straight forward, and I believe I should be able to handle it without too much trouble (Lauren, I hope you're reading this, cause I just might need ya again, though ).
The idea is for an online resume bank, where people out there can log on to our site, post a generalized resume using the DBMan form, and we will be able to match these resumes up with jobs that open up at a later time. My question here is two fold...
1) How would I go about setting up an auto emailer that when the visitor has finished posting his/her resume, they would receive an email thanking them for submitting it, visiting our site, reply if they have questions, and so forth? (And yes, one of the fields in the resume form would be for their email address) If they do not have an email address (for instance they used the computer at the local library or such), set up DBMan so that it would email the HR person in charge of the database, giving them the person's name and postal address so that we can do a snail mail version of the email?
and 2) Later on, when the HR DBMan admin person does a search through the database to find matches for a job that opened up, if there is a match (or several matches), I would like to offer the admin the ability to check a box next to each match (like you do when you want to delete a record) so that they can then hit a button that would fire off another pre-made email. That email would inform the applicant that their name was matched up with a job, if they are still interested....and so on. I figure I can make a premade search so that it will sort between the matches with and without emails.
Let me know if this is possible, I would love to try it out. Thanks for any help or advice you can offer.
Andrew
The idea is for an online resume bank, where people out there can log on to our site, post a generalized resume using the DBMan form, and we will be able to match these resumes up with jobs that open up at a later time. My question here is two fold...
1) How would I go about setting up an auto emailer that when the visitor has finished posting his/her resume, they would receive an email thanking them for submitting it, visiting our site, reply if they have questions, and so forth? (And yes, one of the fields in the resume form would be for their email address) If they do not have an email address (for instance they used the computer at the local library or such), set up DBMan so that it would email the HR person in charge of the database, giving them the person's name and postal address so that we can do a snail mail version of the email?
and 2) Later on, when the HR DBMan admin person does a search through the database to find matches for a job that opened up, if there is a match (or several matches), I would like to offer the admin the ability to check a box next to each match (like you do when you want to delete a record) so that they can then hit a button that would fire off another pre-made email. That email would inform the applicant that their name was matched up with a job, if they are still interested....and so on. I figure I can make a premade search so that it will sort between the matches with and without emails.
Let me know if this is possible, I would love to try it out. Thanks for any help or advice you can offer.
Andrew