Help

Re: Automating the auto fill of a table that's constantly being updated

806 0
cancel
Showing results for 
Search instead for 
Did you mean: 
WMB
4 - Data Explorer
4 - Data Explorer

Question: Say that I have 100 records (mined by PR miners) and it would be divided into 5 for the NR miners (NR-A to NR-E), each having 20 records each. 3 hours later, the 100 records are finished and we have more coming from the PR miners, Regardless of which PR miner it came from, I want it to auto populate or to be assigned to an NR miner such that it's even throughout.

Here's what the ideal table should look like:

WMB_0-1681191566970.png

As you can see, the records could've just been mined by PR miner A, but is still evenly distributed into the five NR miners.

 

I apologize for any confusions relating this post. I need your help.

1 Reply 1

Hmm, yeah this is doable.  If I were you I'd create a job queue system where I create a new table with a single record in it and link all the PR records to it

Assuming there's a table where each record is a NR Miner, I would create a "Count" field to count the total number of records linked to each NR Miner, and then use a mix of lookups and formula fields to identify what the largest number of records linked to a NR Miner field is

After that, I would use that information to identify NR Miner's that do not have that number of records linked to them, and then, using that information, I can select one randomly from that list and link a record to that NR Miner via an automation

This in turn would update the job queue system mentioned above