Automation: Creating Child Records based on Parent Record & 2nd Table
Hi all - I am running into an issue that I believe can be done natively before I start exploring non-native solutions.
I am looking to book an order (Table = Order) that needs to be updated on a daily basis (table = Service Update). The length of contract for each order varies. Typically they will take 80 days to complete.
I am looking for a native way to create a number of child record based on the order.
For example, we start the order today (1/10/2019) and the order is expected to take 4 months. I am looking to create records for the order in one batch. Typically there are 21 business days in a month so it would create 84 records ( 4 months * 21 business days in a month ) for service updates.
I have another table ( Service Days ) to show our work schedule ( days we are working ).
For example, if I create an order, I want to create child records related to order (service update) for every day that we are open.
Let's say that we start an order today ( service start date ) and our expected completion date is 80 service days. This means that it would create 80 child records (Service Update) based on the open days, which are checked from the Service Days Table.
Is this something that is possible natively?
------------------------------
Alex Knox
------------------------------
I am looking to book an order (Table = Order) that needs to be updated on a daily basis (table = Service Update). The length of contract for each order varies. Typically they will take 80 days to complete.
I am looking for a native way to create a number of child record based on the order.
For example, we start the order today (1/10/2019) and the order is expected to take 4 months. I am looking to create records for the order in one batch. Typically there are 21 business days in a month so it would create 84 records ( 4 months * 21 business days in a month ) for service updates.
I have another table ( Service Days ) to show our work schedule ( days we are working ).
For example, if I create an order, I want to create child records related to order (service update) for every day that we are open.
Let's say that we start an order today ( service start date ) and our expected completion date is 80 service days. This means that it would create 80 child records (Service Update) based on the open days, which are checked from the Service Days Table.
Is this something that is possible natively?
------------------------------
Alex Knox
------------------------------
