I have a fairly complex ModifyRows action that is intended to populate a cell with information from another table based on a couple of factors. Everything is working well except for one factor that seems to only result in a mistake because (and this is an assumption) the push buttons is moving too fast.
Essentially the action should fill each cell in a column with a RandomItem from a table that meets certain criteria AND is not already in the column. So as the push button goes down the column it should be checking cells it just populated and not using the same number. Unfortunately I still get duplicates on occasion and I am not entirely sure what I am doing wrong or if there is a way to avoid it.
ModifyRows(thisRow, [Daily Tracker 2].Van, if(and(not(thisRow.[Last Van].In([Daily Tracker 2].Van)),thisRow.[Last Van Grounded]=false),thisRow.[Last Van], RandomItem(Vehicles.Filter(and(Grounded=false, not([SDTO #].In([Daily Tracker 2].Van,not([SDTO #].in([Daily Tracker 2].[Last Van])))))),false) ))