Bind last record in table

Wappler General How To
#1

Evening all,
Hope this makes sense.
I have a table that filters the last three records, which is recording current weight, date etc.
I want in the navbar to show a fighters current weight, fighting weight and difference ( above or below)
Now i can do this in a table, but was wondering if you can bind this to an area with something like:

{{getweight.data.query4[0].weight_kg }} this is obviously showing the first record and i want the last.

Ideally, i want to be able to create profiles showing some data from tables.
Attached image of the dashboard, you can see the table with the data I want, but not in a table format, ideally like this under the menu.

Hope that makes sense.

Andrew

49
Screenshot 2019-11-02 at 22.33.49.png2744×1180 265 KB

59
Screenshot 2019-11-02 at 22.41.59.png986×178 17.2 KB

#2

Think I may have gotten it with:

getweight.data.query4[0].weightkg{{.last(1)

1 Like
#3

another alternative:
{{getweight.data.query4[getweight.data.query4.count].weight_kg}}

#4

None of the above working, seems to be pulling the first record and no the last or current…

#5

first count is a function so it should be called with () and it will return the number of records. As the index is zero based you have to subtract one, so the final will be:

{{getweight.data.query4[getweight.data.query4.count()-1].weight_kg}}
4 Likes
#6

Thank you George !!!