Forum Discussion
MargueriteKeati
2 years agoQrew Trainee
Mark and Jeff both mentioned some potential solutions. Agreed there isn't an easy answer to this specific issue in QB.
Another option would be to use the Jinja Random function in a pipeline based off the Rec ID#, limit the result to 1k records, and then have the pipeline mark those 1000 random records with a checkbox. That way the report could be filtered to only show 1k records and be random.
------------------------------
Marguerite Keating
Quickbase Developer
Synctivate Inc
marguerite@synctivate.com
www.Synctivate.com
------------------------------
Another option would be to use the Jinja Random function in a pipeline based off the Rec ID#, limit the result to 1k records, and then have the pipeline mark those 1000 random records with a checkbox. That way the report could be filtered to only show 1k records and be random.
------------------------------
Marguerite Keating
Quickbase Developer
Synctivate Inc
marguerite@synctivate.com
www.Synctivate.com
------------------------------