Has anyone come up with Formula-URL code to both copy the master (parent) record with all detail (child) records, easy enough, but then include in the same button a predetermined edit to each of the detail records replacing a few fields in each child?
For example: Let's say the master is an invoice and the details are the line items containing item description, quantity and price. The Formula-URL copies the master and all details but then continues by changing the price in each record to zero.
I know I can include a button on each record to manually replace the field in each record and I know I can include a formula in the edit form to replace the price after creating the new detail records when going into edit mode. But I want it to happen automatically upon creation of the new records. Is there any way to do this? Thank you.