How to pick the latest record from DB to create a dashboard?

Get Help Database
1

Hi guys!

I’m trying to build a dashboard. Dashboard has to show the latest results from tests (for example last max bench press, latest user’s weight, or neck circumference - this I managed to do), and to make some calculations based on those (let’s say BMI - latest weight/ (latest height)^2.

I’m able to make a rectangle with the latest whatever (I’m filtering the date and sorting), but I have no idea how to make a custom formula with this…

Can you help me?

Zrzut ekranu (140)
Zrzut ekranu (140)344×650 44.1 KB

2

You can do this in Adalo by pulling in the most recent record from your collection and then using that data in your calculation.

You’d select that one box and Make List.

A couple ways to set it up:

  1. On your list or rectangle, sort the collection by Created Date (descending) and set the list to only show 1 item — that way you’re always grabbing the latest record.
  2. For calculations like BMI, you’d want to store weight and height in the same record. Then you can display a magic text formula like Weight ÷ (Height * Height).

Adalo doesn’t allow “cross-record” formulas directly (like comparing one record’s value to another), so the cleanest approach is making sure the inputs you need are saved together in the latest record. Then filtering/sorting handles the rest.

3

Thank you Alex. I figured out no. 1, but didn’t no. 2. However it seems that It will be hardo to make what I want in Adalo. I have a lot of different calculations.

Thank you for your help :slight_smile: