0

I am building a site where users will fill webforms (these are quality of life questionnaires). Users will fill the same form several times. I want to show the change in the value of fields in the webform. For example, if there is a field, say score 1 which has a value of 10 on 13 May 2020, and 15 on 14 May 2020, I want to show that the value has changed by 5 points.

I want to show this using Views as it will allow us to filter by dates on which the form was filled as well as the users (and use contextual / exposed filters).

The Views Aggregator field allows us to calculate the range for a column and using the a modified range formula (which the maintainer kindly developed very quickly) we can show the difference between two values. However, this is constrained to be displayed as a table row and not a field.It also has the disadvantage that the value is always maximum - minimum of the two values.

Is it possible that we can get this as a field in Views (so that I can apply custom css code). The motivation for doing this is to show the value in different colors depending on the value (e.g. red color if the value is more than 10 and green if it is less than 5).

It is noteworthy that each questionnaire can have many different scores computed and I would like to make a display for each. Note that for the display of the change we are looking for change of the recent value as compared to last filled.

Any pointers will be appreciated. Wireframe of desired output

  • What about to do such functionality via nodes? For example, each user should authorize on the site and just submit nodes with answers. Then you can display values via Views module easily – Ivan Tibezh May 13 at 11:43
  • With webform also it is possible to display individual values of the fields. BUt the difference is difficult to get. – Santam May 13 at 12:55
0

Daniel Cothran, the developer of the Views Cumulative field prepared a field (in no time at all) that serves the purpose. The link to the file is available here Measure of Change Field in Views Cumulative Field Module

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.