ContributionsMost RecentMost LikesSolutionsIssue with Relationships & AutomationsRe: Automation: Creating Child Records based on Parent Record & 2nd TableHi Mark - Thank you! I am going to look at this over the weekend and if I have any questions, I will post here ------------------------------ Alex Knox ------------------------------ Automation: Creating Child Records based on Parent Record & 2nd TableHi 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 ------------------------------ Re: Save function ImprovementWow...wish I figured this out months ago. Thank you - works like a charm! ------------------------------ Alex Knox ------------------------------ Save function Improvement Hi all - Currently I have a formula URL that creates a child record and then it will save & next the record. Currently, it is slowing down the end user because the button is adding an activity following a phone call so typically the user will be in edit mode (not a problem) and will edit the fields one way or another ( update contact information for example ) and then they will press the button labeled "Spoke Live," which runs the formula URL mentioned in line 1. When they press this button, a pop up shows up asking them to save the record because changes were made to the record (Lead). <--- this is the problem Here is the code for the URL: var Text SpokeLive=URLRoot() & "db/" & [_DBID_XXX] & "?a=API_AddRecord&apptoken=XXXXXXXXX&_fid_10=" & URLEncode ([Record ID#]) & "&_fid_17=Spoke Live"; "javascript:{"& "$.get('"& $SpokeLive &"');"& "javascript:DoSaveAndNext();"& "}" What do I need to change so when the user clicks on the button, it will save all the changes that user made while in edit mode, run the voicemail variable, and then goes to the next record in their report. FYI - The code works fine. I want to bypass the pop up window that asks the user to save the changes. Thank you.