I am trying to create a database of customers that assigns each person to a group and creates new groups as more customers flow into the database.
For example, over a span of 2 weeks, we might get 10 new customers. I would want customers 1-4 to be assigned to group A, customers 5-8 assigned to group B, and customers 9-10 to group C.
Then, every 2 weeks, the list of customers and their groups is released. I table columns would be:
- Batch identifier (e.g. Jan 1-14, Jan 15-30)
- Group Identifier (e.g. A, B, C, etc.)
- Customer name & email.
I’ve created a table, tried using a Digest, scheduler, and delay but can’t quite seem to put the pieces together. Help!
Thank you
