Random sampling of records

Question

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

markshnier__you · Answer

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%.&nbsp;
Extending that thought, you can make a formula field&nbsp;

Rem([Record ID#], 3)

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

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

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

Forum Discussion

Random sampling of records