Forum Discussion

HannahEngelson's avatar
HannahEngelson
Qrew Trainee
2 months ago

Random sampling of records

I have an app that will be used for tracking when our employees are due for training. I want to have a table that can randomly pull a certain percentage of records that will receive a formal check event. For example, say I have 200 employees that are due for training this month. I need to pull a random 50%, who have also not had a check event in a certain period of time. Is there any way to do this with Quickbase?



------------------------------
Hannah Engelson
------------------------------

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 months ago

    A very low tech solution would be to use the Record ID if the Employee record and test for even or odd. That will give you about 50%. 

    Extending that thought, you can make a formula field 

    Rem([Record ID#], 3)

    which will return a 0, 1, or 2  that would let you select 1/3rd or 2/3rds  

    Obviously, you can use sny number in the REM function, like 10 to sample different percentages  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------