Skip to main content

Hello guys!
I work at a biotechnology company and we use bioreactors to produce fertilizers. My problem is the following:

I have a database with two tables: Orders and Tasks
One of the fields in the Projects table automatically calculates the number of fermentations (tasks) I have to run depending on the volume of fertilizer I need to produce. The calculation considers the total volume that must be made per order, the number of bioreactors I have available at the time of the order, and the production capacity of each bioreactor.

Since the number of brews (tasks) is dynamic, I would like to automatically create a Task list for each order.

For example, if I need to perform 17 fermentations (tasks) in a given order, I would like 17 new records to be created in the Tasks table and associated with the order.

Thanks to anyone who can help!

Hi @Luiz_Gustavo_de_Alme - this post contains a solution to a similar problem:

You will need a script or script based automation to achieve this.

Thank you, @JonathanBowen !

Hey ​@Luiz_Gustavo_de,

A script will get the trick done, and that is usually what I do.

The only no-code way which I can think of to handle this would be to:
1. Have an additional table (e.g. Dates) and link all 17 records to your order record.
2. Then, when a given action triggers the automation you would have a Find Records action which will find all records where Dates has any of Record ID of the order which triggered the automation.
3. Then have a repeating group (input: list of records found under the Find Records action).
4. For last, within the repeating group you would have a Create Records action, to create tasks on the Tasks table, and have it linked to the Order. This will create all 17 tasks.

The above is just a workaround in case any future reader does not feel super comfortable with scripting!

Mike, Consultant @ Automatic Nation

Terms & ConditionsAccessibility statement