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

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