Dynamic Values

Wappler General
1

Hello All,

Just trying to think this through. I’ve got 2 Tables in a DB.

Table A is normal Blood Reference Ranges - here, Test, Gender, Low, Hi, Measure

Table A
Red cell count (RCC), Male, 4.5, 6.5, 109/L
Red cell count (RCC), Female, 3.8, 5.8 109​​​​​​​/L

Table B is a result - so Date, Result, Measure

Value Set as Male

Table B
01/01/2022, 5.4, 109/L
02/02/2022, 3.1, 109/L

You’ll see that the second entry above falls below the normal blood values for a Male, Low (4.5), High(6.5)

What do I need to think about in terms of getting

Table B to show a red background on results that fall below LO, Male in table A?
Table B to do something - ie. activate a Warning Model or send an email when the above is triggered?

So if value B falls =< or => than Lo, Hi in A, then do something.

I’m just not sure of the pieces I need to put in place to make this happen.

Any pointers anyone?

Cheers
M

2

You could use a Conditional region within the table cell to display a styled exclamation icon (text-danger etc), for example, or apply Dynamic Attribute styling to the cell also (defining a class based upon the result returned), or both.

We do this to display specific icons, example below:

example
example983×437 48.8 KB

Which is applied to a span within the cell:

<span is="dmx-if" id="Income" dmx-bind:condition="(Income_Expenditure == 1)">{{translatedPhrases.value.income}} <i class="fas fa-arrow-alt-circle-up color-green-dark"></i></span>
1 Like
3

Thanks Dave :slight_smile: That’s really helpful

1 Like