Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 07, 2023 10:33 PM
Hello, I'd like to know how to create new records using automaitons in B table as many as the quantity of number column(ex. 5) in A table when the status column in A table has a specific value(ex. realease).
See the example below.
1. Input
2. Output
I'd appreciate it if you could let me know.
May 07, 2023 10:55 PM
One way to achieve this would be to:
1. Link the two tables together
2. In Table A, create a "Count" field to count the number of linked records
3. Create a "Formula" field to check whether the "Count" field matches the value of the "Quantity" field
4. Create an automation that will trigger when the "Count" field is updated or the "Quantity" field is updated
- Add a conditional step that will check whether the formula field from step 3 passes the check
5. Add a "Create record" step that will create a new record and link it to the triggering record
Here's a base with the above setup for your reference
May 07, 2023 11:22 PM - edited May 07, 2023 11:25 PM
My automation helpers scripts includes a script for generating a list from a number.
You can then use that list in a repeating group. Put your Create record action inside the repeating group.
This method will use only one automation run to create all of the linked records. It also does not require any additional helper fields.
I wrote up an explanation with screen captures here.
Note that automations can have limited advanced logic. If your automation already has a repeating group or conditional logic, you will not be able to add a new repeating group.