Archive for April, 2008


How to add a “How Did You Hear About Us” survey to WebJobs

Wednesday, April 16th, 2008

This will go in the employer registration form, or both. For the siteowner to review the data, it should go in Smartway as well, under the Statistics section. If adding to the job seeker registration, just follow the same instructions, but use the jobseeker files in the engine/pages and smartway/conf directories.

Step 1

Make new fields in database (use phpmyadmin or a similar tool to make it really easy!)

  • In jb_select_boxes table, make up a group name, such as “referral sources”. Insert a new data record  for each referral source that you want to use. Indicate referral source as the group name. Use the name of the referral source you want to track (i.e. Google) for the name field. The relative order indicates the order in which you want the names to appear in the dropdown list. 1 is on top, 2 is next, etc.
  • In jb_users table, add a new field called referrals - varchar (128), null — to store the data that users choose on their registration form.

Step 2

Edit the php files to pull these new fields.

  • In engine/pages/register_employer.php — around line 148, insert this line, in between ’signup_time” and ‘timezone” lines.

‘referrals’ => $sql->escape_string($input[’referrals’]),

Around line 154, add referrals into array. It should look something like this:

array(’login’, ‘password’, ’status’, ’salutation’, ‘first_name’,'middle_initial’, ‘last_name’,
’suffix’, ’suffix_titles’, ‘company_name’, ‘completed’, ’signup_time’, ‘referrals’, ‘timezone’, ‘language’));

(more…)