Re: [Dhis2-devs] Auto-calculated data in entry forms
Hi there, Great that the javascript worked out for you. Unfortunately, I'm not an expert. I had a look at the code below but a simple copy-paste doesn't seem to be working (after modifying the references). Would it be possible that there's an event missing to trigger the calculation? How would that work? Thanks a lot! Robin From: Pamod Amarakoon [mailto:pam...@gmail.com] Sent: 02 September 2014 06:54 To: Ngoc Thanh Nguyen Cc: dhis2-devs; Robin Martens; DHIS 2 Users list; Jason Pickering Subject: Re: [Dhis2-devs] Auto-calculated data in entry forms Hi, Thanks a lot. In fact I'm a medical doctor and have limited knowledhe in Javascript. I managed to get it done with following javascript I created. height enterd in cm and weight in kg. script type=text/javascript function updateBMI() { var ht = document.getElementById(HeightID-val).value; var wt = document.getElementById(WeightID-val).value; if(ht!= wt!=){ var bmi = wt/(ht*ht/1); bmi = +bmi.toFixed(2); }else{ var bmi =Enter Height and Weight; } var inputbmi= document.getElementById(BMI-ID-val); inputbmi.value = bmi; } updateBMI(); /script It serves the purpose it seems. Pls suggest any modifications On Mon, Sep 1, 2014 at 11:52 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.commailto:pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Pamod -- Pamod ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
great. surprised that a medical doctor can write that code. if you turn it to jquery it is much easier. anyway, its fine for now On Sep 2, 2014 11:54 AM, Pamod Amarakoon pam...@gmail.com wrote: Hi, Thanks a lot. In fact I'm a medical doctor and have limited knowledhe in Javascript. I managed to get it done with following javascript I created. height enterd in cm and weight in kg. script type=text/javascript function updateBMI() { var ht = document.getElementById(HeightID-val).value; var wt = document.getElementById(WeightID-val).value; if(ht!= wt!=){ var bmi = wt/(ht*ht/1); bmi = +bmi.toFixed(2); }else{ var bmi =Enter Height and Weight; } var inputbmi= document.getElementById(BMI-ID-val); inputbmi.value = bmi; } updateBMI(); /script It serves the purpose it seems. Pls suggest any modifications On Mon, Sep 1, 2014 at 11:52 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Pamod -- Pamod ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
Hi, Thanx. Is jquery available inside data entry form on the fly or has to link it separately to outside library. On Tue, Sep 2, 2014 at 12:31 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: great. surprised that a medical doctor can write that code. if you turn it to jquery it is much easier. anyway, its fine for now On Sep 2, 2014 11:54 AM, Pamod Amarakoon pam...@gmail.com wrote: Hi, Thanks a lot. In fact I'm a medical doctor and have limited knowledhe in Javascript. I managed to get it done with following javascript I created. height enterd in cm and weight in kg. script type=text/javascript function updateBMI() { var ht = document.getElementById(HeightID-val).value; var wt = document.getElementById(WeightID-val).value; if(ht!= wt!=){ var bmi = wt/(ht*ht/1); bmi = +bmi.toFixed(2); }else{ var bmi =Enter Height and Weight; } var inputbmi= document.getElementById(BMI-ID-val); inputbmi.value = bmi; } updateBMI(); /script It serves the purpose it seems. Pls suggest any modifications On Mon, Sep 1, 2014 at 11:52 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Pamod -- Pamod -- Pamod ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
Hi it is already inside dhis2 (for every dhis2 page). no need for external import Thanh On Tue, Sep 2, 2014 at 2:17 PM, Pamod Amarakoon pam...@gmail.com wrote: Hi, Thanx. Is jquery available inside data entry form on the fly or has to link it separately to outside library. On Tue, Sep 2, 2014 at 12:31 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: great. surprised that a medical doctor can write that code. if you turn it to jquery it is much easier. anyway, its fine for now On Sep 2, 2014 11:54 AM, Pamod Amarakoon pam...@gmail.com wrote: Hi, Thanks a lot. In fact I'm a medical doctor and have limited knowledhe in Javascript. I managed to get it done with following javascript I created. height enterd in cm and weight in kg. script type=text/javascript function updateBMI() { var ht = document.getElementById(HeightID-val).value; var wt = document.getElementById(WeightID-val).value; if(ht!= wt!=){ var bmi = wt/(ht*ht/1); bmi = +bmi.toFixed(2); }else{ var bmi =Enter Height and Weight; } var inputbmi= document.getElementById(BMI-ID-val); inputbmi.value = bmi; } updateBMI(); /script It serves the purpose it seems. Pls suggest any modifications On Mon, Sep 1, 2014 at 11:52 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Pamod -- Pamod -- Pamod ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
Ook. Thanx :) On Tue, Sep 2, 2014 at 2:02 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: Hi it is already inside dhis2 (for every dhis2 page). no need for external import Thanh On Tue, Sep 2, 2014 at 2:17 PM, Pamod Amarakoon pam...@gmail.com wrote: Hi, Thanx. Is jquery available inside data entry form on the fly or has to link it separately to outside library. On Tue, Sep 2, 2014 at 12:31 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: great. surprised that a medical doctor can write that code. if you turn it to jquery it is much easier. anyway, its fine for now On Sep 2, 2014 11:54 AM, Pamod Amarakoon pam...@gmail.com wrote: Hi, Thanks a lot. In fact I'm a medical doctor and have limited knowledhe in Javascript. I managed to get it done with following javascript I created. height enterd in cm and weight in kg. script type=text/javascript function updateBMI() { var ht = document.getElementById(HeightID-val).value; var wt = document.getElementById(WeightID-val).value; if(ht!= wt!=){ var bmi = wt/(ht*ht/1); bmi = +bmi.toFixed(2); }else{ var bmi =Enter Height and Weight; } var inputbmi= document.getElementById(BMI-ID-val); inputbmi.value = bmi; } updateBMI(); /script It serves the purpose it seems. Pls suggest any modifications On Mon, Sep 1, 2014 at 11:52 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Pamod -- Pamod -- Pamod -- Pamod ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
Thanks for the input. I'll have a look at jQuery then! Regards, Robin From: Pamod Amarakoon [mailto:pam...@gmail.com] Sent: 02 September 2014 10:54 To: Ngoc Thanh Nguyen Cc: dhis2-devs; Robin Martens; Jason Pickering; DHIS 2 Users list Subject: Re: [Dhis2-devs] Auto-calculated data in entry forms Ook. Thanx :) On Tue, Sep 2, 2014 at 2:02 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: Hi it is already inside dhis2 (for every dhis2 page). no need for external import Thanh On Tue, Sep 2, 2014 at 2:17 PM, Pamod Amarakoon pam...@gmail.commailto:pam...@gmail.com wrote: Hi, Thanx. Is jquery available inside data entry form on the fly or has to link it separately to outside library. On Tue, Sep 2, 2014 at 12:31 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: great. surprised that a medical doctor can write that code. if you turn it to jquery it is much easier. anyway, its fine for now On Sep 2, 2014 11:54 AM, Pamod Amarakoon pam...@gmail.commailto:pam...@gmail.com wrote: Hi, Thanks a lot. In fact I'm a medical doctor and have limited knowledhe in Javascript. I managed to get it done with following javascript I created. height enterd in cm and weight in kg. script type=text/javascript function updateBMI() { var ht = document.getElementById(HeightID-val).value; var wt = document.getElementById(WeightID-val).value; if(ht!= wt!=){ var bmi = wt/(ht*ht/1); bmi = +bmi.toFixed(2); }else{ var bmi =Enter Height and Weight; } var inputbmi= document.getElementById(BMI-ID-val); inputbmi.value = bmi; } updateBMI(); /script It serves the purpose it seems. Pls suggest any modifications On Mon, Sep 1, 2014 at 11:52 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.commailto:pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More
Re: [Dhis2-devs] Auto-calculated data in entry forms
Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
Hi Jason, I'm not sure if indicators can do the trick as: 1. They're not usable in data entry forms for tracked data; 2. They're not usable for further indicator calculation when used in data entry forms for aggregated data. (It is not possible to use indicators in the calculation of other indicators.) Can you confirm? Kind regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 01 September 2014 18:15 To: Robin Martens Cc: Lars Helge Ă˜verland; DHIS 2 Developers list; DHIS 2 Users list Subject: Re: [Dhis2-devs] Auto-calculated data in entry forms Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Pamod ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Pamod ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Auto-calculated data in entry forms
Hi, Thanks a lot. In fact I'm a medical doctor and have limited knowledhe in Javascript. I managed to get it done with following javascript I created. height enterd in cm and weight in kg. script type=text/javascript function updateBMI() { var ht = document.getElementById(HeightID-val).value; var wt = document.getElementById(WeightID-val).value; if(ht!= wt!=){ var bmi = wt/(ht*ht/1); bmi = +bmi.toFixed(2); }else{ var bmi =Enter Height and Weight; } var inputbmi= document.getElementById(BMI-ID-val); inputbmi.value = bmi; } updateBMI(); /script It serves the purpose it seems. Pls suggest any modifications On Mon, Sep 1, 2014 at 11:52 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Pamod -- Pamod ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp