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

Ankur Bawiskar · ‎03-09-2021

Hi,

you missed the task field in the BR

this is the field on Resource plan which refers your table

current.task.my_tasks_end

current.task.my_tasks_start

Regards
Ankur

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

Anonym · ‎03-09-2021

I tried this, but it makes no difference...

Anonym · ‎03-09-2021

I did add them again, but the dates are still Undefined

Ankur Bawiskar · ‎03-09-2021

Hi,

your BR should not be before insert/update

it should be of type Display and then it would work

When to run -> Display

Also use this

current.task.my_tasks_end

current.task.my_tasks_start

Regards
Ankur

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

Anonym · ‎03-10-2021

Awesome, it works!

Thank you so, so much!