Script to call and compare fields from two different tables

[Arif6]

Can someone guide me how to write JavaScript codes in Script include function for calling and comparing fields from two different tables?

For example F1 & F2 from table1

field F3 & F4 from table2

If I had to wrote a function based on the fields value of F3/F4 comparing with F1&F2

Line if F3 or F4 is between the values of F1 & F2..somthing like that return value from another field from table1

[Nayan Dhamane]

Hello @Arif6 ,

Please use Glide record twice separately for different tables to get the data from the two table you require. If you have a dependency between the records or a common link you can use that as well.

Kindly let me know if you require more detailed solution along with your detailed problem statement.

BR,
Nayan

[Arif6]

Thanks Nayan, Appreciate your response on this!

I used the Gliderecord for twice for these two tables (both are independent custom tables)

however, I am not able to write the codes further, are you able to look at my query here which i explained in detail & share some scripts for this specific scenario? Thank you again!

https://www.servicenow.com/community/incident-management-forum/script-include-function-script-for-co...