How to copy fields value from Parent to Child form?

[Erica2]

Hello everyone,

My use case is in my parent form, I have meeting start and end date fields where the end user select the dates. 

I also have the same fields in my child form.  How do I copy the start and end date from the parent to child form when the record is insert or update so that those dates will show up in the child form as well?

Thanks

[Brian Lancaster]

I would do a before insert/update BR on the child table. This is making some assumption like that they field names are.

var gr = new GlideRecod('parent table');
gr.addQuery('sys_id', current.parent);//you will need to repace parent with the correct field name if parent is not the field on the child record.
gr.query();
if (gr.next()){
   current.start_date = gr.start_date.getDisplayValue();
   current.end_date = gr.end_date.getDisplayValue();
}

[Erica2]

Hi @Brian Lancaster 

The parent is the field on the child. I don't where I did wrong, but the BR did not trigger. 

 I create BR on the Child Table. Here is my entire code, could you please take a look?  Thank you

[Brian Lancaster]

On the child table do you have a reference field to the parent table? It may not be called parent. For example on the sc_task table the reference field to the parent is called request_item. Also since this is a before business rule you should not current.update() as it is not needed and cause other BRs to trigger again.

[Erica2]

@Brian Lancaster 

I looked the parent field in the child table and it is current point to task table.  Do I need to create a new field called parent_value and reference it to the parent table?

Currently the Parent and the child is extended to task table.

[Brian Lancaster]

If you add parent to the list layout does it have the correct info in it. AKA the correct number and if you click on it does it take you to the parent?