How to assign the value of the List field in two related tables to another table field?

shiz
Tera Contributor

QA:I hava a table that name is 'Actual_times' And I have another table is 'Actual_times_detail'. The associated field between the two tables is 'ref monday'.

 

The desired function to be achieved: I want to 'Actual_times_detail'.'Actual_hours' = 'Actual_times'.'Monday', How to achieve use to client script?

shiz_0-1733454236109.png

 

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@shiz 

the 2nd table seems to be a related list table.

You should use after update BR on table 1 for copying the value

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

@Ankur Bawiskar Hello

How should we do it specifically? If you could teach me, I would really appreciate it.

@shiz 

we are not fully aware how both the tables are related to each other.

So unless you start it from your side we won't be to know what's being actually configured and where it's failing.

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

Dear @Ankur Bawiskar 

Can you log in to my PDI to help me? I'm sorry because the description may be a bit unclear.