I have a simple use case where I need to create multiple records in App B after a record is created in App A.
Consider 3 apps/tables.
1) Request (A form will be submitted)
2) Services
3) Job
I have a one-many from Request to Services. 1 request has many services.
When a request is created (or a request form is submitted)
I need to create a job for each service.
In other words, the number of records created via automation = the number of services added to the request form.
This is a standard foreach loop in programming, and very recently Airtable made this available, and I believe this is baking also for SmartSuite, but for now.
For now, I am checking for updates in the services app. (check image) and assigning the Title field of the update service to the newly created job's service field.
it does the job.
I want to listen to other alternative solutions if possible.
In my case, the Services app will not have other cases where it gets updated (unless a new service is created via grid view and the update trigger will be fired.
That's why this might not be the "cleanest" and I need to make sure the services app is not touched and prevent that from happening by the permissions.
2nd Question to the SmartSuite team.
Artem Kunytsia Nate Montgomery I didn't find such a request in Canny. May you have any updates if this is baking or planned?