Lookup Table
Hello
We have created a database for orphan-care in Africa. The nurses see each child and record the health each child they see. If a child's weight is low, the nurses need to know immediately, so they can refer the child for special assistance.
The child's health is determined by a guide the World Health Organization has issued (refer http://www.who.int/childgrowth/standards/chts_wflh_girls_z/en/).
For example, if a child is 60cm tall, then it should weigh 6Kg. If it's under that, then an alert should appear.
So, we'd either need a complex IF THEN ELSE or a Lookup Table.
Eg:
IF Height >= 50 AND =<60 AND Weight < 6, "ALERT"
ELSEIF Height >60 AND <70 AND Weight <7, "ALERT"
etc, etc
Is it possible to do this in Ninox? I'm not really a coder. If it is possible, would anyone be willing to code this for a fee?
Many thanks in advance
Brian
4 replies
-
@Brian.. I posted some questions under your other thread. as well as sent you an email.. :) Yes it is more than possible.. I just need some additional information as to how to use the table version of that chart.
-
Hi Brian,
please also reach out to support@ninoxdb.de
We can set up a screen sharing session and are more than happy to help.
Best regards, Alex
-
Happy Boxing Day Alex.. I importing the expanded tables found here for Brian
https://www.who.int/childgrowth/standards/en/
And will provide him a look up against those charts.
-
For the benefit of the community.... Here is what I did..
1. Downloaded and combined the expanded WHO standards table, and added a chart and gender indicator.
2. Next, I imported it to a temporary table.. then parsed it into a look up table with min / max values per rating.
3. Then added a formula field that looks up the rating based on age and measurement.
Next.. I will add some style rules / code to color code based on requirements.
Content aside
- 5 yrs agoLast active
- 4Replies
- 2976Views