BMI Tracker

Log weight and height check-ins per person, get BMI and its WHO category automatically, and track progress toward a goal weight.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Healthcare

Tables

People, Check-ins

Fields

20

Views

grid, form, calendar, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

People

11 fields · 3 sample rows

  • People (Grid)
NameTextDate of BirthDateAgeFormulaSexSingle selectStarting Weight (kg)NumberGoal Weight (kg)NumberCheck-insLink to another tableCheck-in CountCountLowest Weight (kg)RollupLost So Far (kg)FormulaLast Check-inRollup
Rajesh Kumar12 Apr 198244Male92.078.024 Sep 2026, 22 Oct 2026, 19 Nov 2026385.16.91795046400000
Sarah Mitchell3 Sep 199036Female74.065.08 Oct 2026, 12 Nov 2026270.23.81794441600000
Ananya Das22 Jan 199729Female48.052.016 Nov 2026149.5-1.51794787200000
Field details
Name · Text
Date of Birth · Date
Age · Formula
IF({Date of Birth}, DATETIME_DIFF(TODAY(), {Date of Birth}, 'years'), BLANK())
Sex · Single select
Female, Male, Other
Starting Weight (kg) · Number
Goal Weight (kg) · Number
Check-ins · Link to another table
Links to Check-ins
Check-in Count · Count
Lowest Weight (kg) · Rollup
min of Weight (kg) via Check-ins
Lost So Far (kg) · Formula
IF(AND({Starting Weight (kg)}, {Lowest Weight (kg)}), {Starting Weight (kg)} - {Lowest Weight (kg)}, BLANK())
Last Check-in · Rollup
max of Date via Check-ins

Check-ins

9 fields · 6 sample rows

  • All check-ins (Grid)
  • Log a check-in (Form)
  • Calendar (Calendar)
  • Progress (Dashboard)
DateDatePersonLink to another tableWeight (kg)NumberHeight (cm)NumberBMIFormulaBMI CategoryFormulaWaist (cm)NumberBody Fat %PercentNotesLong text
24 Sep 2026Rajesh Kumar92.0175.030Obese102.0
22 Oct 2026Rajesh Kumar88.4175.028.9Overweight99.0Started evening walks.
19 Nov 2026Rajesh Kumar85.1175.027.8Overweight96.0
8 Oct 2026Sarah Mitchell74.0165.027.2Overweight31.0%
12 Nov 2026Sarah Mitchell70.2165.025.8Overweight28.5%
16 Nov 2026Ananya Das49.5162.018.9HealthyGaining steadily on new meal plan.
Field details
Date · Date
Person · Link to another table
Links to People
Weight (kg) · Number
Height (cm) · Number
BMI · Formula
IF(AND({Weight (kg)}, {Height (cm)}), ROUND({Weight (kg)} / POWER({Height (cm)} / 100, 2), 1), BLANK())
BMI Category · Formula
IF(AND({Weight (kg)}, {Height (cm)}), IFS({Weight (kg)} / POWER({Height (cm)} / 100, 2) < 18.5, 'Underweight', {Weight (kg)} / POWER({Height (cm)} / 100, 2) < 25, 'Healthy', {Weight (kg)} / POWER({Height (cm)} / 100, 2) < 30, 'Overweight', TRUE(), 'Obese'), BLANK())
Waist (cm) · Number
Body Fat % · Percent
Notes · Long text

Form view “BMI check-in” asks for: Date, Person, Weight (kg), Height (cm), Waist (cm), Body Fat %, Notes.

BMI Tracker: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates