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 Harrisonbharrison@datablender.ioDataBlender - Quick Base Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

prashantmaheshw · Answer

HI Blake,

Thanks for the advise, I've managed to do precisely how you mapped this.

Only thing I changed was instead of embedding answer table , I did a combination of splitting the list to bring each individual question to form and form rules.&nbsp;

Thanks------------------------------Prashant Maheshwari------------------------------

blakeharrison · Answer

That sounds great!------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quick Base Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

Forum Discussion

Create a question list for Recrutiment

Related Content

Form Rule Question

Jinja Question: Adding business days to today

Chart Question

Questions & Checklist setup

AI Smart Builder for Creating Apps and Streamlining Pipelines