Skip to main content
Question

Random sampling of records

  • March 7, 2024
  • 0 replies
  • 143 views
Forum|alt.badge.img+8

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement