The following elements are included in this dashboard:

• Peak Flow calculator - database

• Calendar view - database

• Asthma symptoms tracker - linked database

• Weather widget - embed

Peak Flow Calculator (PEFR)

Let's begin with how to create a Peak Flow Calculator. This will determine an estimated flow rate with a formula. The following properties are needed to find a formula result:

• Age - number

• Height (inches) - number

• Sex - select

• Height (cm) converter - formula

  • prop("Height (inches)") * 2.54

• Height (m) converter - formula

  • prop("Height (inches)") * .0254

These properties will be plugged into the following mathematical formulas:

• Children PEFR = ((Height in cm - 100) x 5) + 100

• Adult Men = (((Height in m x 5.48) + 1.58) - (Age x 0.041)) x 60

• Adult Women = (((Height in m x 3.72) + 2.24) - (Age x 0.03)) x 60

And so, the Estimated Flow Rate formula will look like this:

if(prop("Age") > 17 and prop("Sex") == "F", round(100 * (prop("Height (m) conversion") * 3.72 + 2.24 - prop("Age") * 0.03) * 60) / 100, if(prop("Age") > 17 and prop("Sex") == "M", round(100 * (prop("Height (m) conversion") * 5.48 + 1.58 - prop("Age") * 0.041) * 60) / 100, if(prop("Age") < 18, round(100 * (prop("Height (cm) conversion") - 100) * 5 + 100) / 100, 0)))

Peak Flow Variability

Used to determine the daily asthma condition in comparison to a "healthy" patient. This formula will require only one extra property: Actual Flow Rate - number. The result will require this formula (feel free to change emojis):

if(prop("Actual Flow Rate") / prop("Estimated Flow Rate") >= .8, "💚Green Zone", if(prop("Actual Flow Rate") / prop("Estimated Flow Rate") >= .5, "💛Yellow Zone", if(prop("Actual Flow Rate") / prop("Estimated Flow Rate") < .5, "❤️Red Zone", "")))

Zone Explanation

Green Zone: Close to normal function

Yellow Zone: Narrow respiratory passage

Red Zone: Likely a medical emergency

Asthma Symptom Tracker

Next I provide an "/inline table" for daily asthma symptom tracking which has the following properties:

• Date - date

• Triggers - multi-select

• Symptoms - multi-select

• Severity - select

• Weather - select (reference widget)

• Relief Doses - number

• Flow - select (reference calculator)

• Notes - text

COPY TEMPLATE