Random "number assignment"
Hi!
I built a junior rodeo app and I'm wondering if there's a way I can do a "random draw" for scorecards.
We have to generate a random sequence of numbers depending on how many players are in t...
Forum Discussion
Renee,
Did you ever solve this with pure QB? I have new business case that needs this as well.
------------------------------
Don Larson
------------------------------
Hi Don ,
i did a couple of tries and the most relevant answer was using the shuffle filter in Jinja but it's not supported via quickbase. I've opened a ticket to ask them if there is a way to emulate the same.
------------------------------
Prashant Maheshwari
------------------------------I have made some minor progress on this. I took the Jinja expression you used
{{range(1,20000)|random}}
to populate a field on the records. That works great as you described.
Next I am trying to pull that field and the RID's into a JSON file and order them by the random number field.
Then I want to extract the RID's from the first 10 records in order by the random numbers.
That will give me my pool of randomly selected records for the business process.
Then I will clear the random field in the original data set.
The hard part is the JSON step but once I have a framework, this should be repeatable for other cases.
------------------------------
Don Larson
------------------------------I spent tonnes of time trying to figure this out during the weekend. The randomizing is a pain that I couldn't resolve , even with some logic in place
- Have a range from 1 to 100
- Start a loop , use random filter to generate one number , add this number to dictionary
- also check if dictionary already has this number , if not , skip , restart loop
Still I couldn't resolve this.
Easier way might be
- I think a better way might be , hire a developer from fiverr/or similar which makes a simple python / gsheet based script to randomize a group of number (also sent via webhook), this script should accept (record id#) from webhook , tableid# , range of number to randomize (1-200 or 200-400 etc)
- Start pipeline to send this request as json/webhook (1 API consumed)
- This script starts, using logic , assigns a number each randomly to each record id# , send the webhook back.
- Using free incoming pipeline action , update records with matching recordid#
------------------------------
Prashant Maheshwari
------------------------------
