Urgent! How to auto-populate fields in related lists?

Anonym · ‎03-09-2021

Hey I have a very important problem:

I have a table which was created by extending the task table called x_582999_my_tasks. This table has the fields my_tasks_start and my_tasks_end.

As well I added the Resource Plan table to the related list of my new table. Now I want to auto-populate the start_date and end_date field of the resource plan, I can create in the related list, with the gives dates of my related task.

How can I do this?

I´m new in Service Now Scripting so it would be very helpful if you may help me with full scripts and the place I need to insert them.

Thank you so much!

Ankur Bawiskar · ‎03-09-2021

Hi,

So on the table x_582999_my_tasks you have related list of Resource plan

I assume Resource plan has a reference field to your Custom table (x_582999_my_tasks)

So you can use this logic to set the value on Resource plan based on Start and end

Display Business rule on resource plan table

g_scratchpad.start = current.<field_which_refers_customTable>.my_tasks_start;

g_scratchpad.end = current.<field_which_refers_customTable>.my_tasks_end;

Client Script: on the resource plan table

function onLoad(){

g_form.setValue('start_date', g_scratchpad.start);

g_form.setValue('end_date', g_scratchpad.end);

}

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Anonym · ‎03-10-2021

One more question: If I dont have a reference field like the task field, is it possible as well?

Ankur Bawiskar · ‎03-10-2021

nope

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader