Jump to content

Show specific number of record Entered by user.

Recommended Posts

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"

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 3 weeks later...

Hi Barry this use to count the number of records into the table with some condition. But i want to select dynamic number of record form the table. Which was inputted by the user. And the output will change the status. And that selected record not visible to another user with same access.

Link to comment
Share on other sites

  • 2 weeks later...

Hi All,

I had created one solution for that.

1. create a virtual field to search the Number of Record that you want to show to the user.

<script type="text/javascript">

### this will help to enter only number into the filed.

2. Now pass the value to the table view.

<script type="text/javascript">
let isFlag = true;
document.addEventListener("DataPageReady", function (event) {
  if (isFlag) {
    let valueGetting = document.getElementsByName(

    let newOption = document.createElement("option");
    newOption.text = valueGetting;
    newOption.value = valueGetting;
    let selectElement = document.getElementsByClassName(


    newOption.selected = true;
    isFlag = false;



### with some style to hide the footer of the table.


display:none !important;
display:none !important;


3.I am also updateing the selected record after selection i will refresh the page so user can enter record again.

<script  type="text/javascript">
const actionButton = document.querySelector(".ActionButton");

actionButton.addEventListener("click", function() {

  window.location= "your url link? For redirection";

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...