0

syntax "last(select table)" issue

Hi,

 

I have small problem with this syntax.

Does the select statement of a record from a table only goes with the first last 9 entries?

 

I have a table of many about 100 records and ongoing (currency rates which will be updated every once a week) to pick always the latest one entry when creating a new record in another table.

Instead of manually choose the latest currency rate from the Currency Table, I created a button to auto select latest entry from that table when needed. The formula in the button "On click" is:

 

'Currency Rates' := last(select 'Currency Rates')

 

 

It seems however, that it only selects the latest of the first 9 entries of all and ignore the entries recorded afterwards.

 

Screenshot 2021-07-15 at 4.49.24 PM

 

Screenshot 2021-07-15 at 4.49.38 PM

Screenshot 2021-07-15 at 4.55.20 PM

 

Screenshot 2021-07-15 at 4.49.03 PM

 

Thanks for clarification.

Sebastian

3 replies

null
    • sebastian
    • 2 yrs ago
    • Reported - view

    Sorry, uploaded the pic too small.

     

    Screenshot 2021-07-15 at 4.59.37 PM

    • John_Halls
    • 2 yrs ago
    • Reported - view

    Hi Sebastian

     

    I would suggest sorting the table

     

    'Currency Rates' := last(select 'Currency Rates' order by Date)

     

    Regards John

    • sebastian
    • 2 yrs ago
    • Reported - view

    Hi John,

    thanks. simple but effective. I knew I was missing something. I thought that ninox already sort the records of a table according to Id No and knows what was the first and what was the last entry.

     

    Rgds Sebastian

Content aside

  • 2 yrs agoLast active
  • 3Replies
  • 288Views