Let's say we are building a house in Site A. There are 3 tables to consider;1. Activities table2. Parts master list table and3. Build parts table.Whenever a record is created in the activities table the automation pulls the parts needed for that building in site A from the master list and populates it in the build parts table. Now if I want to add 49 parts, I can do so by going to the activities table and I can pick the parts and quantities I need for that building. I cannot add more than 49 parts because of the limitation of the automation. So if there are 100 parts I can only add 49 parts at a time. I want to migrate this automation to pipeline but there are more than 26 steps and I cannot migrate to pipelines. I am looking for an efficient way to optimize this automation to less than 26 steps.I was reading about callable pipeline. will it work in this situation?For each part I want to add there are different steps.
That parts section should probably be a subtable. Then you could do a search for child records and do a bulk record upsert.
You might be able to get away with setting up a formula to create a list, and then doing a regex in a pipeline to parse out the information and then perform the bulk record operations.