I have been charged with developing CivicCrm for my place of business.
The company I work for is a nonprofit and we help people with disabilities both mental and physical. The Department that deals with seniors needs to produce reports to certain agencies. As part of the reporting, a matrix must be filled out – This is a questionnaire.
I currently have all of the question fields created in sections/tabs under CivicCase. The matrix is grouped by questions. For example a section entitled Income will have 4-5 questions based on Income. Depending on the yes or no answers a final field (#6) will need to be automatically populated. For example the questions are:
- Does the household have income (both earned income and cash benefits)?
- Is the household's income greater than or equal to 200% of Federal Poverty Guidelines?
- Does the household show appropriate spending habits (Focus on meeting basic needs before purchasing luxuries, no unusually high costs, no spontaneous or inappropriate spending)
- Does the household need assistance (Outside of own income) to meet basic needs?
- Does the household have discretionary income and the ability to save?
- Score:
So if 1 is answered yes you would continue to 2. If 2 were answered yes you would continue to 3. If 3 was “no” then a score would need to be recorded in field #6 above and no further questions would be needed and the rest would need to be changed to no. There will be several sections that will be about employment, Housing, etc. that would need to be scored similarly.
I have currently been able to use JavaScript to change the fields but when saved the incorrect value is saved in the database. I am using 2 answer dropdown selections.
I know this is probably something simple I am missing. What value should I be changing for it to save to the database?
CivicCRM version: 4.7.4 Drupal: 7.43
I am not using anything other than a custom jQuery script that I am including in the head of the document using the Drupal template.php file.
Thank you C Tyler