0

Problem with last()

Hi to all,
I have a table containing 189 records and I get the value of a field from the last record (most recent record) with the command:
last ((select Table. Amount).

In the apps for Mac, iPad and iPhone works properly.

But in the web App (i tried Safari, Chrome, Firefox, Edge, Chromium - macOS and Windows) always gets the record with Id 99.

Date settings are the same in the System and Browsers.

Any ideas?

5 replies

null
    • Nick
    • 4 yrs ago
    • Reported - view

    sorry

    last((select Table).Amount)

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Something like this? 
    let last:= last(select Table)

    select Table where Id= last . Amount

    Need some tweaking i guess, can't try here. I'm on my phone...

    Steven.

    • Nick
    • 4 yrs ago
    • Reported - view

    Thanks Steven but I tried...

    let mylast := last((select Table).Id);
    mylast

    gives 99

    • Sean
    • 4 yrs ago
    • Reported - view

    Yep, I just tried it with Safari and got the same result.

    • Nick
    • 4 yrs ago
    • Reported - view

    OK, i think this is it...

     

    let maxId := max((select Table).number(Id));
    maxId

Login to reply

Content aside

  • 4 yrs agoLast active
  • 5Replies
  • 1632Views