AutoPopulate field value from one table to another table.

Nafisa Zaman
Tera Contributor

I want to Auto populate one field value from "xyz" table to incident table field and the record for that "xyz" table is created through a hyperlink. How can I achieve this thing from script? Please suggest some ideas.

 

NafisaZaman_1-1697616558212.png

 

This field value I want to auto populate in incident field.

7 REPLIES 7

Anurag Tripathi
Mega Patron
Mega Patron

Is the record on XYZ table and Incident related somehow? 

Can one track this (some field on incident or XYZ like parent or related record etc)

-Anurag

Peter Bodelier
Giga Sage

Hi @Nafisa Zaman 

 

The basic anatomy of the url is:

https://<instance name>.service-now.com/nav_to.do?uri=incident.do?sys_id=-1%26sysparm_query=number=123567

 

incident — this is the name of the table you're redirecting to
sys_id=-1 — passing negative one as the sys_id tells ServiceNow you're opening a new record
sysparm_query — this is the parameter where you will set your values
number=123567 — this is the encoded query you will use to set the number field


Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

newhand
Mega Sage

@Nafisa Zaman 
I'm not sure if i have completely understaned your question.
When you clicked the hyperlink(ui action ?), one record for xyz table will be created with some values or  the page will be redirectly to a new form to create the xyz record ?

 

 

 

 

Please mark my answer as correct and helpful based on Impact.

@newhand 

one record for xyz table will be created with some values