Search the Community

Hi All, I have a set of question to bring out. I will be need to setup a questionnaires page to let user to fill in. The questions is statics, so i don't think i will setup a module to let admin to setup questions/ update questions. So, the thing i need to focus is to create a questionnaires form to get all the inputs and store into the database. 1. Has your manager spoken to you with regards to your resignation? Yes/No Comment: _______________________________________________________________________________________ 2a. Have you considered other jobs in ABC Company before making this decision? Yes/No 2b. If No, is there any particular area of interest that you would like to consider? (HR can assist with job matches) ________________________________________________________________________________________________ 3. Which factors attracted you to join ABC Company? (check all that apply) A. Interesting Job C. Working environment B. Opportunities for training, advancement, career growth D. Pay & Benefits E. Other ________________________________ 4. What are your reasons for leaving ABC Company? (check all that apply) A. Change in career H. Job Nature, Work load or work hours I. Quality of supervision B. Family or personal needs J. Lack of recognition for work C. Moving from area K. Lack of advancement opportunities D. To further education E. Pay dissatisfaction F. Benefits dissatisfaction G. Work environment So if i create a html form and pass all the value to database, im not sure how to store the check box value, have a look to the attachment. is it not a good practice to store table in a row right? but how could i store a same form in a different row of data? how to store the check box value? i need to create an individual column for them? what is the value should i store when click all the value? this form will generate report in future, i still dun have the template currently, but it should be something like average how many people choose the answer. Need Help..~!