Hello,
I give you below what the current database does. Take note that this database has more than 10 years, it was programmed in php 5.6 which currently poses many problems of compatibility with the new servers. For this reason we are trying to go towards a toolset solution.
hotesse.ch recruits people and places them in various events throughout Switzerland. It may be an event of major brands or as a hostess in a car show or simply to distribute flyers etc. ... The hostess customers are generally large companies of known brands.
Below are the steps:
-1- the candidate can register on our site exclusively via our online form visible here (capture01) (hidden link):
This form contains a lot of fields because it must then allow us to search precisely for the candidate(s) that correspond to the requests of our customers (height, spoken languages, height, smoker?, driving license? visible tattoos? etc...).
The data inserted in this form are directly injected in the database and are visible immediately in the backend by the administrator (capture 1)
The administrator can then validate this registration or refuse it if it does not correspond to the criteria of our company.
-2- Once validated the candidate can connect with a login and password and modify his registration (e.g. change of address or phone number etc..). But the most important thing is that he must be able to add photos of himself. (capture 2 & 3)
-3- our customers make requests and we look for candidates
For example for an international show in Geneva (car show) our customer is looking for: 4 hostesses who speak French and English level A1 + who do not have visible tattoos + who measure minimum 175cm + are ok to move to Geneva.
-4- the backend of our system contains 3 sections (capture4):
Section 1 (left sidebar) which contains the search fields
Section 2 (top of the site) which gives the list of results + all emails in a single box
Section 3 (bottom of the site) which allows you to see the candidate's file (if you click on the magnifying glass).
In order to know if the candidates are available and interested in the mission, the easiest way is to send them an email. As it would be complicated to send an email separately to each candidate, we made a simple php loop that allows, in addition to the list of results, to group all the email addresses in à box (see screenshot).
Then you just have to copy the content of this box and paste it in Outlook to send a message to all the candidates at once. Without this box you would have to copy and paste each email address individually. When there are dozens of different applications per day, it is simply too time consuming and impractical to copy each email address individually from the list.
The bulk email sent to applicants is relatively simple:
Date and location of the event, work schedule, hourly wage and sometimes different relevant information.
My question:
1. Is it possible to have all the email addresses of the request in one box?
2. Is it possible to create a registration form like on our current site?
3. The hosts/hostesses will be able to modify their files?
Sorry for this long message 🙂 but I wanted to explain how our current system works and if it is reproducible with toolset
Best regards
R.Carfagno
Translated with hidden link (free version)