Auto populate start and stop times from MI tickets to its child PTASK tickets

[divyal09]

In a Major Incident we have a "Event Start Date/Time" and a "Event End Date/Time". We are being asked to this data to auto populate or be filled in automatically when opening a PTASK ticket. In a PTASK ticket, there is a window where you can enter an Major Incident Number. How can the start and end times auto populate when the Major Incident number is entered.

[AshishKM]

Hi @divyal09, 

Write a BR[update] on table [ problem_task ], read the major incident data and copy to ptask record ( using current object ). 

Replace the correct field name for event start/end date time and parent column with correct field name referring the major incident field.

Ideally, PRB has INC reference and PTASK has PRB reference. So if PTASK can get the incident data using the dot walking. 

-Thanks,

AshishKMishra

[divyal09]

Can't we do this using client script

[Dr Atul G- LNG]

No, as task need to update first in DB and then it come to task level. BR is only and good way to do this. 

[AshishKM]

Yes we can, refer the point 1 explanation by @Amit Verma, you need to write on change client script ( with script include ) or you can write all glide code in client script only..

The difference is 

1) the BR will update data after you update ( Save ) INC number on ptask. Same refer by @Dr Atul G- LNG .

2) the client script will fill the event value based on INC change then you have save the form.