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,

it should work fine.

please share the screenshots for the form which shows the date is populated

Regards
Ankur

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

Anonym · ‎03-09-2021

I know that it should work fine, but sadly it doesnt. Here is the resource plan form where I try to populate the fields:

Anonym · ‎03-09-2021

What would be best practice if there wouldnt be a reference field like the task field?

Ankur Bawiskar · ‎03-09-2021

Hi,

are all the 4 fields of type date or date/time? I assume so

can you try adding info message for the dates

g_scratchpad.start = current.task.my_tasks_start;

g_scratchpad.end = current.task.my_tasks_end;

gs.addInfoMessage('start' + g_scratchpad.start);

gs.addInfoMessage('end' + g_scratchpad.end);

Regards
Ankur

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

Anonym · ‎03-09-2021

Yes, all of these fields are in date format.

So I added the info messages code you sent, but it doesnt change anything. There is still the "Undefinded" Message in the Date fields of the resource plan.

What can I try now?