get a the “page” field value from database “daily records” having “date” field as maximum
if the record list as follows:
| date | page |
|---|---|
| 10 Feb 24 | 96 |
| 1-Jan-24 | 33 |
| 03 Jun 24 | 564 |
| 14 Mar 24 | 140 |
I want to the result to set text = 564 the page with max(date)
how can I do this ?
Hello, you can click on the list, and select “Sorting”. Then you can choose the page property ( Highest to lowest ).
Thank you!
Thanks @Ali-Bazzi for your response,
I want to get the value not by clicking
for example: I want the progress bar to take the “page number” based on most recent date
so I won’t be able to click , it just has to show the value in a report or progress bar !
You’re welcome! As I’ve understood, you’d like to show the current page name in a progress bar?
Thank you!
yes , correct
say I have a book, I read and when finish I review repeating from page 1 , at the current time I want to check the progress of reading the book by showing the page number I have reached to when the date = max (most recent date)
@alim_maze, problem solved?
