I want to be able to pull a record at random from my table via the js api.
To do so I need to know the max number of records that exist in the table. I have used Auto numbering to create the id ( key field ) of the table. I can then simply generate a rand number and pull the record that has that rand number as it’s id.
How ever I am stuck at present trying to figure out where I can get the number of records from, is there away to query the size of the table? or retrive the last record ( because of the auto numbering it’s ID would be the max record number )
thank you for your help and time.