Forum Discussion

SushrutGaikwad's avatar
SushrutGaikwad
Qrew Trainee
7 years ago

Limited the number of records shown in a report with a button.

I have a table that has 10,000 records of data. I have two roles, premium and trial. I want the trial users to be able to search, filter, sort etc on 10,000 records worth of data but the number of rec...
reports and charts
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Not tested but can probably use the now() function to grab the minutes portion of the current time, so for example.  Unfortunately there is not an easy way to get at seconds.

var number Divisor = ToNumber(Left(ToText(Now()),2))

IF(Rem([Record ID#], $Divisor)=0,true)
  • SushrutGaikwad's avatar
    SushrutGaikwad
    Qrew Trainee
    7 years ago
    Thanks. I'll try it out. Where does this code go?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    You can call that formula checkbox field 



     and it will be on your table with the 10,000 records.
    and then have a Custom Role Permissions Rule that the users in the Role

    Trial Users

    can View records where that field is checked.