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).
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