so wonderful, thx @Mario and @Federico_Stefanato, the slider is a smart thing in this use case, I learn from that!.
My idea is a bit different it goes in two steps
- the main table with the email addresses
- a second table in which the email adresses are stored that you have used.
This is the main idea, below the code:
You have a button that moves 6 rows to the next table and aftwards deletes them. The rows are random and this is due to the combi of Random() and Sort (from smaller to larger numbers or the inverse). Each time you take out 6 random rows (they move as you can see in the doc).
The Column finding nummers contains :
The checkbox looks for number smaller than 7 in the column finding via:
thisRow.finding < 7
So now we have random 6 rows that we can select and delete aftwards via:
[Main Email Table].Filter(Checkbox=true).email.FormulaMap(AddRow([Email storage],[Email storage].emails,CurrentValue)),DeleteRows(Filter([Main Email Table], Checkbox=true))
This is the formula in the button.
The page you find here
I hope it helps a bit, cheers, Christiaan