Show specific number of record Entered by user.

[pravaah]

In my table there was 100 record but it had some status like "Pending", "Approved" and "Selected". So autonumber will not work for me to select the record according to the status.

In the datapage i am filtering record with status "Selected" and in that record i want to show number of record that entered by the user. Like if user want 5 record so he/she able to view only 5. If 10 then able to view 10 records with same status "Selected"

[Barry]

Hello pravaah.

If you want to count the number of records you can use a Calculated field formula with the "COUNT" function. It is also possible to use authentication fields in the WHERE to filter, https://howto.caspio.com/parameters/parameter-types/#:~:text=Authentication Fields 

SELECT COUNT(unique_id) FROM table WHERE fieldNameFromTable = target.[@field:fieldFromRow]

If you want to filter the results based on the authenticated user, then you can use the record level security feature:
https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/#:~:text=Restrict record access based on user identity