Forum Discussion

HannahEngelson's avatar
Qrew Trainee
3 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

  • 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)