Hmm, if there are only a few bundles and these don’t change much, maybe you could create automations for this?
So you’d have a table called “Bundle Logs” or something, and in this table there would be the following fields:
- Name of the cohort using it (Or a linked field to the
Cohorts
table if such a thing exists)
- Bundle name (Single select probably)
- Linked field to the table you’re using to track inventory movement (optional)
And you’d then have an automation that would, on creation of a record in the Bundle Logs
table, would create the appropriate records in the table you’re using to track inventory movement, linking each line item to the right cohort
E.g. maybe one of your bundles is called Bundle A
, and it contains 3 each of Item 1, 2, and 3
When you create a record and select “Bundle A” in the single select and link it to the appropriate cohort, the automation would then create one record each for each item in the table you’re using to track inventory movement, with quantity and cohort set