Create a question list for Recrutiment

Question

Objective : Make 1 dynamic form where question to be asked to candidate can change as per the profile of the candidate. Current RealityIt's a 3 step process, I've a table where I store generic questions field as Q1,Q2,Q3,Q4 etc . I then create separate form for each position where I use alternate text to edit the question to be asked. The process is tedious and it's difficult to overview questions to be asked to candidate.

I've then created a separate form for each position where I use alternative text to change the text of the question. 
END RESULT

------------------------------Prashant Maheshwari------------------------------

BlakeHarrison · Answer

It looks like your application may need a more complex structure. Instead of having the Questions on the same table as the Application, I would encourage you to think about setting up a separate table that would end up being your pool of Questions. Since some of your questions may NOT change from one position to another, you would need only a single record for each unique Question. I would then have a Positions and a Position-Questions table. Positions would be just the list of different positions you have need to generate Applications for. Position-Questions would be where you associate the different Questions with each Position. Finally, you would have an Applicant-Questions table where you would associate the Application and the Position-Questions. The Answer field would be on the Application-Questions table and you would probably want to place them in an editable embedded report on the Application form. The structure for this setup would look something like this:

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------

Sign up

Login to the community